| A | B |
| Alphabetical order | Sorting text in ascending order from A to Z. |
| Chronological order | Sorting times and dates in ascending order. |
| Contract indicator | Removes the subdatasheet for the active record. |
| Design grid | Displayed in select query Design view and is where fields for the select query are added. |
| Expand indicator | Displays the subdatasheet for the active record. |
| Range Query | A query with criteria that includes many different entries. |
| Related | Two tables with corresponding fields. |
| Select Query | A query that includes fields from any table and uses the relationships between tables to determine which data to display. |
| Sorting | Placing records in a specified order. |
| Subdatasheet | Displays records related to a particular record. Available in Datasheet view when relationships have been defined. |
| Updating | Changing the entries in an existing record. |