Exam 1: Create Database Tables

You can add tables to the Relationships tab by ________ them from the Navigation Pane.

________ determine what displays in all datasheet, form, and report labels.

The Enforce Referential Integrity option is available from the ________ dialog box.

A relationship where a record in the first table can have many associated records in the second table is called a many-to-many relationship.

If you have applied and saved a filter to a datasheet, the filter will be applied each time you open the table.

Records in a table are sorted by their primary key.

Field names and captions must be the same.

________ integrity is a rule that keeps related values synchronized.

The sort order and filter that a user creates in a datasheet are saved as a part of the table's design.

You can ________ data from an Excel spreadsheet into an Access table.

The blank row of a table where new data is entered is called the ________ row.

In the Datasheet Formatting dialog box, a(n) ________ of the selected formatting displays.

An Excel worksheet that organizes data into rows and columns can be imported into an existing table.

A relationship where a record in one table can have many associated records in a second table is a(n) ________ relationship.

One-to-many relationships enforce referential integrity.

When you create a blank database, a new table is automatically started for you.

The first column of a new table is named ________.

Reuse a database is an option on the Access start page.

To change the row color in a datasheet, click the ________ arrow from the Datasheet Formatting dialog box.

To filter records with the values you choose, your first step is to ________.