Long time ago, some one asked me whether we could export data from SharePoint to Access and my answer was "Yes, we can. Export data to spreadsheet using the Export to spreadsheet link and then manually import data from the Excel sheet into the Access database.". That was long time ago, I didn't know at that time that it was possible to export data to Access directly from with in SharePoint. Not only that, you can create reports easily from with in SharePoint. For example, you have a document library with a long list of documents, you want to create and present a report containing this list of documents to your manager. You can create a beautifully formatted report using Access. Here is how you do it:
1. In document library, click "Edit in Datasheet".
2. Click Task Pane to open it. It will show you office links.