Create

 

1. Readings
 Read Lesson 8 in the Beginning Access guide, page 179-202.
 

Project

Parameter Queries with calculated Fields from the customer and movie Tables.

 

Downloads

FrontRowVideo Begin8.accdb

popcorn1.gif, popcorn2.gif, popcorn3.gif, popcorn4.gif, movies1.gif.

 

Brown Bag Lunch ver8.accdb

BB Customers Logo.jpg

Brown Bag Logo.jpg

Lunch1.gif, Lunch2.gif, Lunch3.gif,

Lunch4.gif

 

2. Practice

Do the Practice Activity on page 203.

 

3. Assessment

Review the Test questions on page 204.
 
 

Lesson 8 : More Questions, More Queries

 
   
Query Tools->Design

Menu Maps

From the Create Ribbon.

1. Create ->Queries-> Query Design, page 184

 

From the Query Tools->Design Ribbon.

2. Query Tools->Design->Show Table, page 184

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