Access 2010: Many-to-Many

Primary Keys and Relationships

 

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,