Exam 1: Create Database Tables

The Print command enables you to select different print options.

Records in two tables can be related by placing the same ________ in both tables.

________ view lists all the fields with their data types and properties but not actual records.

A foreign key is often the second table's primary key.

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

The Currency data type stores numbers formatted as monetary values.

You can hide a field in a datasheet.

When you close a database table, the database closes.

The ________ row is a row of a table in which a new record can be entered.

An alternate method for creating a table is to create it in ________ view.

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

A datasheet displays records in rows and columns similar to an Excel spreadsheet.

You can ________ data from an Excel spreadsheet into an Access table by using the appropriate wizard.

A field that uniquely identifies each record in a table is called the ________.

When you import data from Excel, it is best practice to insert the table's field names in the spreadsheet's header row.

A layout that is taller than it is wide is ________.

When a user changes the font or font size in a datasheet, changes are applied only to the column where the insertion point was located when the change was made.

The feature that allows a user to enter dates into Date/Time fields by clicking on a calendar is called the Date ________.

The ________ command prints the object without letting you make adjustments.

The column ________ changes to indicate that records have been sorted.