Across
- 2. Also called criterion and is a way of telling the query which data you are interested in seeing
- 4. An easy way to create a query that asks you which data you want to see by letting you select options in dialog boxes
- 6. A database object that lets you ask the database about data it contains
- 7. Tables that have a common field
- 8. When two tables are related, the datasheet for the primary table contains expand indicators for each record
- 9. Used when you need to display records that contain one or more values based on the values stored in one or more field
- 10. Protects data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data
- 11. You select a field value or part of a field value in a datasheet and then click the Selection button
- 13. The optional row in a datasheet that counts the number of values in a column
- 14. Field that appears in both tables, has the same data type, and contains the same values
- 17. An operator used in a query that selects records that match all of two or more conditions in a query
- 18. temporarily displays records in a datasheet based on the condition that you specify
- 19. The term given to the calculation used in a calculated field that identifies the fields and operators to use in the calculation field
Down
- 1. Menu that opens when you click the arrow on the right side of a field selector
- 3. When one record in the first table can match many records in the second table
- 5. A query that is based on the data in two or more tables
- 11. The common field in a related table
- 12. A field in a query, form, or report that displays a value that is calculated using a combination of operators, constants, and the values in other fields
- 15. When you view field values in ascending or descending order from A to Z or from smallest to largest
- 16. An operator used in a query that selects records that match at least one of two or more conditions in a query