Mastering Access Data Management

What is the primary purpose of data types in Microsoft Access?

• To format the text in a database

• To define the kind of data that can be stored in a field

• To create relationships between tables

• To set validation rules for data entry

Which data type would you use to store a large amount of text in Microsoft Access?

• Short Text

• Long Text

• Number

• Date/Time

What is a validation rule in Microsoft Access?

• A rule that formats data in a specific way

• A rule that restricts the type of data that can be entered into a field

• A rule that automatically updates data

• A rule that creates a relationship between tables

Which of the following is an example of a validation rule?

• "Text"

• ">= 18"

• "Date/Time"

• "Currency"

What is the purpose of a primary key in a database table?

• To allow duplicate records

• To uniquely identify each record in a table

• To create a relationship between tables

• To store large amounts of text

Which of the following can be used as a primary key?

• A field with duplicate values

• A field with unique values

• A field with null values

• A field with text data type

What is a foreign key in a database?

• A key that uniquely identifies a record in a table

• A key that is used to link two tables together

• A key that allows duplicate records

• A key that stores large amounts of text

Which of the following is true about foreign keys?

• They must be unique in the table

• They can have null values

• They are used to create relationships between tables

• They are always text data types

What is a composite key?

• A single field that uniquely identifies a record

• A combination of two or more fields that uniquely identify a record

• A key that allows duplicate records

• A key that stores large amounts of text

When would you use a composite key?

• When a single field is sufficient to uniquely identify a record

• When multiple fields are needed to uniquely identify a record

• When you want to allow duplicate records

• When you want to store large amounts of text