Access and SharePoint - Another Qiuck Hit from SPC09

Access has been Microsoft's "end user" database product for well over a decade. It allows users to easily create sets of tables, forms, and reports.

With the 2010 release, Microsoft is introducing Access Web Services. Essentially, this allows you to take an Access database and convert it (not merely upload it) into SharePoint site, with virtually all of the functionality intact. Tables are converted to SharePoint lists. Macros are converted to JavaScript and SharePoint workflows. Even your forms and reports display virtually identically.

What's more, this isn't a one-way ticket - it is a round-trip. You can re-open the site in Access to tweak it, or have full "access" to the functionality that doesn't convert (either by product limit or your choice).
Integration now also exists for Word, Excel, PowerPoint, OneNote, and Visio.


From Woody Windischman Notes on the conference