Microsoft Access Vocabulary Review

An Access data type that automatically assigns a unique number to a record.

• AutoNumber
• Control
• Record

• Field

In Access, any form or report element such as a label or text box.

• Control
• Fields

• Label

• Datasheet view

The box that appears at the bottom of a datasheet or form that indicates the current record and total number of records displayed.

• Current Record Box
• Navigation Pane

• Field Properties Pane

• Datasheet view

A view that shows a table as a collection of rows and columns, similar to a spreadsheet.

• Datasheet view
• AutoNumber
• Design View

• Current Record Box

A view that allows the structure of an object to be changed.

• Design view
• Datasheet View

• Form View

• Hyperlink

Characteristics that further define the field; they are displayed in Table Design view.

• Field properties
• Label

• Control
• Object

The lower half of Table Design view which displays field properties.

• Field properties pane
• Navigation Pane

• Print Preview

• Current Record Box

A field property that determines the number of characters that can be entered in Short Text, Number, and AutoNumber fields.

• Field size property
• AutoNumber
• Primary Key

• Query

An element of a table that contains a specific item of information, such as a last name.

• Fields
• Record

• Label

• Control

In Access, an object that provides an easy-to-use data entry screen.

• Form
• Table

• Query

• Report