Query Tools->Design

 

Advanced Access Objectives

In this lesson, you will learn how to:

1. Create a Select Query that groups the sales and calculates the Totals for each Receipt.

2. Use the Group By and Totals Row in a Query.

3. Create a Blank Report and select a Query as the Record Source.

4. Edit the Report Page Setup and change the page Size and Orientation.

Menu Map
 
 

Lesson 6 : The Receipt Printout

 

   
Report Design Tools->Page Setup
Menu Map

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