Connect SharePoint to MS Access

You can consider SharePoint as an extension of the Office applications you have on your desktop. One of these that provides a huge amount of power but gets used infrequently is Microsoft Access.

Many don’t appreciate that you can easily connect a SharePoint list to Microsoft Access on the desktop. Doing so allows you to use SharePoint as the data repository and Access as the analytical front end, allowing to create complex structures and queries as well as producing mind blowing reports and data analysis quickly and easily.

This tutorial will show you the basic steps of connecting SharePoint to your desktop version of Access. You see how that when you do it establishes an bi-directional link that means data is updated no matter where it is changed.

This is only the beginning of what is possible when you combine Access and SharePoint, however it is a very good place to start. Watch out for more content on this topic very soon.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s