Step 1: Open the Report Wizard

Select Report Wizard from the list of options and click OK to open the Report Wizard window. 

 

 

 

 

 

Step 2: Choose a Table or Query

From the Tables/Queries drop-down list, select the table or query to use in your report. Select a field and click the > button to add it to your list. Select as many fields from as many different tables or queries as you wish and click Next when you're ready to continue. 

 

 

 

Step 3: Choose a Grouping Category

A report that groups information by relevant categories is much more useful than one that simply lists information alphabetically. From the left display window, choose a field to use as a grouping category and click the > button. Click Next to continue. 

 

 

 

 

Step 4: Choose a Sort

You can sort by as many as four fields, in either ascending or descending order. From the first drop-down list, select the field to use for the primary sort and continue until you have chosen as many sort fields as needed. Click Next to continue. 

 

 

 

 

 

Step 5: Select a Layout

Select a layout option to see an example of how it will look. When you have decided on the layout options, you're ready to move on. Click Next. 

 

 

 

Step 6: Select a Style

As with the layout options, you can see examples of the different styles by clicking the options. Choose a style for your report and click Next. 

 

 

Step 7: Assign a Title

In the final wizard dialog box, enter a report title and click Finish. Your new report is created and displayed as its own separate window on-screen.