Microsoft Office Tutorials and References
In Depth Information
Sending a Report to Another Application
Column Spacing: How much blank space to leave between one column
and the next (that is, between one label and the next across each row).
Book V
Chapter 2
Column Width and Column Height: The size of the labels. If you leave
the Same As Detail check box selected, Access adjusts these settings to
be the same size as the Detail section of the report.
Down, Then Across and Across, Then Down: The order in which the
labels print on each page.
You can use the settings on the Columns tab of the Page Setup dialog box to
create newspaper-style “snaking” columns for any report, not just mailing
labels. Make the Detail section of the report narrower than half the width of
the paper, specify two columns, and set the Column Layout property to
Down Then Across.
Sending a Report to Another Application
The nice thing about Microsoft Office is that all the programs are designed
to work together. Sometimes, they even do work together.
What if you want to include a report from your Access database in an Excel
spreadsheet? You can export reports, tables, and queries in file formats that
other Office programs can understand. If you export the same report
regularly, saving it in the same folder with the same name, you create a data task
that you can run again and again.
Exporting your report to Microsoft Excel
To export a report in Excel format, follow these steps:
1. In the Navigation Pane, click the report that you want to export to
Microsoft Excel.
2. Click the Excel button in the Export group on the External Data tab of
the Ribbon.
The Export – Excel Spreadsheet dialog box opens, as shown in Figure 2-12.
Another way to open this dialog box is to open the report in Print
Preview and then click the Excel button in the Data group on the Print
Preview tab of the Ribbon.
3. Click the Browse button to choose the folder where you want to store
the exported file, and type a name for the file in the File Name text box.
If you want to open the exported report automatically in Excel, select
the check box labeled Open the Destination File After the Export
Operation Is Complete. You can check that box only if the Export Data
with Formatting and Layout check box is already selected.
Search JabSto ::

Custom Search