Flash Cards 3/24/2009

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

descending sort

Back 2

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

Front 3

filter

Back 3

!.In Excel, a feature that allows you to display a subset of data in a list on a worksheet. See also AutoFilter.
2.In access, 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. See also Filter by selection and Filter by form

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 Access, a filtering technique in which you select a value or partial value for which you want to filter by selection button

Front 6

Filter by form

Back 6

In Access, 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 a datasheet.

Front 7

select query

Back 7

The most common type of query in Access, the select query retrives specific data from one or more tables and displays the results in a datasheet; however, it does not alter the data in the tables. You can sort and summarize the results of a select query,and you canperform calculations on the fields in a selected query.

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 field.

Front 9

cauculated field

Back 9

A field in an Access query,from, or report in which the displayed values are the result of calculations performed on other fields.

Front 10

expression

Back 10

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.