INTRODUCTORY MICROSOFT ACCESS Lesson 5 - PowerPoint PPT Presentation

1 / 17
About This Presentation
Title:

INTRODUCTORY MICROSOFT ACCESS Lesson 5

Description:

Microsoft Office XP: Introductory Course Pasewark & Pasewark ... The style can give a report a casual or formal look. Reports are modified using Design view. ... – PowerPoint PPT presentation

Number of Views:95
Avg rating:3.0/5.0
Slides: 18
Provided by: Pas134
Category:

less

Transcript and Presenter's Notes

Title: INTRODUCTORY MICROSOFT ACCESS Lesson 5


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
New Report Dialog box
6
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.

7
Report Wizard
8
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.

9
Layout and Style Options
10
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.

11
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.

12
Report Design View with toolbox
13
Modifying a Report
REPORT SECTIONS
SECTION DESCRIPTION
Report Header Contents appear at the top of the first page of the report.
Page Header Contents appear at the top of each page of the report.
Category Header Contents appear at the top of each group. Because your report is grouped by Category, the band is called Category Header.
Detail Specifies the fields that will appear in the detail of the report.
Category Footer Contents appear at the end of each group. The summary options appear in this band.
Page Footer Contents appear at the end of each page of the report.
Report Footer Contents appear at the end of the report.
14
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.

15
Macro Design View
16
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.

17
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.
Write a Comment
User Comments (0)
About PowerShow.com