Expand the reach of your data and reports by exploring options for getting your data out of Microsoft Access, and making it easier to share with others. Learn how to leverage web-friendly data formats and connect to a hosted Microsoft Azure database.
- [Adam] Hi, my name is Adam Wilbert, and welcome to Access: Reporting the Web Systems. In this course, I'm going to take a look at some of the options for getting your data out of Microsoft Access and making it easier to share with colleagues on a private company intranet or with a larger audience on the public web. Access is a great place to organize and work with your data. But for all of its organizational advantages, it can also act as a barrier for actually using your data outside of the database container. This course is all about getting your data back out. We'll do this by starting out with Access's export options.
This will get us going with some basic HTML webpages that we can upload for viewing and allow us to export raw data in a variety of tabular formats. Then we'll expand on these built-in capabilities by modifying the exported files with a basic text editor. To do this, we'll need to move beyond Access and incorporate a little bit of webpage development into the workflow. And by converting our data into the JSON format, we can interact with it on a dynamic webpage. Finally, I'll take a look at leveraging Microsoft's Azure SQL Databases in order to store a database in the cloud instead of on a local computer and demonstrate how it can be made easier to view anytime, anywhere.
So thanks for joining me as we make the data that our Access desktop databases hold more accessible. Let's get to it.
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