Query Tools->Design

 

1. Readings
Read Lesson 8 in the Advanced Access guide, page 211-238.
 

Project

A Report that uses a Query to calculate which movies are overdue.

 

Downloads

FrontRowVideo Adv8.accdb

BBL Adv ver8.accdb

 

2. Practice

Do the Practice Activity on page 239.

 

3. Assessment

Review the Test questions on page 240.

 
 

Lesson 8 : The Producers

 

   
Report Design Tools->Arrange

Menu Maps

From the Create Ribbon.

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

2. Create ->Reports->Report Wizard, page 226

 

From the Report Design Tools->Arrange Ribbon.

3. Report Design Tools ->Arrange->Sizing and Ordering->Align, page 229

 

From the Report Design Ribbons.

4. Report Design Tools ->Design-> Grouping and Totals ->Group & Sort, page 233

5. Report Design Tools ->Design->Tools->Tab Order, page 235