| A | B |
|---|
| Access | A database program you use to enter, organize, display, and retrieve related information |
| Text | An Access data type that allows field values containing letters, digits, and other characters |
| Cascade deletes option | A referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that have matching foreign key values |
| Cascade updates option | A referential integrity rule that permits a change in value to the primary key and changes the appropriate matching foreign key values in related tables |
| Common field | A field that appears in more than on table, allowing you to connect the records in the separate table |
| Data type | Determines what field values you can enter for the field and what other properties the field will have |
| Database | A collection of related tables stored in the same file |
| Datasheet | The display of a tables contents in rows and columns, similar to a table or spread sheet; each row is a separate record in the table |
| Datasheet view | The Access view that shows a table’s contents as a datasheet in rows and columns, similar to a table or spreadsheet |
| Field | A single characteristic of a person, place, object, event or idea |
| Field Properties Pane | The part of the Table window in Design view that contains the properties for the selected field |
| Field value | The specific value or content of a field in a record |
| Form | A database object you can create and customize to maintain, view, and print records in a database in different and useful ways |
| ID Column | The Default field Access creates to serve as the primary key field for all new |
| Navigation pane | In Access, the area on the left of the program window that lists all the objects in the database |
| One-to-Many relationship | The type of database relationship that exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when one record in the second table matches exactly one record in the first table |
| Primary key | A field or a collection of fields whose values uniquely identify each record in a database table |
| Primary table | The “one” table in a one-to-many relationship |
| Query | A question you ask about the data stored in a database; in response, Access displays the specific records and fields that answer your question |
| Record | A complete set of field values for a specific person place object event or idea |
| Referential integrity | A set of rules that Access enforces to maintain consistency between related tables when you update data in a database |
| Related table | The “many” table in a one-to-many relationship |
| Report | A formatted printout of the contents of one or more tables in a database |
| Table | A collection of fields that describe a person place object event or idea |
| Table Design Grid | The part of the Table window in Design view that contains the values for the Field Name, Data Type, and Description field properties |
| AutoNumber | An access data type that automatically assigns a unique number to a record |
