Access Lesson 3 Vocabulary

Front 1

And operator

Back 1

Selects records that match all of two or more conditions in a query.

Front 2

AutoFilter

Back 2

A menu that opens when you click the arrow on the right side of a field selector.

Front 3

Calculated field

Back 3

When a field displays a value that is calculated using other fields in the query.

Front 4

Common field

Back 4

A field that appears in both tables, has the same data type, and contains the same values.

Front 5

Condition

Back 5

A way of telling the query which data you are interested in seeing.

Front 6

Expression

Back 6

In an expression, field names are enclosed in square brackets, which is required when a field name containing spaces is usd in an expression.

Front 7

Filter

Back 7

Temporarily displays records in a datasheet based on the condition that you specify.

Front 8

Filter By Form

Back 8

when you need to display records that contain one or more more values based on the values stored in one or more fields.

Front 9

Filter By Selection

Back 9

you select a field value, or part of a field value in a datasheet.

Front 10

Foreign key

Back 10

The common field in the related table.

Front 11

Multitable query

Back 11

Queries that are based on more than one table.

Front 12

One-to-many relationship

Back 12

one record in the first can match many records in the second table.

Front 13

Or operator

Back 13

selects records that match at least one of two or more conditions in a query.