Microsoft Access Vocabulary

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

• AutoNumber

• Text

• Date/Time

• Currency

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

• Control

• Field

• Record

• Table

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

• Status Bar

• Navigation Pane

• Record Selector

What is a view that shows a table as a collection of rows and columns, similar to a spreadsheet?

• Datasheet View

• Form View

• Design View

• Layout View

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

• Design View

• Layout View

• Data Sheet View

• Form View

Field Properties: Characteristics that further define the field; they are displayed in Table Design View.

• Field Properties

• Field Types

• Field Attributes

• Field Settings

Field Properties Pane: The lower half of Table Design View which displays field properties.

• Field Properties Pane

• Data Type Pane

• Navigation Pane

• Record Pane

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

• Field Size Property

• Data Type Property

• Input Mask Property

• Validation Rule Property

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

• Fields

• Rows

• Columns

• Cells

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

• Form

• Table

• Query

• Report