Bcis1 U3 L3

Front 1

ascending sort

Back 1

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

Front 2

calculated feild

Back 2

a feild in an access query, form, or report in which the displayed values are the result of calculations performed on other feilds

Front 3

concatenation

Back 3

joining two values to display them as a single value; for example, if you concatenate a firstname feild to a lastname feild

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

descending sort

Back 5

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

Front 6

expression

Back 6

a formula that calculates a value or defines criteria; in access, you can use an expression to calculate new values or to specify which records should be displayed.

Front 7

filter

Back 7

one or more criterion that you can apply to a datasheet to display a subset of records. those records that do not meet the criterion are filtered out and are not displayed in the subset of records

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 feilds in the datasheet

Front 9

filter by selection

Back 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

Front 10

select query

Back 10

the most common type of query in access, the select query retrieves specific data from one or more tables and displays the results in a datasheet; however, it does not alter the data in the table(s). you can sort and summarize the results of a select query, and you can perform calculations on the feilds in a select query