Lesson 3 key terms

1. Ascending sort- Any sort that can be (A-Z or 1-10).
2. Calculated field- To perform calculations in a query.
3. Concatenation- To perform mathematical calculations on the data it retrieves, to link the entries in two fields into a text string.
4. Criteria- allows you to work with a limited set or records that have the data you need.
5. Descending sort- Any sort that can be (Z-A or 10-1
6. 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.
7. 7. Filter- one or more criterion that you can apply to a datasheet to display a subset or records. Those records that do not meet criterion are "filtered out" and are not displayed in the subset of records.
8. 8. Filter by Form- 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. 9. Filter by Selection- 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. 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; however, it does not alter the data in the table(s)