My current project involves SharePoint 2010 and Access 2007. The project keeps track of our organization’s electronic publications and forms. I started by building lists in MS-Excel. Next I converted the data ranges to tables in Excel and imported them into SharePoint 2010 as lists. Then I exported these SharePoint lists into an Access 2007 database.
The tables in Access are linked to the SharePoint site, so a change made in Access instantly reflects in the SharePoint lists. A colleague had warned of the potential for compatibility problems between Office 2007 and SharePoint, but so far this arrangement has worked pretty much flawlessly.
I exported the list to Access for one reason: to allow me to print. Queries in Access arrange the data, which I then print as reports. The problem now is that I’m the only person who knows the Access database even exists. My boss periodically asks for printed reports, and I’m the only guy who knows how to give them what they want.
In my mind’s eye, the ideal solution would be to place a “Print” button in the SharePoint dashboard that any user can click to print out a usable report from Access. They don’t even need to know that Access is involved. (Whenever I bring up Access, people’s eyes start glazing over.)
Do I need to get acquainted with SharePoint Designer? Any tips or suggestions?