Lesson 3

Front 1

And Operator

Back 1

selects records that match all of the two or more conditions in a query

Front 2

Auto Filter

Back 2

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

Front 3

Calculated field

Back 3

when a feild displays a value that is calculated using other fields in the query

Front 4

Common Field

Back 4

is a field that appears in both tables has the same data type and contains the same values

Front 5

Condition

Back 5

(also called a criterion) is away of telling the query which data you are intersted in seeing .

Front 6

Expression

Back 6

in a expression ,field names are enclosed in square brackets , which is required when a feild name containing space is used in a expression '.

Front 7

Filter

Back 7

temporaily 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 contains one or more values based on the vaules stored in one or more field

Front 9

Filter By Selection

Back 9

you select a field vaule or partof a field vaule in a datasheet

Front 10

Foreign Key

Back 10

when it is used in a relationship in the primary table , the common field is usually the table primary key

Front 11

Multitable Query

Back 11

Queries that are based on more than one table are some-times called multitable query

Front 12

one-to-many relationship

Back 12

one records in the first table 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 .

Front 14

Query

Back 14

is a datasheet objects that let you ask the database bout the data in contains

Front 15

Referential Integrity

Back 15

protects the data in the table to make sure that data is not accidentally delete and changed resulting in inconsistent data.

Front 16

Relationship

Back 16

between two tables you must design the table so they contain a common field

Front 17

Simple Query Wizard

Back 17

an easy way to crete a query is to use the simple query wizard which asked you what data you want to see by letting you select options in dialog boxes

Front 18

Sort

Back 18

when you view field vaules in ascending or descending order from A to Z or from smallest to largest yu apply a sort to the field'.

Front 19

subdatasheet

Back 19

which contains the related records in the order table you can use the subdatasheet to make changes to the related records

Front 20

Total Row

Back 20

when you are viwing a table or query datasheet you can the total row to count the number of values in a common