Comma Training Page 30

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

1. Readings
Read Lesson 2 in the Advanced Access guide, page 29-58.

Project

Create a Table and use the Primary Key to create a relationship to an existing Table.

Downloads

FrontRowVideo Adv2.accdb

BBL Adv ver2.accdb

2. Practice

Do the Practice Activity on page 59.

3. Assessment

Review the Test questions on page 60.

Lesson 2 : Relating Tables in a Relational Database

Menu Maps

From the Table Tools ->Design Ribbon

Table Tools ->Design->Tools->Primary Key, page 36

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