Access 2010: Many to Many in Table Design

Relating Tables in a Relational Database

 

Advanced Access Objectives

In this lesson, you will learn how to:

1. Define the Primary Key in a new Table

2. Add a Foreign Key to a Table

3. Use the Primary Keys to create Relationships between Tables

4. Add a Subdatasheet and format the Tables to Show/Hide and Freeze the Columns in Datasheet View