kalmstrom.com CEO Peter Kalmstrom is an expert on both SharePoint and Access. In this demo he shows how to link data from a list in SharePoint 2010
to a table in Access 2010 and how to work with the live data in Access. This way
it is possible to use Access functionality that is not available in SharePoint. What you do with the SharePoint data in Access is automatically reflected back to the SharePoint site.
Peter explains how to get the SharePoint list items into the Access table, and after that he gives some examples on what you can do easily in Access that is hard or impossible to manage in the SharePoint site.
Search and Replace live SharePoint list items by using Access
Create Access Queries for use on live SharePoint list items
Create Access Forms and use them with live SharePoint list items
Create and Print Access Reports from live SharePoint list items
Use Visual Basic in Access on live SharePoint list items
In the demo Peter shows how to link to Access via the SharePoint list
datasheet view, but you may also go the opposite way, from Access to SharePoint. In that case, open Access and create a table. Then link the table to SharePoint via the Access External Data tab: