| A | B |
|---|
| form header | section that displays information that remains the same for every record. Appears once at the beginning of the form. |
| detail | section in a form or report that displays the records |
| bound control | connected to a field in a table and used to display, enter, and update data |
| unbound control | not connected to a field in a table and is used to display information, lines, rectangles, and pictures |
| calculated control | uses an expression to generate the data value for a field |
| search criteria | in a query, the information you are searching for |
| or operator | used to find records that meet one criteria or another |
| and operator | used to find records that meet more than one criteria |
| filters | simpler form of a query that cannot be saved and displays all fields |
| ascending sort | sort that arranges records from A to Z or smallest to largest |
| descending sort | sort that arranges records from Z to A or largest to smallest |
| indexing | feature of databases that allows a field to be more quickly searched |
| relationships | link between tables that have a common field, allowing you to create forms, queries, and reports using fields from all tables in the relationship |
| referential integrity | rules that ensure valid relationships between tables and prevent invalid data from being entered |
| one-to-many relationship | relationship where a record in table A can have a number of matching records in table B, but a record in table B has only one matching record in table A |
| subdatasheet | in tables that are related, you can show records from one table in the related record in the primary table |
| multitable query | searches related tables |
