NEW
Font size
WorksheetsS2 Microsoft Access Database Quiz
Total questions: 15
Worksheet time: 8mins
What is the primary purpose of a database?
To create presentations
To store and organize related data in a structured way
To edit photos and videos
To browse the internet
Which view in Microsoft Access allows you to modify the structure of a table?
Form View
Report View
Design View
Print View
In Microsoft Access, what is a field?
A collection of records
A type of report
A column that contains specific information about an item
A backup copy of the database
What does Datasheet View display in Access?
Only the field names
The data in a table format with rows and columns
The relationships between tables
The database security settings
Which of the following is a valid data type in Microsoft Access?
Circle
Picture
Number
Graph
What is a record in a database?
A single row of information in a table
The name of a field
A type of query
A database password
How are fields displayed in Design View?
As a spreadsheet
As a form
One field per row with properties
As a report
Which data type would you use for storing large amounts of text?
Currency
Memo
Yes/No
Number
What is the maximum number of fields allowed in an Access table?
255
1000
500
2048
Which view would you use to enter data into a table?
Report View
Query View
Design View
Datasheet View
What is the purpose of a primary key in a database table?
To lock the database
To sort the data
To uniquely identify each record
To format the text
Which data type would you use for storing dates?
Text
Number
Currency
Date/Time
What happens when you delete a record?
The entire table is deleted
All similar records are deleted
The selected row and its data are permanently removed
The database is corrupted
Which of the following is NOT a valid field name in Access?
First_Name
Customer#
Address.Street
PhoneNumber
What is the default data type for new fields in Access?
Number
Text
Currency
Auto Number
