Microsoft® Office Access 2003 Step by Step

Creating a Report from Scratch

When you want to create a report that displays records from one or more tables, the Report Wizard is the fastest way to create the report and include all the desired field captions and contents. However, sometimes a main report simply serves as a shell for one or more subreports, and the main report displays little or no information from the underlying tables. In this case, it is often easier to create the main report by hand in Design view.

In this exercise, you will use a query as the basis for the shell for a report that lists sales by category. A CategoryName section will list the current category, but the Page ...