GCFLearnFree.org

All this was FREE!! The GCF team rocks!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2007
  • Using Reports to Make Data Meaningful to Others

Access 2007

Single page view print copy

Using Reports to Make Data Meaningful to Others

To modify the title of a report

To modify the title of a report:

  • Click on the Title command on the Format tab on the Ribbon.
    Report TitleTitle Command for Report
  • When the highlight appears, type in the new title.

To modify text in report headings

If you don't like the standard font face and size Access used to create your report, you can modify them using common Microsoft Office text formatting commands. You can modify the size, font face, font color, alignment, and much more. They all work basically the same way.

  • Highlight the text you want to change.
  • Select the formatting option you wish from the lists that appear when you click on a command.
    Report Text CommandsText Commands for Report
  • The change appears when you release the mouse button.

To apply an AutoFormat style

Like with forms, Access 2007 offers a variety of report styles in the AutoFormat command. To apply a style:

  • Click on the AutoFormat command on the Ribbon.
    Report AutoFormatsAutoFormats for Report
  • Select a format from the drop-down list. The change is applied instantly.

To change the page layout

When a report is created, it opens in Layout View, like the one in the picture below. The dotted lines are showing where the edge of the page will be in Report View.

Report Layout ViewReport in Layout View

To change the page layout options:

  • Switch to Print Preview using the Views command on the Ribbon.
    Print PreviewPrint Preview Command
  • Select the layout option you wish to alter from the Page Layout command group on the Ribbon.

Page Layout OptionsPage Layout Options for Report

All of the standard Microsoft page layout options are available, including:

Page Layout Option Description
Margins To set the margins for narrow, wide, or normal
Orientation To select either a Portrait or Landscape orientation
Size To set the paper size
previous next
previous 1 2 3 4 5 6 7 8 9 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.