Office 2007 Bible

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.

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. In this chapter, you use Report Wizards to create tabular and columnar reports. Feel free to use the database file you downloaded for this chapter to follow along with the actions described.

Creating a new report

The Access Ribbon contains several commands for creating new reports for your applications. The Create tab of the Ribbon includes a grouping called Reports containing several options such as Report, Labels, and Report Wizard. For this exercise, use the Report Wizard button to create a new report from tblProducts. Begin by clicking the Report Wizard button in the Reports group of the Create Ribbon tab. The Report Wizard dialog opens, as shown in Figure 37-5.

Figure 37-5. The first screen of the Report Wizard after selecting a data source and fields.

In Figure 37-5, tblProducts has been selected as the data source for the new report. Under the ...