Create Ribbon

 

1. Readings
 Read Lesson 3 in the Advanced Access Guide, page 61-86.

 

Project

Create several Tables with Primary and Foreign Keys.

 

Downloads

FrontRowVideo Adv3.accdb

BBL Adv ver3.accdb

 

2. Practice

Do the Practice Activity on page 87.

 

3. Assessment

Review the Test questions on page 88.
 
 

Lesson 3 : Primary Keys and Relationships

 
   
Relationship Ribbon

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->Tools->Close, page 84