Quiz on Microsoft Access Objects

What is the primary purpose of tables in MS Access?

• To create user-friendly interfaces

• To retrieve specific data from tables

• To store data in rows and columns

• To format and present data

Which of the following is a unique identifier for each record in a table?

• Foreign Key

• Primary Key

• Record

• Field

What type of query is used to retrieve and display data based on specified criteria?

• Select Query

• Action Query

• Delete Query

• Update Query

What is the main function of forms in MS Access?

• To simplify data entry and viewing

• To store data in a structured format

• To create relationships between tables

• To summarize data

Which type of form is used solely for inputting new data into the database?

• Display Form

• Data Entry Form

• Summary Form

• Navigation Form

What is the purpose of reports in MS Access?

• To create new tables

• To format and present data

• To retrieve data from queries

• To manage user permissions

Which of the following is NOT a component of a table?

• Primary Key

• Fields

• Records

• Queries

What does a foreign key do in a database?

• Stores data in rows

• Retrieves data from queries

• Identifies a unique record

• Links to the primary key of another table

Which type of query performs actions like adding or deleting records?

• Action Query

• Update Query

• Filter Query

• Select Query

What is a key feature of reports in MS Access?

• They cannot group data

• They are used for data entry

• Can group and sort data to make it easier to analyze

• They can only display data in tabular format