Share this Page URL

Chapter 12. Access and the Web > Exporting Data as HTML - Pg. 413

Access and the Web 413 System requirements for working with data access pages To view and work with data access pages on the Internet or an intranet, users need Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later. Before we describe the details of how to create and work with data access pages, we'll explain how to export data from Access as HTML (which stands for Hypertext Markup Language), the markup language used to create Web pages. Exporting Data as HTML One way to get the data you store in an Access database into a format that you can view in a Web browser is to export the data as HTML. Exporting a table, query, form, or report as HTML is a quick procedure. You simply select the object in the Database window, choose Export from the File menu, choose HTML Documents as the file type, and click Export. The HTML page that's created when you export data has no live connection to the object you ex- ported. When you open the page in a Web browser, you'll see the data, but you can't update, edit, or otherwise work with the data (you can't perform calculations, for example) in the browser. The page displays a fixed representation of the data, which might be all you need in some cases. HTML--Hypertext Markup Language You don't need to understand HTML to work with Access data on the Web. Access creates the HTML required to display data in a Web browser when you export the data. However, if you want to do more with Access data on the Web--from enhancing the presentation of the data to adding scripts that can automate some of a Web page's behavior, you should learn more about how HTML works. As an introduction, try Michael Morrison's Faster Smarter HTML & XML (Microsoft Press, 2002). In the following steps, we'll export a query as HTML and then open the page in Internet Explorer 6.0. (You don't need to have Internet Explorer 6.0 to open the HTML document that is created in this exercise. You can open a Web page that's created by Access in any browser that supports HTML version 3.2 or later.) Export data as HTML 1. 2. 3. Open the file HelloWorld12.mdb, located in the Chap12 folder where you copied the sample files for this book. In the Database window, click Queries in the Objects list, and then select the query named qryExpenseDetails. On the Database window toolbar, click Open. You'll see the records that this query retrieves, shown here: