| A | B |
|---|
| select queries | used to ask for information you wish to extract from a table or tables |
| recordset | results of a query |
| design grid | contains fields and criteria for query |
| field list | contains fields from table(s) used in query |
| query design view | contains field list and design grid |
| run a query | previews records from a query |
| join | process of relating tables |
| one-to-many relationship | one record in first table matches 0, 1, or many records in second table |
| primary table | is the "one" table |
| related table | is the "many" table |
| referential integrity | ensures consistency between related tables |
| sort field | used to display records in a specified order |
| filter by selection | used on a datasheet or form to display selected records |
| condition | criterion that must be met to display data |
| comparison operator | = < <= > >= <> between..and.. In () Like |
| AND logical operator | meets both conditions - same row in query grid |
| OR logical operator | meets one condition or the other - separate rows in query grid |
| expression | contains fields, constants, and operators |
| calculated field | field that displays results of an expression |
| aggregate functions | average, count, maximum, minimum, sum, etc. |
