Saving Database Objects as HTML
Probably one of the most basic but powerful features in Access is the capability to save database objects as Hypertext Markup Language (HTML) documents. You can publish table data, query results, form datasheets, and reports all as HTML. The following sections cover each of these objects.
Saving Table Data as HTML
When saving table data to HTML, you can store it in the HTML file format so that you can easily publish it on the Web. Just follow these steps:
Access exports the file to HTML so that you can view it from any Web browser (see Figure 26.1). You can also view the HTML source, as shown in Figure 26.2.
Figure 26.1. The Northwind Customers table saved as HTML.

Figure 26.2. Viewing the source of the Northwind Customers table's HTML file.

Saving Query Results as HTML
The capability to save query results as HTML means you don't need to save all fields and all records to an HTML file. In fact, you can even save the results of Totals queries and other complex queries as HTML. Saving the result of a query as HTML is similar to saving a table as HTML:
Access exports the file to HTML so that you can view it from any Web browser. You can also view the HTML source.
Saving Forms as HTML
Because an HTML file is a static file, you can only save a form's datasheet as HTML. A static HTML file doesn't change as the data in the database changes, nor can you modify the data in the HTML file. To save a form's datasheet as HTML, follow these steps:
Access exports the file to HTML so that you can view it from any Web browser. You can also view the HTML source.
Saving Reports as HTML
You can save reports and their formatting as HTML, too, which is an elegant way to publish data on an Internet or intranet site. To publish a report as HTML, just follow these steps:
Access exports the file to HTML so that you can view it from any Web browser. You can also view the HTML source. Figure 26.3 shows a report published as HTML.
Figure 26.3. Viewing the Alphabetical List of Products report as HTML.

Because the report is a multipage report, Access generates several HTML files. Each page of the report is linked, and the user can easily navigate from page to page by using the First, Previous, Next, and Last hyperlinks automatically generated during the export process.