Unit 3 Lesson 3

Front 1

A sort order that sorts text values from A to Z and number values from 1 to 10.

Back 1

Ascending Sort

Front 2

A feild in an access query, form, or report in which the displayed are results of calculations performed on other fields.

Back 2

Calculated Field

Front 3

joining 2 values to display them as a single value.

Back 3

Concatenation

Front 4

a limiting condition such as "arizona" or ">100".

Back 4

Criteria

Front 5

a sort order that sorts text values from Z to A and number values from 10 to 1.

Back 5

Descending Sort

Front 6

a formula that calculates a value or defines criteria

Back 6

Expression

Front 7

one or more criterion that you can apply to a datasheet to display a subsheet of records.

Back 7

Filter

Front 8

a filtering technique in which you can type the values for which you want to filter using a form that contains all the feilds in the datasheet.

Back 8

Filter By Form

Front 9

a filtering technique in which you select a value or partial value for which you want to filter using the filter by selection button.

Back 9

Filter By Selection

Front 10

retrieves specific data from one or more tables and displays the result in a datasheet.

Back 10

Select Query