If you are familiar with Access, manage some data that you want to share publicly, and are ready to dig into some raw text files, then you’ve got everything that you need to move forward.
- [Instructor] Getting data out of Access and sharing snapshots of it with others on the internet has always been a bit tricky. Access simply wasn't built with the web in mind, so many solutions rely on expanding on the features that are available and shaping them with additional tools. With that in mind, here's what you need to know for this course. I expect that you've worked with Access for creating and managing your own data and that you feel comfortable creating tables and queries, as well as linking them through relationships. If you need a quick introduction to Access, my short course, called Learn Access 2016, will get you ready to proceed with this course.
I also expect that you have a need to make some of your Access data available for others to find. What we'll be spending the majority of our time on and what I don't expect that you have any experience with is building a webpage. I'll be covering the basics of creating an HTML document using a basic text editor, as well as using it to dig into some of the data files that we'll export from Access to get a better understanding of how they work. Once you've built a webpage that includes the data that you'd like to publish publicly, you'll need to upload it to a web server and get a URL for the page to share it with your audience.
For the purposes of experimentation and development, it might be useful to have a local web server running on your own computer, and I'll take you through the steps of setting that up later on in the course. So that's it. If you're familiar with Access, manage some data that you want to share publicly, and are ready to dig into some raw text files, then you've got everything that you need to move forward.
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