Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word

6.8. Summary

In this chapter, you saw how to use Access to work with SharePoint lists. You began by performing simple tasks to export SharePoint lists to Access and to publish Access tables to SharePoint. You learned that by linking lists from SharePoint to Access, you could edit data from either platform. Furthermore, within Access, you could build forms to edit the linked tables. You also looked at using multivalued fields, a new and controversial feature to Access, as it violates the first rule of data normalization—to keep all data fields atomic.

Until this point, you had performed all editing while remaining online with the SharePoint server. However, the advantage of using Access to manage your lists comes from its ability to work with ...