Exporting Information to an HTML File


Many organizations that store accounting, manufacturing, marketing, sales, and other information on their computers have discovered the advantages of sharing this information within the company through an intranet, or with the rest of the world through the Internet. With Access, you can speed up this process by exporting the information stored in a database as Hypertext Markup Language (HTML) pages.

You can export tables, queries, forms, and reports to an HTML file. Access converts a table, query, or form to an HTML table when you export it, and converts a report to a series of linked HTML files (one for each page of the report).

Tip

If you export to an HTML file, you can view the table in a browser, such as Internet Explorer. To see the tags that define the structure of the table, either view the source in the browser or open the file in a text editor.


In this exercise, you will export a report from a database to an HTML file.

USE the 07_ExportHtml database. This practice file is located in the Chapter04 subfolder under SBS_Access2007.

OPEN the 07_ExportHtml database.


1.

In the Navigation Pane, under Reports, double-click Alphabetical List of Products.

The Alphabetical List of Products report opens in Report view.

2.

On the External Data tab, in the Export group, click the More button, and then in the list, click HTML Document.

3.

In the Export HTML File wizard, click Browse. In the File Save dialog box, navigate to the Documents\MSP\SBS_Access2007\Chapter04 folder, and then click Save.

4.

Select the Open the destination file after the export operation is complete check box, and then click OK.

The HTML Output Options dialog box opens. You can select the encoding you want to use for saving the file from this dialog box.

5.

With the Default encoding option selected, click OK.

For each page of the report, Access creates an HTML file with navigation links at the bottom. The report opens in your default Web browser.

6.

Browse the HTML files, comparing them to the report in Access.

CLOSE your Web browser, the Export HTML Document wizard, and the 07_ExportHtml database.




MicrosoftR Office AccessT 2007 Step by Step
MicrosoftR Office AccessT 2007 Step by Step
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 127

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net