Creating A Report in MS Access Using the Report Wizard

  1. Once your database is open, select the table you want to use for your report. It should be highlighted like in the image below.

  2. Click on the Create tab.

  3. Choose Report Wizard.

  4. When the Report Wizard Dialog Box appears, choose the fields you want to add to your report. See the image below for help.

  5. Click Next.

  6. If you want to group your report, you would do it here.

  7. Click Next.

  8. If you want to sort your report, you would it here. You can sort Ascending or Descending.

  9. Click Next.

  10. When you get to the layout dialog box, click Next.

  11. Choose the style for your report.

  12. Click Next.

  13. This is where you add the Title to your report. Be sure to include your name in the Title. See the image below for help.

  14. Click Finish and your report will open automatically.