Access 1

Table

A collection of records that share the same fields.

Template

A database that contains formatting, styles, and sample text that you can use to create new databases.

Relational Database

A databse that contains (or can contain) multiple tables with relationships between them.

Unique Field

A field for which each record must contain a unique entry.

Required Field

A field for which each record must contain an entry.

Multi-Valued Field

A field that can contain more than one separate entry per record.

Exclusive Mode

A mode in which only one user at a time can work with a file.

Field

A piece of data stored about each record in a table. For example, ZIP Code is a field in an address book.

Report

A printable layout of the data from a table or query.

Wizard

A series of dialog boxes that guide you step-by-step through the process.

Query

A specification that describes how a set of records should be sorted, filtered, calculated, or presented.

Datasheet View

A spreadsheet-like view of a table in which each record is a row and each field is a column.

Extension

A suffix at the end of a file name that indicates its type, such as .accdb.

Table Design View

A view in which you can add, edit, and delete fields from a table, change field types and descriptions, set a primary key, and more.

Form

A view of table or query's idea, designed for lookup or input of records.

Print Preview

A view that shows you exactly how a report will look when printed.

Caption

Alternate text that appears instead of a field's actual name in datasheets, forms, and reports.

Object

An item in an Access database, such as a table, query, form, or report.

Object

An item, such as a table, query, form, or report, in an Access database file that is used to store, display, or manage data.

Field Description

An optional brief comment or expanation of a field. The field description appears in the status bar at the bottom of the window when the field is selected.

Database

An organized collection of information about a subject.

Field Selector

In Table design view, the gray rectangle to the left of the field name. Click it to select that field; drag it up or down to move the field in the field list.

Primary Key

The field that uniquely identifies each record in a table.

Primary Key

The field that uniquely identifies each record in the table.

Record

The stored information about one particular instance, such as one person's data in an address book.

Column Header

The top block in a vertical column on a datasheet, containing the field name.

Encrypt

To add protection to a file so others cannot read it.

Append

To add to the end of.

Collate

To order copies of a multipage document so that complete sets are together.

Freeze

To set a field so that it always remains onscreen in the left-most position, as you scroll left-to-right.

Composite Key

Two or more fields that collectively define tge primary key by their values.

Database Management System

A computer program that includes both the stored database and the tools required to use the database.

Field Properties

Characteristics of a field.