Part I: Access Building Blocks
348
FIGURE 9.26
Building the new report in Design view
Fields in selected table
Other tables in database Fields in
related tables
Defining the report page size and layout
As you plan your report, consider the page-layout characteristics as well as the kind of paper and
printer you want to use for the output. As you make these decisions, you use several dialog boxes and
properties to make adjustments. These specifications work together to create the desired output.
Click the Page Setup tab in the Access ribbon to select the report’s margins, orientation, and other
overall characteristics. Figure 9.27 shows a portion of the Access screen with the Page Setup tab
selected, and the Margins option open.
Notice that the Page Setup tab includes options for setting the paper size, the report’s orientation
(Portrait or Landscape), its margins, and other details. Dropping down either the Size or Margins
option reveals a tab containing common settings for each of these options.
rptProductDisplay is to be a portrait report, which is taller than it is wide. You want to print
on letter size paper (8^1 ⁄ 2 x 11 inches), and you want the left, right, top, and bottom margins all set
to 0.25 inches. In Figure 9.27 notice that the Narrow margins option is selected, which specifies
exactly 0.25 inches for all four margin settings.
