SQLConfiguration SQLConfiguration


Designing Reports   «Prev  Next»

Working with Sections in Access - Exercise

Use header and footer sections to refine a report

Objective: Use header and footer sections to refine a report
This exercise is worth 5 points. The exercise is auto-scored, which means that all you need to do to receive credit for it is click the Submit button below.

Instructions

  1. Create a report using the Report Wizard. Use the Monthly Hours by Project query as the basis of the report. Include all three of the query’s fields in the report. Group the report by Project Description. Use the Outline 2 layout.

Notice that the report already has controls in the page footer section, today’s date and the page number (incidentally, you can learn a lot about creating reports by studying reports created by the wizard).
  1. Add a small page header to the report.
  2. Add a label, 8-pt Arial type (to match the page footers), with the report title, Monthly Hours by Project. Make the title right justified; that is, put the control at the right edge of the design, and right justify the text within the control.