| A | B |
|---|
| query | a question represented in a way that Access can understand |
| select query window | window that allows the user to create entries for a query |
| field asterisk | button in field list that enters all fields |
| clear the query | clear out the design grid |
| text data | data in a field whose type is next |
| wildcards | symbols that represent any character or combination of characters |
| question mark | represents any individual character |
| asterisk | represents any collection of characters |
| comparison operator | operations which don't bring up an exact match |
| compound criterion | having more than one criterion which the data must satisfy |
| AND criterion | each individual criterion must true |
| OR criterion | only one of the criterions must be true |
| sort | to set the records in certain order |
| sort key | the field or fields on which the records are sorted |
| major key | the more important field in a multi-field sort |
| minor key | the least important field in a multi-field sort |
| join | to find records in the two tables that have identical values in matching field |
| join line | a line between the two related tables |
| calculated field | to calculate to fields together to make a new field |
| statistics | built-in shortcuts that allow the user to calculate certain fields |
| grouping | creating groups of records that share the same characteristics |
| design grid | the area where you specify fields to be included |
