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.

Enhancing report appearance

To add a logo:

  1. On the Home tab of the Ribbon, click the View command and select Layout View from the drop-down list.
    Switching to Layout ViewSwitching to Layout View
  2. Select the Design tab and locate the Header/Footer group, then select the Logo command.
    The Logo commandThe Logo command
  3. The Insert Picture dialog box will appear. Locate and select the desired image file and click OK to add it to your report.
    Inserting a logoInserting a logo
  4. A shrunken version of your image will appear in the header. Click and drag the image border to resize it.
    Resizing the logoResizing the logo
  5. If necessary, move your logo to the desired location by clicking and dragging it.
    The resized, repositioned logoThe resized, repositioned logo

Themes and fonts

A theme is a set of colors and fonts that applies to the entire database to give it a consistent, professional look. By default, databases use the Office theme. When you change the theme, all of the theme fonts and colors in your database change to match the new theme. Designing and modifying reports using theme elements can help you keep the appearance of your reports consistent.

To change the theme:

  1. Select the Design tab and locate the Themes group.
  2. Click the Themes command.
    The Themes commandThe Themes command
  3. A drop-down menu will appear. Hover the mouse over a theme to see a live preview of it.
    Hovering to preview a new themeHovering to preview a new theme
  4. Select the desired theme. The theme will be applied to your entire database.
    The report, now with a new themeThe report, now with a new theme

To change the theme fonts:

  1. Select the Design tab and locate the Themes group.
  2. Click the Fonts command.
    The Fonts commandThe Fonts command
  3. A drop-down menu will appear. Select a set of theme fonts.
    Selecting a new set of theme fontsSelecting a new set of theme fonts
  4. The fonts will be applied to your entire database.
    The report, now with new fontsThe report, now with new fonts