1-866-245-5224 sales@keystonelearning.com

Access 2003: Using the Reports Wizard

Access 2003: Using the Reports Wizard

The Reports Wizard of one of the quickest ways to build a report while still maintaining control over which fields you choose to display and which Tables and/or Queries you choose to use.

Plus, with the Reports Wizard, you can define how the data is grouped and sorted.

  1. Click the Reports object in the Database window
  3. Click the New button

Figure 42. New Report Dialog Box

   3.      Choose Report Wizard and select a table or query on which to base your new form

   4.      Click OK


Figure 43. Report Wizard - Choose Table/Query Fields


   5.      Select a Table or Query

   6.      Move fields from Available Fields to Selected Fields

   7.      Repeat steps 5 and 6 for additional tables for queries

   8.      Click Next



Figure 44. Report Wizard - Choose Grouping Levels


   9.      Choose a grouping level, if desired

   10.  Click Next


Figure 45. Report Wizard - Choose Sort Order


   11.  Choose a Sort Order by field, if desired

   12.  Click Next


Figure 46. Report Wizard - Choose Report Layout


   13.  Choose a Report Layout

   14.  Click Next


Figure 47. Report Wizard - Choose Report Style


   15.  Choose a Report Style

   16.  Click Next


Figure 48. Report Wizard - Choose Report Title


   17.  Enter a Report Title

   18.  Click Finish