- 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
Application Development by Templates
Access 2010 includes 12 built-in templates: seven for conventional Access databases (Events, Faculty, Marketing Projects, Northwind, Sales Pipeline, Students, and Tasks) and five for web databases (Assets, Charitable Contributions, Contacts, Issues, and Projects). In Backstage view, click New and Sample Templates to open the Available Templates gallery (see Figure 1.18).
Figure 1.18 The Available Templates gallery exposes buttons for Access 2010's 12 built-in templates. (Scroll down to display Sales Pipeline, Students and Tasks template buttons).
The Access 2007 team commissioned a complete makeover of the original 25 Access 2003 templates available from Office Online. These templates were popular; for example, the Access 2003 Contact Management template had close to 600,000 downloads before it was converted to Access 2007. This template has four related tables and manages detailed contact information and call history. A benefit of Access 2003 and earlier templates is that most have a few rows of sample data.
The new templates page at http://office.microsoft.com/en-us/templates/CT010214400.aspx has Access 2010, Access 2007, and Previous Versions categories.
To learn how to create an Access 2010 application from earlier versions of templates, see "Creating a Database from Any Access Template on Microsoft Office Online," p. 55.