Exam 1: Create Database Tables

A field that automatically enters a unique, numeric value when a record is created is a(n) ________ field.

When you join tables, the common fields must share the same ________.

With a(n) ________, if the user deletes a record on the one side of the relationship, all the related records on the many side will also be deleted.

Database ________ store the data in rows and columns.

When entering data in related tables, a foreign key value must have a(n) ________ value in the related table.

If the buttons on the navigation bar are dimmed, the table will print on more than one page.

You do not need to save new or changed data before navigating to a new record.

Specific fields in a datasheet can be ________.

If an Excel workbook contains multiple worksheets, it will automatically import Sheet1.

A table's page layout settings cannot be ________.

Primary key field names often include ID to help identify them.

Ascending order means records have been sorted by ________.

When you save a table that has been added or changed, its name displays in the ________.

An Excel worksheet CANNOT be imported into a new table.

If you will often import data from the same Excel workbook to Access, you can ________ the import steps.

When creating a table, the ________ indicates what kind of information will be stored in a field.

The Date/Time data type stores data as ________.

________ can be used to see what a report will look like without actually printing it.

________ limits the number of characters that can be typed into a text or number field.

Referential integrity rules allow you to enter a Contractor ID that does not exist in the related Contractors table.