|
Advanced Access Objectives In this
lesson, you will learn how to: 1. Identify the levels of database design: First, Second
and Third Normal Form. 2. Create Tables in Design View that have Primary and
Foreign Keys. 3. Create Tables that do not have repeating groups: Third
Normal Form. 4. Document the Relationships. 5. Edit the Joins between Tables to ensure Data Integrity
and Enforce Referential Integrity, From the Developer Ribbon. 1.
Create ->Tables->Table Design, page 73
From the
Database Tools Ribbon
Database Tools ->Relationships->Relationships, page 76
From the
Relationship Tools Ribbon 2.
Relationship Tools ->Design->Show Table, page 78 3.
Relationship Tools ->Design->Tools->Edit Relationships, page 83 4.
Relationship Tools ->Design->Relationships->Close, page 84 |
|
|
|
