Create Ribbon


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,

Menu Map

Lesson 3 : Primary Keys and Relationships


Relationship Ribbon
Menu Map

Menu Maps

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