| A | B |
|---|
| Asterisk (*) | A wildcard character that matches any number of characters or no character at all. |
| Column Selector | The gray box at the top of a field in the design grid of a Select Query window. |
| Complex Query | A select query with multiple criteria. |
| Design Grid | The part of the Query window used to specify fields and criteria. |
| Foreign Key | A field in a table that is a primary key in another table. |
| Form Letter | A word document with merge fields. |
| Input Mask | Controls how data is entered and is useful when entries should follow a certain format. |
| Like | Operator used to specify criteria that uses wildcards. |
| Logical Operators | Used to form a compound expression for a validation rule or criteria in a select query. Operators include And, Or, and Not. |
| Mail Merge | The process of integrating data in an Access database with a Word document. |
| Mask Characters | The placeholders in an input mask. |
| Merge Fields | Placeholders in a word document for data from an Access table or query. |
| One-to-many relationship | The relationship between two tables when there is one and only one record in the primary key table that relates to zero, one, or more records in the related table. |
| Parameter | A value used in a parameter query. |
| Parameter Query | A select query that retrieves data based on criteria typed by the user when the query is run. |
| Question Mark (?) | A wildcard character that matches any one character or no character at all. |
| Range Query | A select query with criteria that matches a range of values. |
| Related | Two tables in a relational database with corresponding fields. |
| Relational Operators | Used to form a validation rule or specify criteria in a range query. Operators include <, >, <=, >=, and <>. |
| Select Query | A database object that retrieves data that matches specified criteria. |
| Subdatasheet | A datasheet of related records. |
| Update Query | A query that modifies records based on criteria. |
| Validation Rule | Checks entries against specified values for a field. |
| Wildcard | A character used in criteria that matches any one or more characters. Wildcard characters include * and ?. |
