- What's New in Microsoft Office Access 2010: An Overview
- Changes to the Office 2007 Ribbon User Interface
- Security, Trusted Locations, Packages, and Certificates
- Access Web Databases and SharePoint Lists
- Application Development by Templates
- Access Macros Redux
- SQL Server 2008 [R2] Express Edition Setup
Access Web Databases and SharePoint Lists
Access 2010's changes to Access 2007 tables and database engine are relatively minor, unless you publish Access databases to SharePoint Server 2010 to enable browser-based intranet or Internet access with web databases. Web databases, which store tables as SharePoint Server 2010 lists and don't support VBA, serve as the replacement for Data Access Pages, which Access 2007 dropped. Chapter 23 is devoted to Web Databases.
The Access and SharePoint teams devoted substantial development and testing resources to improving the performance of tables linked to SharePoint lists by optimizing client-side and server-side caching. Chapter 22 explains how to link or move tables to SharePoint Foundation 2010, which is available to licensees of 64-bit Windows Server 2008 or 2008 R2 at no charge.
Access 2010 also supports linking tables to Data Services, which can be conventional SOAP Web services with Web Service Definition Language (WSDL) files or SharePoint Business Connectivity Services (BCS) entities with Application Definition XML files that contain External Content Type metadata. Linking to Data Services is beyond the scope of this book.