Access supports the use of an HTML template for pre-configuring tabular exports. With a template, graphics, links, and stylesheets can all be prepared ahead of time in order to give your exports a polished and consistent look.
- [Teacher] The Access HTML exporter includes support…for customized templates.…By creating a template you can pre-write…much of the webpage and include customized graphics,…navigation links, header and footer details,…and any other content that you want…in addition to the exported tables.…Inside of the exercise files folder for this movie,…I have a couple of files that I want to point out.…First I have the template, that HTML file,…that'll serve as the template for our export.…Then I have the style sheet that's going to style our data,…as well as a logo for the Kineteco company.…
Finally we have the database that's going to serve…as the data source when we export our data.…Let's go ahead and take a look…at the template HTML file in our text editor.…At the top I have the HTML tag and then we have…the header section.…Inside of the header we have a meta data information…as well as a link to the style sheet called Template.css.…Then we have the body section for the HTML file.…In the body we have a header that'll include…
In this course, Adam Wilbert shows you how, by exploring options for getting your data out of Microsoft Access, making it easier to share with others. He covers Access data export options, and demonstrates how to modify exported files with a text editor. He also explains how to link Access to an Azure SQL database to provide a cloud storage solution for your Access tables.
- Why not use web apps?
- Exporting data to HTML
- Formatting HTML with table CSS
- Working with data exports
- Converting data to JSON
- Building a webpage to parse exports
- Linking to an Azure SQL database
- Linking Access to Azure tables
- Interacting with data on the web