| A | B |
|---|
| primary key | uniquely identifies each record in a table |
| composite key | two or more fields identified as primary keys in a table |
| common field | used to connect one table with another table |
| data redundancy | storing same data in more than one place |
| field properties | characteristics of how field values will be stored |
| data type | identifies type of field values that can be entered |
| caption | how field name appears in datasheets, forms, and reports |
| field size | set to accommodate maximum storage of data |
| table design view | defines and modifies table structure |
| entity integrity | a value must be entered in a primary key field |
| null value | when you do not enter a value in a field |
| propagate | update field property changes |
| import | copies both table data and structure |
| navigation mode | moves from field to field, record to record |
| editing mode | insert/delete values in field |
pencil symbol,  | edit mode on current record |
star symbol,  | new record |
| F1 | help key |
| F6 | switch between table design grid and field properties panes |
| F2 | toggle between navigation and editing modes |
