MS Access Database Concepts Quiz

Which of the following best defines a table in MS Access?

• A file that stores text and images

• A collection of records organized in rows and columns

• A layout used to print data

• A tool to sort and filter information

Which data type should you use to store a phone number in an MS Access table?

• Number

• Text (Short Text)

• Currency

• Date/Time

What is the purpose of setting a primary key in an MS Access table?

• To ensure no duplicate records exist

• To increase the speed of queries

• To allow multiple users to access data

• To provide additional security

What is the purpose of a foreign key in a database?

• To store unique records in a single table

• To establish a relationship between tables

• To allow users to input data into a form

• To automatically calculate totals in queries

Which of the following is NOT a valid data type in MS Access?

• Hyperlink

• Memo

• Audio

• Currency

Which MS Access feature is used to extract specific information from a database?

• Report

• Form

• Query

• Relationship

A relational database is defined as a database that…

• Stores data in separate but related tables

• Stores all information in one large table

• Uses only one primary key per database

• Cannot be modified once created

Which relationship type ensures that each record in the first table is linked to only one record in the second table?

• One-to-One

• One-to-Many

• Many-to-Many

• Many-to-One

What does the term ‘referential integrity’ mean in database relationships?

• A field must contain only numbers

• A foreign key value must match a primary key in another table

• A database cannot contain more than two tables

• Data in a query cannot be updated

Which of the following statements about queries is FALSE?

• Queries can filter data

• Queries can be used to update records

• Queries can display data in reports

• Queries cannot be modified after they are created