Advanced Report Options

There are many types of reports in Access 2010, as well as various advanced options for modifying an Access report. Learn them here.

Formatting reports

Video: Formatting Reports in Access 2010

Launch video!Watch the video (3:54).

One of the strengths of reports is that you can modify their appearance to make them look how you want. You can add headers and footers to your report, apply new colors to the layout, and even add a logo. All of these things can help you create visually appealing reports.

Modifying report text

The bulk of the information in your report comes straight from the query or table you built it from, which means you can't edit it within the report. However, you can change, add, or delete label text, headers, and footers to make your report clearer and easier to read. For example, in our report, we decided that we didn't need the field headings to understand our data, so we deleted them.

When working with text and text boxes in reports, you can use many of the text and shape formatting tools you use in other Office programs to modify color, font, and other settings. If you're not sure how to perform basic text and shape formatting, you can read the Formatting Text and Working With Shapes lessons from our Word 2010 tutorial.

Our report, with simple text formatting appliedThe report, with simple text formatting applied

Modifying the page header and footer

To view and modify the header and footer that appear on every page of your report, select the View command on the Ribbon and switch to Design view. The header and footer are located in the white space beneath the Page Header and Page Footer bars.

The page header and footer in Design ViewThe page header and footer in Design View

Depending on your report's design, sometimes you may find that there is no white space in the page header and footer, as in the image above. If this is the case, you must resize the header and footer before you can add anything to them. Simply click and drag the bottom border of the header or footer to make it larger.

Resizing the page headerResizing the page header

To add text to a header or footer:

  1. On the Ribbon, select the Design tab in the Report Design Tools group and locate the Controls group.
  2. Select the Label command.
    The Label commandThe Label command
  3. Place your cursor in the white space in your header or footer, and click and drag to create your label. Release the mouse when it is the desired size.
    Clicking and dragging to create a labelClicking and dragging to create a label
  4. Place your cursor in the text box, click once, and type the desired text.
    Adding text to the labelAdding text to the label

To add the date and time to a header or footer:

  1. On the Ribbon, select the Design tab in the Report Design Tools group and locate the Header/Footer group.
  2. Select the Date and Time command.
    The Date & Time commandThe Date and Time command
  3. The Date and Time dialog box will appear. Select the desired formatting options. A preview of the text that will be included in your report will appear. When you are satisfied with the appearance of the date and time, click OK.
    Selecting options in the Date and Time dialog boxSelecting the date and time format in the Date and Time dialog box

By default, the date and time appear in the header. If you want to move them to the footer instead, click the date and time boxes and drag them to the desired location.

To add page numbers to a header or footer:

  1. On the Ribbon, select the Design tab in the Report Design Tools group and locate the Header/Footer group.
  2. Select the Page Numbers command.
    The Page Numbers commandThe Page Numbers command
  3. The Page Numbers dialog box will appear. Select the format of the page numbers.
    • Select Page N to display the number of only the current page.
    • Select Page N of M to display the number of the current page and the number of total pages.
  4. Select whether to put your page numbers in the header or footer.
  5. Click the drop-down arrow to select the alignment of the page numbers.
    Selecting page number settings in the Page Numbers dialog boxSelecting page number settings in the Page Numbers dialog box
  6. When you are satisfied with the settings, click OK.