Comp&Apps Bus
In Datasheet view, clicking the (+) displays the related records in this format
Subdatasheet
A wildcard character that serves as a placeholder for one or more unknown character is the
*
A relationship between between two tables where one record in the first table corresponds to many in the second table
One-to-many relationship
An associate that you establish between two tables based on common fields.
Relationship
A sorting order that arranges text in reverse alphabetical order (Z to A) and numbers from the highest number to the lowest number.
descending
In the query design window, in the table area, the list of field names in a table
field list
Characteristics of a field that control how the field displays and how data is entered are:
field properties
The primary key field is connected to this field in the related table to create a relationship
foreign key
In datasheet view, when sorting using multiple fields, the field that is used for the last level of sorting
innermost
The visual cue in the relationships window that indicates tables are related by connecting common fields
join line
In datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting
outermost
A query that prompts you for criteria when it is run is a:
parameter query
The field that uniquely identifies a record in a table is known as the:
primary key
A set of rules that ensures that the data between related tables is valid
referential integrity
The process of arranging data in a specific order based on the data in a field
sorting
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
to run
They symbols =, >, and < are known as:
comparison operators
Conditions in a query that identify the specific data for which you are looking are known as:
criteria
A single piece of information that is stored in every record and represented by a column in a table.
data
The characteristic that defines the kind of data you can store in a field is the:
data type
An organized collection of facts about people, events, things, or ideas related to a specific topic.
database
A query that uses an aggregate function and displays data grouped by two types of information is:
An aggregate query
The Access view that displays data in columns and rows like an Excel worksheet is:
Datasheet view
Min, Max, Avg, and Sum are examples of:
aggregate functions
A field that stores the value of a mathematical operation is:
an expression
The logical operator that requires all criteria to be met to return a result is:
and
A sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest number.
ascending
A comparison operator that searches for values within a range is:
between... and...
Relationship options that enable you to update records in related tables when referential integrity is enforced are known as:
cascade options
For a calculated field, the new field name must be followed by:
colon
