| A | B |
|---|
| Alphabetical order | Records sorted in ascending order based on the data in a text field. |
| And | A logical operator in a Boolean expression. |
| Asterisk (*) | A wildcard character that matches ANY NUMBER of characters or no character at all. |
| Boolean expression | Criteria formed with a logical operator, such as And. |
| Chronological order | Records sorted in ascending order based on the data in a date/time field. |
| Column selector | The gray box at the top of a field in the design grid of a select query. |
| Design grid | The part of Select Query Design view that contains fields and criteria. |
| Like | Operator displayed in criteria that uses wildcards. |
| Question mark (?) | A wildcard character matches any ONE character or no character at all. |
| Range query | A query with criteria that includes many different values. |
| Related | Two tables with corresponding fields. |
| Relational operators | Used in criteria to compare values. Operators include =, <, >, <=, >=, and <>. |
| Select query | A query that uses the relationships between tables to determine the data to display. |
| Sorting | Placing records in a specified order. |
| Subdatasheet | Shows records from another table that are related to a particular record. |
| Updating | Changing the data in an existing record. |
| Wildcard | A character used in criteria that matches any one or more characters (for example, * or ?) |
| Collapse All command | Closes all subdatasheets. Found in the Format menu. |
| Delete Record command | Used to delete the record currently displayed in a form. Found in the Edit menu. |
| Delete Rows command | Deletes a field in table Design view. Found in the menu displayed by right-clicking a field name in table Design view. |
| Design button | Displays a selected table in Design view. Also displays a select query in Design view. Found on the Database window toolbar. |
| Expand All command | Opens all subdatasheets. Found in the Format menu. |
| Displays the query objects. | Found in the Database window. |
| Relationships command | Used to define a relationship between two tables. Found in the Tools menu. |
| Run command | Applies a select query. Found in the Query menu. The Run button on the toolbar can be used instead of the command. |
| Save As command | Displays a dialog box used for duplicating a query. Found in the File menu. |
| Save command | Used to save defined relationships. Also used to save a select query. Found in the File menu. |
| Show Table command | Used to add a table to Select Query Design view. Found in the Query menu. |
| Sort Ascending command | Sorts a table in order from lowest to highest based on the data in a specified field. Found in the Sort submenu in the Records menu. |
| Sort Descending command | Sorts a table in order from highest to lowest based on the data in a specified field. Found in the Sort submenu in the Records menu. |
| View button | Used to switch a table between Datasheet view and Design view. Also used to switch a select query from a datasheet to Design view. |
