Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
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.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.