Access - Lesson 3 Key Terms

1. Ascending Sort: A sort order in another program (such as Word, Excel, Power Point, Access, or other Outlook items) that has been attached to an e-mail message.

2. Calulated Field: A filed in ana Access query, form, or report in which the displayed values are the result of calculations performed on other fields.

3. Concatenation: 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.

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

5. Descending Sort: A sort order that sorts text values from Z to A and number values from 10 to 1.

6. Expression: A formula that calculates a value or defines criteria; in Access, you can use an expression to calculates new values or to specify which records should be displayed.

7. Filter: In Access, one or more criterion that you can apply to a datasheet to display a subset of records.

8. Filter by Form: 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.

9. Filter by Selection: In Access, a filtering techinque in which you select a value or partial value for which you want to filter using the Filter by Selection button.

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