In this section you will learn how to:

1

• In this section you will learn how to
• Recognize the different report sections
• Group and sort data in a report
• Create a calculated control in a report
• Adjust the look and feel of a report
• Add images to a report
• Adjust header and footer properties
• Make page numbers
• Create mailing label reports

2
Adding and Removing Fields

• Designing reports in Access is similar to
  designing forms.
• Using Design view, you have a template laid out
  before you in which you can drag and drop
  different objects.

3
Using Report Sections

• The default report sections are Page Header,
  Detail, and Page Footer.
• You can click and drag the sections of a report
  larger or smaller to suit your needs.

4
Changing Section Properties

• Right-click on any section title (the grey bar
  spanning the report) and click Properties.

5
Grouping and Sorting in a Report

• Click the Sorting and Grouping button on the
  Report Design toolbar.

6
Changing Group Properties

• When you click the Sorting and Grouping button,
  you have the ability to modify properties of the
  actual group.

7
Using Calculated Controls in a Report

• Calculated controls are text boxes that have a
  mathematical expression in their properties.
• The Control Source field contains an expression
  and displays the result.

8
Formatting Gridlines

• Gridlines are adjustable in reports by the same
  means as in forms.
• Double-click the report selector button in the
  upper-left hand of the report to open the Report
  Properties.
• The Format tab contains the Grid X and Grid Y
  properties.

9
Modifying the Font

• Modification of a font in a report is as simple
  as highlighting the control or object you want to
  format and then use the Report Design toolbar.

10
Adjusting the Layout of your Report

• Now that you have all elements you want in your
  report and looking the way you want, you can
  fine-tune the layout to meet your requirements.
• By using the gridlines and a good resolution, you
  can adjust the layout of components down to the
  nearest 64th of an inch.
• Once you have everything looking the way you
  like, you can adjust many background attributes
  of a report using the Properties function.

11
Using AutoFormat

• Can use AutoFormat in the wizard or in design
  view.
• You can apply any of the pre-made formatting
  styles by clicking the AutoFormat button on the
  Report Design toolbar.

12
Adding a Photo

• To add a photo, click the Image icon in the
  Toolbox and then click somewhere in the
  appropriate header section you want the photo to
  appear.

13
Adjusting Page Properties

• Click File ? Page Setup to adjust page properties.

14
Adding Headers and Footers

• If you are building a report from scratch in
  Access, you wont see the Report Header or Footer
  right away.
• Click the View menu and then click the Report
  Header/Footer option to place a check mark beside
  it.

15
Adding Page Numbers

• The page numbers are a type of calculated
  control they are a text box with this
  formula"Page " Page " of " Pages
  listed in the Control Source property.

16
Using the Label Wizard

• To start the Wizard, click the Reports object in
  the Database window.
• Click the New button, select Label Wizard, select
  the table or query (Customers) containing the
  data you want to use, and then click OK.