INTRODUCTORY MICROSOFT ACCESS Lesson 5 Reports and Macros

1
INTRODUCTORY MICROSOFT ACCESSLesson 5 Reports
and Macros
2
Objectives

• Create a report using a Report Wizard.
• Modify a report.
• Create and run a macro.

3
Terms Used in This Lesson

• Database report
• Grouping
• Macro

4
Create a Report Using a Report Wizard

• Database reports allow you to organize and print
  database records. Reports are compiled by
  creating a report object. The easiest way to
  create a report object is to use the Report
  Wizard.
• To create a report, click Reports on the Objects
  bar, and click the New button.
• In the New Report dialog box,
• choose Report Wizard and
• select the table Access will
• use to create the report.

5
Create a Report Using a Report Wizard

• Next, choose the fields for the report in the
  Report Wizard dialog box.
• You can also group, sort, and specify summaries
  for fields in the report.

6
Create a Report Using a Report Wizard

• Choose the layout and orientation for the report
  in the Layout options dialog box.
• Choose the style for the report in the Style
  options dialog box.

7
Create a Report Using a Report Wizard

• The last step is to name the report. Use a name
  that gives an indication of the reports output.
• After Access creates the report, you can preview
  the report or modify the reports design.
• When finished, Access will save the report
  automatically with the name that you entered.

8
Modifying a Report

• Reports are modified in Design view. A report in
  Design view is divided into sections. Each
  section controls a part of the report and can be
  modified.
• The Toolbox has tools that you can use to modify
  reports.

9
Modifying a Report
REPORT SECTIONS
10
Creating a Macro

• Macros automate tasks you perform often. It is a
  collection of one or more actions that Access can
  perform on a database.
• To create a macro, click Macros on the Objects
  bar, and click the New button.
• In the Macro window, specify the actions to be
  performed by the macro.

11
Summary

• Database reports allow you to organize,
  summarize, and print all or a portion of the data
  in a database. Database reports are compiled by
  creating a report object.
• The easiest way to create a report object is to
  use the Report Wizard. When using the Report
  Wizard, first choose the table on which you want
  to base the report and the fields of that table
  you want to include in the report. You can also
  choose to group, sort, or summarize the records
  in the report.

12
Summary

• The Report Wizard also allows you to choose a
  layout, orientation, and style for your report.
  The style can give a report a casual or formal
  look.
• Reports are modified using Design view. Each
  report is divided into sections. Each section
  controls a different part of the report and can
  be modified.
• Macros automate tasks you perform often. The
  Macro window allows you to create a macro object.

13

• Return to the beginning of this presentation.
• Return to the PowerPoint Index