Form Design Tools->Design Ribbon

 

1. Readings
Read Lesson 5 in the Intermediate Access guide, page 117-150.
 

Project

A Select Query that synchronizes two Combo Boxes and filters the Subform.

 

Downloads

FrontRowVideo Int5.accdb

BBL Int ver5.accdb

 

2. Practice

Do the Practice Activity on page 151.

 

3. Assessment

Review the Test questions on page 152.

 
 

Lesson 5 : Synchronized Combo Boxes

 

   

Query Design Tools ->Design Ribbon

Menu Maps

From the Form Design Tools->Design Ribbon

1. Design->Tools->Property Sheet, page 124

2. Design->Tools->Add Existing Fields, page 125

6. Design->Controls->Combo Box, page 137

7. Design->Tools->Property Sheet->Link Master Fields, page143

 

From the Query Design Tools ->Design Ribbon

3. Design->Query Set Up->Show Table, page 128

4. Design->Show/Hide->Totals, page 131

5. Design->Query Setup->Builder, page 133