MS Access Quiz

What is the primary purpose of a database management system (DBMS)?

• To create and edit documents

• To organize and manage information

• To design and develop websites

• To communicate with other computers

Which of the following is not a component of a database?

• Fields

• Records

• Tables

• Queries

What is the correct data type for storing numerical values in a database?

• Text

• Number

• Date/Time

• Currency

How do you establish a relationship between two tables in MS Access?

• By creating a query

• By adding a field to each table

• By using the "Relationships" view

• By creating a form

What is the purpose of a query in MS Access?

• To create a new database

• To design a table

• To extract and analyze data

• To create a report

Explain the difference between a field and a record in a database.

Describe the steps involved in creating a simple query in MS Access.

What is the purpose of referential integrity in a database?

How can you use validation rules to ensure data accuracy in a database?

What are some common types of reports that can be created in MS Access?