Ms Office Tune Up

You’ve already learned how you can shuffle columns around in a report. However, that’s not all you can move. You can also add space between the rows (see Figure 8-4) and adjust all the following elements:

• The logo (in the top-left corner). In a new report, the logo looks like a notebook with a circle around it.

• The report title (right next to the logo). To start out, this is the name of the table or query on which the report is based (like Products).

• The date and time (which is updated every time you open the report). Initially, this appears in the top-right corner.

• The page number. This appears at the center-bottom of each page. In Layout view, Access treats the report as though all the data occupies one page, so you need to scroll to the end to find this element.

  
  Figure 8-4. Top: To add space between the rows, click a value in one of the rows, and drag it down.
  Bottom: All the rows are adjusted to have the same spacing.

• The report data (after the title). To change where the table in the report first appears on the page, click one of the column headers, and then drag it down (to add space between the title and the report data) or up (to remove the space).

• The totals (at the bottom of some columns). Access automatically adds calculations for numeric fields. For example, when the ProductCatalog report is first created, Access adds a total at the bottom of the Price column that indicates how much it costs to buy one of each product. (This total is of dubious valueto change it, select the column, and then pick another summary option from Report Layout Tools | Formatting Grouping & Totals Totals menu.)

Popularity: 3% [?]