With the Access data now stored in an Azure SQL database, the data is available at any time to custom applications written in .NET or with Visual Studio.
- [Instructor] Now that our Access data…is in the Azure Cloud, applications can be written…to access that data at any time.…Typically this is going to be done…through a custom app created in Visual Studio…or through a web app using dot net.…Both options are going to require a programmer…that's familiar with those development environments…and that's well beyond the scope of this course.…However, we can use the Azure portal…to interact with the data online.…To do that, from the main dashboard of the Azure portal…we'll go over and press the Sequel Databases button.…
Then I'll click on the link for the database…that we want to work with.…From the overview page, I'll press the Tools button.…Here we have two different options:…we can either open up the database directly…inside of Visual Studio, we'll connect it here.…I'll go ahead and close this blade.…Or, we can query the database directly with a query editor.…I'll go ahead and choose that option.…Before we can run any queries we need to log in again…so I'll press the Log In button,…
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