| A | B |
|---|
| Tables | Contain fields and records |
| Database | Organizes, Stores, Retrieves, & Communicates data |
| Entry | Single cell of data |
| Field | Group of similar information |
| Record | All fields related to one item |
| Primary Key | Formats each record as a unique entity |
| Auto Number | Automatically assigns a number to each record |
| Input Mask | Template-like field that sets how data is entered in a cell |
| Join Line | Shows links and relationships |
| Foreign Key | Primary key of the table receiving the link |
| Referential Integrity | Prevents changes in tables that are linked |
| Junction Table | Allows links among tables that don't have common fields |
| Yes/No | Field that creates a check box |
| Lookup Wizard | Field that allows students to choose from specific details in a drop-down menu |
| Tables | The "Building Blocks" of all databases: Group & Organize information in a Database |
| Database | A tool used to organize, store, retrieve, and communicate groups of related information |
| One-to-many | Relationship that occurs when a record in one table is linked to multiple records in another table |
| Caption | User creates field titles different from the field names |
