Microsoft Office Tutorials and References
In Depth Information
Exporting an Access Query to an HTML Document
| Reference Window
• In the Navigation Pane, right-click the object (table, query, form, or report) you want to
export, point to Export on the shortcut menu, and then click HTML Document.
or
• In the Navigation Pane, click the object (table, query, form, or report) you want to export,
click the External Data tab on the Ribbon, click the More button in the Export group on
the External Data tab, and then click HTML Document.
• Enter the filename in the File name text box of the Export - HTML Document dialog box,
click the Browse button, select the location where you want to save the file, and then click
the Save button.
• Click the Export data with formatting and layout check box to retain most formatting and
layout information, check the other two check boxes, as necessary, and then click the OK
button.
• If using a template, click the Select a HTML Template check box in the HTML Output
Options dialog box, click the Browse button, select the location for the template, click the
template filename, and then click the OK button.
• Click the OK button.
• Click the Close button to close the Export - HTML Document dialog box.
To complete the following steps, you need to use Access and a Web browser. The steps
in this tutorial are written for Internet Explorer, the Web browser used at Belmont
Landscapes. If you use another browser, the steps you need to complete might be slightly
different.
You’ll export the qryCustomersByName query as an HTML document.
To export the qryCustomersByName query as an HTML document:
1. Start Access, and then open the Panorama database in the Level.02\Tutorial folder
provided with your Data Files.
2. Open the Navigation Pane (if necessary), right-click qryCustomersByName to dis-
play the shortcut menu, point to Export , and then click HTML Document . The
Export - HTML Document dialog box opens.
3. Select the text in the File name text box, and then type Customers by Name .See
Figure 8-1.
Search JabSto ::




Custom Search