WorksheetsMicrosoft Access Quiz
Total questions: 17
Worksheet time: 9mins
What is Microsoft Access primarily used for?
Creating presentations
Storing and managing data
Writing documents
Editing images
Which field type is best for storing the title of a book?
Number
Short Text
Yes/No
Date/Time
What is the purpose of a primary key in a table?
To sort data alphabetically
To uniquely identify each record
To make the table colorful
To group similar data
Which data type is used for a field that will store only 'Yes' or 'No' values?
Text
Number
Yes/No
Currency
What is the default view for entering data into a table?
Design View
Form View
Datasheet View
Layout View
Which of these is NOT a valid Access data type?
Text
Number
Spreadsheet
Currency
What symbol represents a primary key in Design View?
#
*
!
Key Icon
What is a Query used for in Access?
To delete records
To search and filter data
To change field names
To design forms
Which data type should be used for the 'PublishedYear' field?
Text
Date/Time
Number
Yes/No
In which view can you change the structure of a table?
Datasheet View
Design View
Form View
Print Preview
What does the AutoNumber data type do?
Automatically generates a unique number for each record
Sorts data automatically
Deletes duplicate records
Creates random text
Which of these is an example of a 'record'?
A single row in a table
A single column in a table
The table title
A primary key icon
What is the main function of a table in Access?
Display data graphically
Store and organize data
Print data
Create animations
What happens if you delete a primary key?
The table is locked
The records are sorted
You can no longer uniquely identify records
Nothing happens
Which view allows you to format and arrange the layout of data?
Datasheet View
Form View
Design View
Query View
What is the main purpose of a database?
Create documents
Manage and store data efficiently
Browse the internet
Edit videos
How do you ensure no two records have the same BookID?
Set it as AutoNumber
Use the Sort option
Create a Query
Enable duplicate records
