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]