The area directly below the ribbon that displays information such as security alerts.

Message bar

An area where you can view the security and privacy settings for your Access installation.

Trust Center

An association that you establish between two tables based on common fields.

Relationship

A relationship between two tables, where one record in the first table corresponds to many records in the second table.

One-to-many relationship

In the query design window, in the table area, the list of field names in a table.

Field list

The primary key field is connected to this field in the related table to create a relationship.

Foreign key

A set of rules that ensures that the data between related tables is valid.

Referential integrity

The visual cue in the Relationships window that indicates tables are related by connecting common fields.

Join line

In Datasheet view, clicking the plus sign (+) displays the related records in this format.

Subdatasheet

The process of arranging data in a specific order based on the data in a field.

Sorting

A sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest number.

Ascending

A sorting order that arranges text alphabetically (Z to A) and numbers from the Highest number to the Lowest number.

Descending

In Datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting.

Outermost

In Datasheet view, when sorting using multiple fields, the field that is used for the second level of sorting.

Innermost

The process in which Access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet.

Run

Relationship options that enable you to update records in related tables when referential integrity is enforced are known as:

Cascade options

The lower area of the query design window where criteria is entered is the:

Design grid

Min, Max, Avg, and Sum are examples of:

Aggregate functions

Conditions in a query that identify the specific data for which you are looking are known as:

Criteria

A criteria that searches for fields that are empty is:

Is Null

The symbols of =,>,and<, are known as:

Comparison operations

A comparison operator that searches for values within a range is:

Between...And

the logical operator that requires all criteria to be met is:

AND

A wildcard character that serves as a placeholder for one or more unknown characters is the:

*

A field that stores the value of a mathematical operation is:

A calculated field

For a calculated field, the new field name must be followed by:

A colon

A query that uses an aggregate function and displays data grouped by two types of information is:

A crosstab query

A query that prompts you for criteria when it is run is a:

Parameter query

Criteria that can be changed when a query is run is a:

Parameter

A good parameter for a City field is:

[Enter a City]