Microsoft Access : Chapter 3 : Exercise 2 Creating a Report 


Exercise 2: Creating a Report  

 

Step 1

 

Open Microsoft Access

 

Click on “people,” which is under Open an existing file

 

Click OK

Step 2
 

Click on Reports (which is under Objects)

 

Double Click on Create Report in Design View

 

Click on New

 

Click on Report Wizard

 

Click on the down arrow and choose Students for the table the data comes from

 

Click OK

Step 3
 

Select all available fields, except Student ID.  This can be done by double clicking each field that you want

 

Click on Next

Step 4
 

Double Click on City for grouping levels

 

Click Next

Step 5
 

Click on the down arrow and choose Last Name in order from A-Z

 

Click Next

Step 6
 

The layout of your report should be Stepped

 

The Orientation should be Portrait

 

Check off “Adjust the field width so that all fields fit on a page”

 

Click Next

Step 7
 

The style you want to choose is Corporate

 

Click Finish

Step 8
 

This is what your report should look like

 

Next click on View

 

Double Click on Design View

Step 9
While your Report is in Design View you are going to change your Report Header and Page Footer
 

First move your mouse over “Now,” which is located in the Page Footer.  Click your mouse and make sure that your mouse is represented by a hand.  Hold down the hand and drag “Now” into the Report Header

 

Click on right align, which is located on the formatting toolbar.  This will make the date be at the top right of your report

Step 10
Next click on Label which is located on your toolbar, represented by Aa
 

Type Made by:  your name where “Now” was in the page footer

 

Then click on align left on the formatting toolbar

 

Continue to Exercise 2 solution to compare your final Report with the correct answer....... 

 

Back to Exercise 1

Continue to Exercise 2 Solution

 Back to Menu 


Microsoft Access : Chapter 3 : Exercise 2 Creating a Report