Access Lesson 3

Front 1

And Operator

Back 1

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

Front 2

Autofilter

Back 2

is a menu that opens when you click the arrow or 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

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

Front 5

condition

Back 5

(also called a Criterion) is a way of telling the query which data you are interested in seeing.

Front 6

expression

Back 6

(the calculation) field name containing spaces

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

you can use this when 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 can select a field value (such as Oak Office Desk) or part of a field value (such as the just letter D) in a datasheet, and then click the selection button in the sort & filter group in the home tab.

Front 10

foreign key

Back 10

the common field in the related table when it is used in the relationship.

Front 11

multitable query

Back 11

Queries that are based on more that one table.

Front 12

one-to-many relationship

Back 12

one record in the first table (called the primary table) can match many (actually, zero, one, or many) records in the second table (called the related table)

Front 13

Or operator

Back 13

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

Front 14

Query

Back 14

is a database object that lets you ask the database about the data it contains.

Front 15

referential intergrity

Back 15

protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.

Front 16

relationship

Back 16

when a database contains more than one table,as most databases do, the feature of the database management system that lets you connect the data in the tables.

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

when you view field values in ascending or descending order from A to Z or from smallest to largest.

Front 19

subdatasheet

Back 19

contains the related records in the order table(the related table) you can use it to make changes to the related records.

Front 20

Total row

Back 20

used when viewing a tavle or query datasheet to count the number of values in a column