| A | B |
|---|
| ascending sort | a sort order that sorts text values from a to z and number values from 1 to 10 |
| calculated field | a field in an access query, form, or report in which the displayed values are the result of calculations performed on other fields |
| concatenation | in access, joining to values to display them as a single value for example, if you concatenate a FisrtName field to a LastName field, as in [FirstName]&[LastName], the two names are displayed as a full name in a single field |
| criteria | a limiting condition, such as “Arizona” or “>100” used in access queries and filters to show a limited set of records |
| descending order | a sort order that sorts text values from z to a and number values from 10 to 1 |
| expression | - 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 |
| filter | 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 |
| filter by from | 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 the datasheet |
| filter by selection | in access, a filtering technique in which you select a value for which you want to filter using the filter by selection button |
| select query | 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 filed in a select theory |
