Student Objectives: Create a
report using a Report Wizard.; Modify a report.
What is
a database report?
1) A database report allows you to organize,
summarize, and print all or a portion.
2) Reports can be used to print form letters and mailing labels.
How are
database reports created?
1) Click Reports on the Objects bar and click the New button
2) The New Report Dialog box appears and choose whether you want to use a Report
Wizard OR design the report manually by using the Design View. (Note: Charts and
Mailing Labels are also created from this window)
3) Next, choose either the table or query that report will be based on.
What is
grouping?
1) Grouping a report allows you to break it into parts based on the contents
of a field. (Ex. You could organize a customers report into parts that group the
customers by city).
2) Grouping can best be chosen in the Report Wizard feature. The user can group
by one field or more than one field.
What is
the use for Summary Options within a database report?
1) Summaries in a report group records that can be followed by totals,
averages, or other summary information.
How can
layout, orientation, and style options
be used while creating database reports?
1) The layout options let you choose how you want data
arranged on the page.
2) The orientation option lets the user decide if they want the
page to be portrait (8 1/2 X 11-longer than wide) OR landscape (11 X 8 1/2-
wider than long).
3) The style options are designed to give you some control over
the report's appearance. These options format or dress up the report.
How are
database reports modified or changed?
1) Whether a report is created manually or automatically by using the Report
Wizard, they can be modified by switching to Design view.
2) How do I do it? Open
the report in Design view, select the report in the Database window, then click
the Design button.
How are
database reports divided?
1) Like a form, the report is divided into sections, where each is identified
by a band. Each section controls a part of the report and can be modified.
2) Below summarizes the purpose of each of the sections in the report.
Report Header:
Contents appear at the top of the 1st 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.
Detail: Specifies the fields that
will appear in the detail of the report.
Category Footer: Contents appear at the end
of each group.
Page Footer: Contents appear at the end of each
page of the report.
Report Footer: Contents appear at the
end of the report.