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.