Frequently Asked Question

Please download and install this driver first.

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16#download-for-windows

Open access and follow screenshots.

Create a new blank database.

Click the External Data Tab

You may receive an error here – you can ignore

Dassql1.database.windows.net

Use your Email below not mine.

Change from default to daswarehouse

Trust certificate.

Now you can select the Machine Data Source to easily access the Data Source. You will be required to enter your email password.

Once authenticated you can select the tables and fields you want to link. We will cover this in training.