Microsoft Access 2010 Bible

(Rick Simeone) #1

Part I: Access Building Blocks


322


FIGURE 9.3

An invoice report (rptInvoice)


Main report

Subreport

Mailing-label reports
Mailing labels (shown in Figure 9.4) are also a type of report. Access includes a Label Wizard to
help you create this type of report. The Label Wizard enables you to select from a long list of label
styles. Access accurately creates a report design based on the label style you select. You can then
open the report in Design mode and customize it as needed.

Distinguishing between reports and forms
The main difference between reports and forms is the intended output. Whereas forms are primar-
ily for data entry and interaction with the users, reports are for viewing data (either onscreen or in
hard-copy form). Calculated fields can be used with forms to display an amount based on other
fields in the record. With reports, you typically perform calculations on groups of records, a page
of records, or all the records included in the report. Anything you can do with a form — except
input data — can be duplicated by a report. In fact, you can save a form as a report and then refine
it in the Report Design window.
Free download pdf