Vocabulary Access Lesson 3

Front 1

And operator

Back 1

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

Front 2

AutoFilter

Back 2

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

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

when fields are used in a calculation

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 values based on the values stored in one or more fields

Front 9

Filter by Selection

Back 9

you select the field value, or part of a field value in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab

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 relationships

Back 12

one recorded in the first table may match many records in the second table

Front 13

Or operator

Back 13

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

Front 14

Query

Back 14

database objects that lets you ask the database about the data it contains

Front 15

referential integrity

Back 15

set of rules to ensure that there are matching values in the common field used to form the relationship

Front 16

relationship

Back 16

two tables contain a common field

Front 17

Simple Query Wizard

Back 17

asks you what data you want to see by letting you select options in dialog boxes

Front 18

sort

Back 18

arranging the data in descending or ascending

Front 19

subdatasheet

Back 19

contains the related record in the Orders table(the related table)

Front 20

Total row

Back 20

is used to count the number of values in a column