click below
click below
Normal Size Small Size show me how
BAI 103L
University of Dayton Access Exam
| Term | Definition |
|---|---|
| Database | Repository of Data |
| Purpose of Database | Store, Manage, and Retrieve Info |
| Relational Database | Organized into tables (data), minimize reduntant data |
| Tables | Hold the data |
| Queries | Ask for specifics |
| Forms | Make data entry easy |
| Reports | Make the data look good |
| Primary Key | Unique identifier, use rows to link tables |
| Characteristics of Primary Key | May not be blank, must be unique |
| Fields and Records = | Columns and Rows |
| Foreign Key | Was a primary key in different table, data doesn't have to be unique |
| Access extension | AACDB |
| Common field | Same field in more than one table, such as the primary key and foreign key (used in linking tables) |