As you learned earlier in this book, you specify the fields, records, and sort order of the records in
a query. Access treats this recordset data as a single table (for processing purposes) in datasheets,
forms, and reports. The recordset becomes the source of data for the report and Access processes
each record to create the report. When the report is run, Access matches data from the recordset or
table against the fields specified in the report and uses the data available at that moment to produce
the report.
In this example, you use data from tblProducts to create a relatively simple tabular report.
Creating a Report with Report Wizards
Access enables you to create virtually any type of report. Some reports, however, are easier to create
than others, especially when a Report Wizard is used as a starting point. Like Form Wizards,
Report Wizards give you a basic layout for your report, which you can then customize.
301
Presenting Data with Access Reports 9
Report Wizards simplify the layout process of your controls by visually stepping you through a
series of questions about the type of report that you want to create and then automatically creating
the report for you.
Pages:
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708