NEW
Font size
WorksheetsICT Unit Test Topic : DBMS - Access
Total questions: 15
Worksheet time: 17mins
What is a Primary Key?
It is a key composed of columns that actually have a logical relationship to other columns within a table.
It is a key used to link two tables together
It is a technique which organizes tables in a manner that reduces redundancy and dependency of data.
It consists of one or more columns whose data contained within is used to uniquely identify each row in the table.
What software do you use to make databases?
Access
Excel
PowerPoint
Word
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
Which of these rows would be the primary key?
Student ID
First Name
Last Name
John and Smith
What is the name of the Table in the diagram?
Table1
Customers
New
Customer
Which of the following is NOT a purpose of database?
To collect records
To store records
To perform calculations
To create a letter
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
What are the best match for below data type description?
A simple alphanumeric data type such as names, titles, etc. which is limited to a maximum of 255 characters in length, which is controlled by field size.
Short Text
Long Text
Number
Currency
What are the best match for below data type description?
A simple data to store integer or numeric data such as 1, -100, 1000 etc.
Short Text
Number
Date/Time
Currency
What are the best match for below data type description?
Data values for the years 100 through 9999.
Short Text
Long Text
Date/Time
Currency
What are the best match for below data type description?
Monetary data, stored with 4 decimal places of precision.
Short Text
Long Text
Date/Time
Currency
What are the best match for below data type description?
Unique value generated by Access for each new record.
AutoNumber
Long Text
Date/Time
Currency
