U3 L3

Front 1

ascending sort

Back 1

A sort text values from A to Z and number values from 1 to 10

Front 2

descending sort

Back 2

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

Front 3

filter

Back 3

to isolate a subset of record in a datassheet.

Front 4

criteria

Back 4

A limiting condition,such as "Arizona" or">100" used in Access queries and filters to show a limited set of records.

Front 5

Filter By Selection

Back 5

In Acess, a filtering techinque in which you can type the values or partial values for which you want to filter using the Filter By Selection button.

Front 6

Filter By Form

Back 6

In Access, a filtering techique in which you want to filter using a form that contains all the fields in the datasheet.

Front 7

select query

Back 7

The most common type of query in Access.

Front 8

concatenation

Back 8

In Access, joining two values to display them as a single value: for example, if you concatenate a FirstName field to a LastName field, as in [FirstName]&[LastName], the two names are displayed as a full name in a single.

Front 9

in the query design grid.

Back 9

Calculated field

Front 10

performs calculation on other fields in a query.

Back 10

expression