Microsoft Office Tutorials and References
In Depth Information
Creating Reports Automatically
Book V
Chapter 1
What view opens when you open a report?
Now that Access has four (count ’em) views in
which to open a report, it can be hard to guess
which view you’ll see when you double-click a
report in the Navigation Pane to open it: Report
view or Print Preview. To clear up this
confusion, you can set the Default View
property of the report.
Design or Layout view and then choose
Report from the Selection Type
dropdown menu.) Then, on the Format tab of
the property sheet, set the Default
View property to Report View or
Print Preview .
Be sure that you’re looking at the property
sheet for the report, not for one of the elements
of the report. While you’re at it, set the Allow
Report View and Allow Layout View
properties to No if you don’t want to enable
those views.
With a report open in Design or Layout
view, display the property sheet for the
form. (Double-click the top-left corner of
the form in Design view, or click the
Property Sheet button in the Tools group
on the Design tab of the Ribbon in either
Reports can include features that don’t appear on forms, including these:
Grouping and sections: When you design a report, you frequently want
to group certain information. A monthly sales report, for example, may
list sales by product, with subtotals for each product; a mailing-label
report may start a new page for each new zip code and print the total
number of labels for each zip code. You can have up to four grouping
levels. You can add grouping levels by adding section headers to your
report in Design view, as described in “Grouping your records,” later in
this chapter.
Page headers, footers, and numbers: Most reports have page numbers
and many need other information printed at the top or bottom of every
page. For details, see “Adding page headers, footers, and numbers,” later
in this chapter.
Margins, paper size, and paper orientation: Reports usually end up on
paper, and you can configure your report to fit, as described in Chapter
2 of this minibook.
First, we cover how to create some reports the easy way: by using a wizard.
Creating Reports Automatically
You create a report the same way that you create other objects in your
database. Take a look at the Reports group on the Create tab of the Ribbon to
see some ways to make a report. The buttons are listed in Table 1-1.
Search JabSto ::




Custom Search