Key Points

• Integration with Windows SharePoint Services makes Access 2007 a great collaboration tool while enabling data to be stored on enterprise servers for better manageability.

• Access 2007 allows you to export and import data to and from SharePoint lists. Data in the Access 2007 table are not affected by subsequent changes made to the SharePoint list because there is no synchronization process between Access 2007 and a SharePoint site.

• When using Access 2007, you should create a new table that’s linked to a SharePoint list where data are maintained by users on the SharePoint Web site and you want Access 2007 to use the most current data. You can use Access 2007 to enter data into these SharePoint Lists, where two-way synchronization is provided, and you can maintain an offline cache when working offline.

• In Access 2007, you can move a database to a SharePoint site. Data are moved into SharePoint lists, and the Access 2007 database is stored in a document library. This functions well for data-centric applications that are shared between people and enables you to take advantage of SharePoint features such as workflow, security, and search.