Access - Lesson 3 Key Terms

1. Ascending Sort- A sort of order that sorts text values from A to Zand number values from 1 to 10.
2. 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.
3. Concatenation- In Access, joining two values to display them as a single value.
4. Criteria- A limiting condition, such as "Arizona" or ">100" used in Access queries and filters to show a limited set of records.
5. Descendig 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.
7. 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 displayedin the subset of records.
8. Filter by form- In Access, a filtering technique in which you can type the values for which you want to filterusing a form that contains all the fields in the datasheet.
9. Filter by Selecction- In Access, a filtering technique 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 queryin Access, the selected query retrieves specific data from one or more tables and displays the results in a datasheet.