Templates: SharePoint comes into Play

When you go create your new database from a template using Access 2007, you will notice a checkbox right by the OK button and path where you will create the file. By checking the “Create and Link your Database to a Windows SharePoint Services Site”, instead of just creating a local database, lists will be created in the SharePoint site and the database will link to them. The Access database will then serve as a rich front-end client running with SharePoint as its back-end.

To put it in simple words, with the new templates, the data backend can be either Access or SharePoint.

It’s worth mentioning that the templates made available for Access 2007 are made in such a way that they translate their functionality perfectly (such as the Append Only feature we talked about some time ago) between Access and SharePoint.