Microsoft Office Tutorials and References
In Depth Information
Opening and Viewing Reports
An easier way to tweak a report — in Word
An easier way to tweak a report is to transfer
your report to Microsoft Word and edit it there.
Follow these steps to turn an Access report
into a Word document:
1. On the External Data tab, click the More
button in the Export group and choose
Word on the drop-down list.
You see the Export - RTF File dialog box.
2. Click the Browse button, and in the File Save
dialog box, choose a folder for storing the
Word document, and click the Save button.
3. In the Export - RTF File dialog box, choose
Open the Destination File After the Export
Operation Is Complete.
4. Click the OK button.
In a moment, your Access report appears in
Word. The file is an RTF (rich text format) file. To
save it as a Word file, go to the File tab, choose
Save As, click the Browse button, and in the Save
As dialog box, open the Save As Type drop-down
list and choose Word Document. Books I and II
describe how to work with files in Word.
I tell you how to create a report with the Report Wizard in order to avoid
your having to visit this imposing window. However, you can change a
report’s appearance in Layout view without going to very much trouble if
you follow these instructions:
✦ Choosing a new layout: On the (Report Layout Tools) Arrange tab, click
the Stacked or Tubular button, or click the Gridlines button and choose
an option on the drop-down list, to change your report’s layout.
✦ Including page numbers: To include page numbers on the report, go the
(Report Layout Tools) Design tab and click the Page Numbers button. You
see the Page Numbers dialog box shown in Figure 5-3. Choose the Page N
option button to display a page number only, or select the Page N of M
option button to display a page number as well as the total number of
pages in the report (as in “Page 2 of 4”). Choose Position and Alignment
options to describe where on the page to put the page number.
✦ Changing the margins: On the (Report Layout Tools) Page Setup tab,
click the Margins button and select Normal, Wide, or Narrow on the