NEW
Font size
WorksheetsKuiz Microsoft Access
Total questions: 10
Worksheet time: 5mins
Which of the following is the primary object used to store data in Microsoft Access?
Queries
Reports
Tables
Forms
What is the purpose of a query in Microsoft Access?
To display data in a structured format
To create a relationship between two tables
To retrieve specific data from one or more tables
To store data
Which of the following is used to define how data in two related tables can be combined?
Forms
Field Size
Relationships
Data types
Which object in Microsoft Access allows users to enter, modify, and view records?
Reports
Queries
Tables
Forms
What is the primary purpose of Reports in Microsoft Access?
Data entry
Data retrieval
Displaying data in a printable format
Storing data
Which of the following is NOT a data type in Microsoft Access?
Text
Currency
Image
Date/Time
What does the Field Size property determine in Microsoft Access?
The appearance of the field
The maximum number of characters a field can contain
The type of data the field can store
The relationship between tables
Which of the following is NOT a function of a query?
Sorting data
Calculating totals
Designing the layout of a form
Filtering data
In a one-to-many relationship in Microsoft Access, which side has the primary key?
One side
Many side
Both sides
Neither side
Which data type in Microsoft Access is best for storing large amounts of text?
Text
Long Text
Number
Date/Time
