viewed by others without the help of Access. This becomes possible by saving the report as a snapshot file. As a result, a high quality picture image of each page of report is created with Adobe Acrobat software. Other users of the report can then view the report and print any of its pages without being able to modify its contents.
It must be ensured that this feature of saving a report as snapshot is also installed while installing the MS Office package. In order to create a report Snapshot, following steps are required : Select and generate a report in Database Window. Click File % Export from menu bar. An Export Report dialog box appears.
Choose the folder from combo box next to Save in ; provide a file name; select snapshot from list control next to Save as type and click at Save button. While saving the report ensure that the auto start check box is enabled. The generated report is saved as a snapshot and can be supplied to others for printing and viewing without the help of the Access database environment. (c) Exporting to Excel : A generated report may be exported to Excel, which is a spreadsheet package.
This software package is a part of MS Office product and is generally installed while installing MS Access. A report is exported to Excel by following the same steps as have been listed above while saving a report as snapshot, except that before clicking save button in (c) above, one has to select Microsoft Excel from list control next to Save as type. (d) Exporting to MS Word : A report generated using Access can also be exported to MS word, which is a text processing package. This package is also installed while installing MS Access, as a part of MS Office.
In order to export a report to MS Word, the following steps are required : (i) Select and generate a report in Database Window. (ii) If print preview tool bar is absent in Access window, Click View % Tool bars % Print preview