| A | B |
|---|
| Append | enables a user to add the results of a query to an existing table |
| Update | enables a user to make the same change to all records |
| Crosstab | calculates a statistic for data that is grouped by two different types of information |
| Aggregate | type of function performs mathematical functions on a group of records such as MAX, MIN, or COUNT |
| Calculated | term refers to a field that can be computed from other fields in a database |
| Join Line | drawn between two tables in the Query Design View to illustrate matching fields |
| Or | operator must be used for a compound criterion to be true if either criterion provided is true |
| And | operator is used when each individual criterion must be true in order for the compound criterion to be true |
| Parameter | Query type is flexible and prompts the user for input whenever it is used |
| Question Mark | character is used in a criterion to represent an individual character |
| Asterisk | character is used in a criterion to represent a collection of characters |
| Table | Object used in a query |
