Access 2016: Reporting to Web Systems

Get your data out of Microsoft Access and make it easier to share with others. Learn how to leverage web-friendly data formats and connect to a hosted Microsoft Azure database.

Access databases typically live on your desktop and are shared with a limited
number of users over a local network. Microsoft SharePoint integration allows you to share data on the web, but this solution can be complicated for many users. There are several alternatives that you can consider. By leveraging web-friendly data formats—such as a basic HTML table or machine-readable XML, CSV, and JSON data files—or connecting to a hosted Microsoft Azure database, Access users can expand the reach of their data and reports.

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.

Introduction

• Welcome
• Using the exercise files
• What you should know
• Why not use web apps?

1. Export Data to HTML

• Output documents to HTML tables
• Format HTML with table CSS
• Use an HTML template
• Save and schedule exports

2. Working with Data Exports

• Export XML
• Export tables as text files
• Work with CSV and delimited files
• Convert data to JSON

3. Build a Webpage to Parse Export

• Install a local web server
• Create the HTML and CSS framework
• Understand JavaScript and jQuery
• Filter loaded JSON data

4. Link to a SQL Azure Database

• What is Azure?
• Create an Azure SQL database
• Install SQL Server Management Studio
• Link Access to Azure tables
• Interact with data on the web

Conclusion

• Next steps