Use the Report Wizard

How to Use the Report Wizard in Access

Use the Report Wizard

It's almost always easier to create and modify a report created by the Report Wizard than it is to create one from scratch.

  1. Click the Create tab on the ribbon.

    You can also create a blank report. Click the Create tab on the ribbon and click either the Blank Report button (to create and display the report in Layout View) or the Report Design button (to create and display a blank report in Design View).

  2. Click the Report Wizard button.

    The Report Wizard appears. Here, you need to specify the table or query that you want to use for your report.

  3. Click the Tables/Queries list arrow and select the table or query you want to use to create your report.
    Use the Report Wizard
  4. Double-click the fields that you want to appear on the form and then click Next.
    Use the Report Wizard

    If you selected fields from more than one table, the Form Wizard would ask how you would like to organize the data on your form; just make a selection and click Next.

    Now you must specify the fields that you want to use in your reports.

  5. Double-click any fields you want to group in the order you want to group them. Click Next.
    Use the Report Wizard
  6. Select the fields you want to use to sort your report and click Next.

    You can click the button to the right of each list to toggle between ascending and descending sort orders.

    Use the Report Wizard

    Now you need to specify your report's Layout and Orientation.

  7. Select a Layout option and an Orientation option for the report, then click Next.
    Use the Report Wizard
  8. Give your report a name and click Finish.
    Use the Report Wizard

The Report Wizard creates the new report and displays it on the screen.

FREE Quick Reference

Click to Download