U3 L3 Vocab

Front 1

ascending sort

Back 1

A-Z or 1-10

Front 2

calculated field

Back 2

displayed values are the result of calculations performed on other fields

Front 3

concatenation

Back 3

to link the entries in two fields into a text string

Front 4

criteria

Back 4

limiting condition used in access queries and filters to show a limited set of records

Front 5

descending sort

Back 5

Z-A or 10-1

Front 6

expression

Back 6

a formula that calculates a value or defines criteria; used to calculate new values or to specify which records should be displayed

Front 7

filter

Back 7

isolate a subset of records in a datasheet

Front 8

filter by form

Back 8

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

Front 9

filter by selection

Back 9

a filtering techinque in which you select a value or partial value for which you want to filter using this

Front 10

select query

Back 10

most common type of query; retrieves specific data from one or more tables and displays the results in a datasheet