from menu bar of Access. Access responds by providing print preview tool bar for reports. (iii) Click at right corner of icon for Official Links. There are three options in the list: Merge It with MS Word, Publish It with MS Word and Analyse It with MS Excel.
(iv) Click Publish it with MS Word , which is also the default option. (v) The generated report is exported to MS Word package and can be dealt with like any other document created using MS Word. (e) Printing a Report : A generated report may also be printed by taking the following steps provided a printer attached to the computer is installed. (i) Choose File from menu bar % Print (ii) Access responds by providing a print window, which allows the user to select a printer, the number of copies to be printed and also the range of pages to be printed.
(iii) Properties button is clicked to define print quality under set-up tab and orientation under paper tab. Two-sided printing may also be obtained if the printer supports this feature. (f) E-Mailing a Report : A report generated by Access may also be sent using E-Mail facility, provided the computer system has Internet facility and is connected to the Mail Server of the Internet Service Provider (ISP). In order to send a report using E-mail facility, following steps are required : (i) Select and generate a report in Database Window (ii) Click at File % Send-To % Mail recipient from Menu bar of Access.
A Send dialog box appears with various options for choosing the Format: Microsoft Excel, HTML, Snapshot format, Rich Text format, etc. (iii) Choose an appropriate format and click OK . Access responds by providing an E-Mail composition window. (iv) Fill up the details regarding E-mail address of recipient and others to whom copy of report is to be sent; provide a subject to E-mail and click at Send button.
The report gets dispatched to the mailbox of the recipient of E-mail. Test Your Understanding Fill in the blanks (a) Reports, the need for which is