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
     
  2.  
  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