| A | B |
|---|
| Descending sort | A sort order that sorts text values from Z to A and number values from 10 to 1. |
| AND Criteria | Criteria placed in the same row of the query design grid. All criteria on the same row must be true for a record to appear on the resulting datasheet. |
| 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. |
| Query Datasheet View | The view of a Query that shows the selected fields and records as a datasheet. |
| Alternate Back Color | A property that determines the color that alternates with white in the background of a datasheet, form, or report. |
| Filter by Selection | 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. |
| OR Criteria | Criteria placed on different rows of the query design grid. A record will appear in the resulting datasheet if it is true for any single row. |
| Criteria Syntax | Rules by which criteria need to be entered. For example, text criteria syntax requires that the criteria are surrounded by quotation marks (“ “). Date criteria are surrounded by pound signs (#). |
| Query Design View | The Window in which you develop queries by specifying the fields, sort order, and limiting criteria that determine which fields and records are displayed in the resulting datasheet. |
| Select Query | The most common type of query that retrieves data from one or more linked tables and displays the results in a datasheet. |
| Ascending sort | A sort order that sorts text values from A to Z and number values from 1 to 10. |
| Query Design Grid | The bottom pane of the Query Design View Window in which you specify the fields, sort order, and limiting criteria for the query |
| Field List | A list of available fields in the table or query. |
| 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. A way to filter data that allow two or more criteria to be specified at the same time. |
| Criteria | A limiting condition, such as "Arizona" or ">100" used in Access queries and filters to show a limited set of records. |
