Part V: Access and Windows SharePoint Services
1134
Figure 33.18 shows the Access view of the new SharePoint list. This linked table behaves like any
other linked SharePoint list and allows the user to add, edit, or delete records as needed. The user,
of course, needs proper SharePoint permissions to work with the data because it is hosted in
SharePoint and not Access.
FIGURE 33.18
The Access view of the new SharePoint list
In the future, other application templates for Access may become available. Potential tracking
application templates include customer service, projects and project management, marketing, sales
channels and pipelines, student management, school and college student management, and others.
Summary
This chapter took a quick look at the potential benefits of combining data stored in SharePoint
with Access forms and reports. Access enables you to seamlessly integrate with SharePoint Services,
across the Internet or more locally on an intranet. The SharePoint data is available to any
SharePoint user with the appropriate credentials (user name and password), and data security is
provided by SharePoint Services.
Microsoft is aggressively and rapidly improving the performance in capability of SharePoint
Services. The ability to share Access data with remote users through SharePoint will only increase
over time. The next two chapters explain in detail Microsoft’s plans to extend Access applications
into the SharePoint environment, greatly enhancing SharePoint as a extensible platform for Access
developers.