Query Tools->Design

 

1. Readings
 Read Lesson 6 in the Advanced Access guide, page 151-176.
 

Project

A Receipt Printout Report formatted as a Table and sized for a POS Printer.

 

Downloads

FrontRowVideo Adv6.accdb

BBL Adv ver6.accdb

 

2. Practice

Do the Practice Activity on page 177.

 

3. Assessment

Review the Test questions on page 178.
 
 

Lesson 6 : The Receipt Printout

 
   
Report Design Tools->Page Setup

Menu Maps

From the Create Ribbon.

Create ->Queries->Query Design, page 158

Create ->Reports->Blank Report, page 168

 

From the Query Tools->Design Ribbon.

1. Query Tools ->Design->Show Table, page 162

2. Query Tools ->Design->Show/Hide->Totals, page 165

 

3. Report Design Tools ->Page Setup, page 170

4. Report Design Tools ->Page Setup->Page Set Up, page 171