Skip to main content

Access Chapter 9

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.
  • Access: Database Design Participation Project
Use the Performance Analyzer to optimize database performance.
  • MyLab Lesson D
  • MyLab Lesson D

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

  1. 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.