How to Convert Access Forms to Web Formatby Matthew Burley
Database programs, such as Microsoft Access, are naturally compatible with websites that rely on stored information for generating and saving content. While the database is stored on a server that operates behind the scenes of the website, there must be a a method for entering or retrieving data. Forms, such as those created in Microsoft Access, are perfect for generating a user interface to communicate with a database. Access forms can even be converted to the HTML web format within the Access program, thereby simplifying the process of converting from your local database to the Internet.
Double-click your Microsoft Access file to launch the database in Microsoft Access.
Double-click your form in the "Objects" column on the left side of the screen.
Click the "External Data" tab at the top of the screen.
Select the "More" option in the "Export" section to expand the list of file export options.
Click the "HTML Document" option to launch the "Export" window.
Click the "Browse" button at the top of the window to choose a location for the web-formatted Access form that you are about to export, then click the "OK" button.
Select the form of encoding that you want to apply to your web form, then click the "OK" button. The available encoding options include "Default encoding," "Unicode" and "Unicode UTF-8." If you don't know which encoding type you require, select the "Default encoding" option, as that will use your computer's current default system encoding to create the file.
Check the box next to "Save export" steps if you wish to perform this conversion again in the future, then click the "Close" button.
- If your web needs require a different file format than HTML, you also have the option of exporting your data to the XML data format. To perform this export, simply select "XML file" from the menu instead of "HTML document."