• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part 5. Using Access > Task 11 How to Create a Report

Task 11 How to Create a Report

You can choose to print any table, form, or query at any time; however, using the Report tool can make the data appear more professional and polished. With the Report Wizard, the task of creating a meaningful report becomes simple and effortless.

  1. Open the Report Wizard

    Open the database you want to use and click Reports in the Objects bar of the Database window. Double-click Create report by using wizard to open the Report Wizard dialog box.

  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 of selected fields. Select as many fields from as many different tables or queries as you want and click Next when you're ready to continue. In this example, I'm creating a customer phone list, so the fields I need are on the Customers table.

  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 pane, choose a field to use as a grouping category and click the > button. Click Next to continue. I want to organize the list by ZIP Code, so I'll choose that field.

  4. Choose a Sort

    You can sort by as many as four fields, either in 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.

  5. Select a Layout

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

  6. Select a Style

    As you did with the layout options in Step 5, you can click to see examples of the different report styles available. Choose a style for your report and click Next.

  7. Assign a Title

    In the final wizard dialog box, type a report title and click Finish. Your new report is created and displayed as its own separate window onscreen. To print the report, click the Print button in the toolbar.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint