A unique identifier is also called a primary key.

In Access, field names cannot contain digits.

The Navigation Pane contains a list of all the objects in the database.

In Datasheet view, a table is represented as a collection of rows and columns called a list.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

The Currency data type is used for fields that contain only monetary data.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

When Access first creates a database, it automatically creates a table.

One way to undo changes to a field is to click the Undo button on the status bar.

Changing the column width in a datasheet changes the structure of a table.

Landscape orientation means the printout is across the length (height) of the page.

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

To preview and then print the contents of a table, use Table Preview.

Form view displays a single record at a time.

Layout view shows a report on the screen and allows the user to make changes to the report.

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

Redundancy means storing the same fact in more than one place.

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject.

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record.

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu.

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu.

Access is a ____.

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

A(n) ____ contains information about a given person, product, or event.

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

In Access, table and field names can be up to ____ characters in length.

A field whose data type is ____ can contain any characters.

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

A field whose data type is ____ can store text that can be used as a hyperlink address.

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

To define an additional field in Datasheet view, tap or click the ____ column heading.

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.