Kuiz Microsoft Access

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