Access Chapter 2

Front

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

Back

cascade options

Front

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

Back

design grid

Front

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

Back

aggregate functions

Front

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

Back

criteria

Front

A criteria that searches for fields that are not defined is

Back

Is Null

Front

They symbols of =, >, and < are known as

Back

comparison operators

Front

A comparison operator that searches for values within a range is

Back

Between ... And ...

Front

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

Back

AND

Front

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

Back

*

Front

A field that stores the value of a mathematical operation is

Back

a calculated field