Table Tools ->Design->Tools->Primary Key

 

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

Menu Map
 
 

Lesson 2 : Relating Tables in a Relational Database

 
   

Menu Maps

From the Table Tools ->Design Ribbon
1. Table Tools ->Design->Tools->Primary Key, page 36
2. Table Tools ->Views->View->Datasheet, page 37

 

From the Query Tools->Design Ribbon

3. Query Tools ->Design->Results->Run, page 42

4. Query Tools ->Design->Query Type->Update, page 44

 
Query Tools->Design Ribbon
Menu Map