Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You can turn any Access object into a Web page using HTML or XML, whether it's a table, a form, a report or a query result. Let's first export a customer's table into HTML. Click on it once, then click on the External Data Ribbon and then over here to the More button, you'll find HTML Document. It will ask you where you want to save the file. Click on Browse, if you want to change the location or the name. Let's put a check mark here to export the data, including the formatting and the layout, and we will put a checkmark here, so that it opens up the Web browser, so we can see our results, and click OK.
If you have a pre-created HTML template, you can put a checkmark here to use it. We're just going to click OK, and here is our Web page with our data. Now let's close it. You'll see a window that asks if you want to save your export steps, but we don't need to do that, so click Close. Now let's do the same thing to create an XML copy. Click on the Customers table once, and over in the Export section, you'll see an XML button. Again, if you need to change the name or the location, you can browse and do so, and click OK.
It will ask you for a variety of settings. Check the ones you need, and don't forget about this More Options button down here. Now, we're going to go with all the defaults, so click OK. It will ask us if we want to save our export steps. And we don't, so click Close. Now let's navigate over to our Documents folder where we have that saved. Here's my XML file. I will it open up, and there it is. Now either of these two formats, the HTML or the XML, would then need to be integrated into your Web site and published using FTP.
But as you can see, it's not hard at all to create a Web page in HTML or XML right from inside Access.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64717 Viewers
80 Video lessons · 124327 Viewers
52 Video lessons · 60259 Viewers
59 Video lessons · 46095 Viewers