To give data a place to live in the cloud, you can set up an empty SQL database. Later, you'll connect this database to Access and move the data into it.
- [Instructor] To give our data place to live in the cloud,…we're going to set up an empty SQL Database.…Later, we'll connect to this database to access…and move our data into it.…That'll allow us to manage the data from access,…while physically storing it in the cloud.…Once you have your Azure account set up,…go ahead and log in at portal.azure.com.…That should drop you off here on the Azure dashboard.…To create the database, we'll come over here…to the left hand menu.…Now, if you're just seeing the icons…and not the text, you can click this button…up here at the top to hide or show the full menu.…
Go ahead and click on the New button,…and then we'll scroll down until we find…the Databases section.…We're going to create a new SQL Database.…To do that, we need to fill in some of these details.…Let's go ahead and give our database a name.…I'll call it AccessDatabase.…I'll choose a Subscription level,…yours probably says free trial,…but I'm on a paid account now,…so I'll choose my Pay-It-As-You-Go account.…We need to set up a new resource group for our database.…
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