Inside of the exercise files folder are subfolders for each chapter, and within those are the database files and other support files used in this course.
- [ Instructor] If you have access to the exercise files for this course then you're going to be able to follow along with the actions that I'm performing on the screen. Simply uncompress the download zip file and place it in a location on your computer that's easy to get to. I've gone ahead and placed mine here on the desktop. Inside the Exercise Files folder, you'll see a folder for each chapter in the course; and inside of these, we'll see individual folders for each movie. Inside of each movie's folder are the individual exercise files that we're going to be using. For the access database files, just double-click on them to open them up inside of access, and then click on the yellow Enable Content button that appears in the yellow bar.
This will give us code highlighting as well as line numbers, which should make it easier for you to follow along. If you'd like to use Brackets too, then you can download it at brackets.io. Now if you don't have access to the exercise files, that's okay; you can apply what you see to your own files or simply sit back and watch.
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