Free E-Books

Figure 9-3 shows an invoice report (rptInvoice) from the Access Auto Auctions database system in
Report view.
In Figure 9-3, the information in the top portion of the report is on the ???main??? part of the report,
whereas the product details near the bottom of the figure are contained in a subreport embedded
within the main report.
Mailing labels
Mailing labels are also a type of report. You can easily create mailing labels, shown in Figure 9-4,
using the Label Wizard to create a report in Access. The Label Wizard enables you to select from a
long list of Avery label (and other vendors) paper styles, after which Access correctly creates a
report design based on the data you specify to create your label. After the label is created, you can
open the report in Design mode and customize it as needed.
299
Presenting Data with Access Reports 9
FIGURE 9-3
An invoice report (rptInvoice)
FIGURE 9-4
rptCustomerMailingLabels, a typical mailing-label report
Distinguishing between reports and forms
The main difference between reports and forms is the purpose of the output.


Pages:
681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705