Chapter Demonstrable Skills
After completing the Access Chapter 9 portion of the Access unit, students will be able to:
| Demonstrable Skill | Learning Activities & Informal Assessments |
Formal Assessments (excluding Exams) |
|---|---|---|
| Design a normalized database structure to store information. |
|
|
| Use the Performance Analyzer to optimize database performance. |
|
|
Chapter Notes
Creating relationships
Once you have created or imported your tables, you have to create relationships between the tables [1]. The tables should be connected, and the Enforce Referential Integrity option should generally be enabled.
Using the Table Analyzer tool
The Table Analyzer analyzes the tables in your database and normalizes them for you [1]. Normalizing an existing table involves splitting a table into smaller, related tables with each table focused on a single topic of information. You can find the Table Analyzer in the Analyze group on the Database Tools ribbon.
References
- A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.