One of the great features of today’s software programs is that they can publish information online even database information. With Microsoft Acces 2007, you can take tables and publish them online to share information without having to retype the information in an HTML format. This function is convenient and easy to use in today’s high tech world. In this short tutorial, I will you the steps to publish an Access database table online.
- Go to Office>Open and from the “All Tables” list, click the table that has the data you want to publish in the web. Then on the right hand side of the screen, click the specific data that you want show in the web page.
- Go to External Data>Export>More and go down and click the “HTML” option. Next, the “Export – HTML Document” pop up window box will appear, and in here, first ensure you enter the “destination file and format” so that the web page is saved in the right place. Then, click on “Export Data with Formatting and Layout.” Then, click “Open the Destination File after the export operation is complete” if you’re exporting all the records from the table or select “Export only the selected records” if you’re posting specific records, and click OK.
- Next, the “HTML Output Options” pop up window box appears and here you can click OK if you don’t have an HTML template or search for an HTML template and then click OK to move to the next step. If you don’t pick an HTML template, the table will show in the web page as it regularly looks in Access but within a browser.
- Finally, the “Export HTML Document” pop up window box appears asking you if you want to save the settings that you have just created. In this case, don’t click on the box and click Close. You don’t really need to save the settings as the steps are easy and understanble and perhaps you have different criteria the next time you want to publish an Access table online.
- Now, you can click your internet launcher to see your new access table web page, and then you can have a talk with your IT buddies to upload the new internet web page to the server so that it can go live online as soon as possible.
Great Job! You just learned how to publish an Access database online.