7.06 Reports Assignment Instructions—Microsoft Access

  1. Open the Teacher database file you created in an earlier lesson.
  2. Click on the Create tab.
  3. Click on the Report Wizard in the Reports group section.
  4. Open the box under Tables/Queries and select the Teacher table.
  5. Select the fields you want to include: First Name, Last Name, Subject Taught, Grade 9, Grade 10, Grade 11 and Grade 12.
  6. Click Next - we will not add any grouping levels.
  7. Click Next – we will not sort.
  8. Select Columnar for the layout
  9. Select Portrait for the Orientation
  10. Click the box to have all fields fit on a page
  11. Click Next
  12. Choose the style you want for your report.
  13. Click next
  14. Give the report an appropriate name. (Enter your school name in the blank) ______Teachers.
  15. Select preview the report, click Finish. The report will appear in the Print Preview window.
  16. Click Close Print Preview button on the Ribbon. The report should be in Design View. If it isn’t, click on the Design tab, in the Views group, click the View arrow and select Design View.
  17. Insert a page header by moving the mouse pointer on the line between Page Header and Detail until it becomes a double-headed vertical arrow with a horizontal bar. Drag the mouse down until you have enough space to draw a control box (similar to a text box) for the header.
  18. You should have a new tool tab called Report Design Tools. Click on the Design tab and in the Controls group click on the Label button to create a control box in order to key your text.
  19. Draw a control box (just like you would for a text box). Make sure it is large enough to key the header information.
  20. Key the header information Subjects and Grades Taught
  21. When finished keying header, click outside of the control box.
  22. Select the control box by clicking it and resize, move it, or edit the text.
  23. Review your report by click the print preview button which located under the Report Design Tools, on the Design tab, click the View button arrow and select Print Preview.
  24. Choose to export your report to Word format. Make sure to note where you save the file. Save your file as Teachers – Columnar.
  25. Repeat the process above, except in step 8, select Tabular. Save this completed report as Teachers – Tabular.