Reports

A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it.



Create a Report using the Wizard

As with the Form, it is a very good idea to create a report using the wizard, unless you are an advanced user. Microsoft Access does a very good job using the wizard to create reports.

  1. Switch to the Database Window. You can do this by pressing F11 on the keyboard.
  2. Click on the Reports button under Objects on the left side of screen
  3. Double click on Create Report Using Wizard
  4. On the next screen select the fields you want to view on your form. Most of the time you would select all of them.
  5. Click Next
  6. Select if you would like to group your files. Keep repeating this step for as many groupings as you would like.
  7. Click Next
  8. Select the layout and the paper orientation you desire
  9. Click Next
  10. Select the style you desire...HINT: if you plan on printing your report, I suggest you use a light background to save on printer toner and ink
  11. Click Next
  12. Give you report a name, and select Preview the Report
  13. Select Finish
  14. You should see your report. To adjust the design of your report, simply hit the design button (same as with the tables), and adjust your report accordingly


Creating Mail Merge Labels using a Wizard

Microsoft Access lets you create Mailing Labels for your database that you have. To do this do the following:

  1. Switch to the Database Window. You can do this by pressing F11 on the keyboard.
  2. Click on the Reports button under Objects on the left side of screen
  3. Click on New
    Mail Merge
  4. Select Label Wizard and the table you would like to get your information from.
    Label Wizard
  5. Click OK
  6. Select the layout of your labels
  7. Click Next
  8. Select the font size and color you want on each label
  9. Click Next
  10. Select how you want your label to look
  11. Click Next
  12. Select how you want your labels sorted
  13. Give your label report a name and preview it