MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)

You can obtain additional tools and a license to freely distribute runtime versions of your applications by downloading the Access 2007 Developer Extensions and Runtime from this location: http://msdn2.microsoft.com/en-us/office/bb229700.aspx. In previous versions, you had to purchase the developer tools and runtime extensions separately. The big news is that, for Access 2007, Microsoft is offering these tools at no additional charge. This set of software includes the following:

• A royalty-free license to distribute the runtime modules for Access 2007. This allows you to provide your application to users who do not have Access.

• A Package Solution wizard that helps you create installation files that include your database application, the runtime modules necessary to run your application, and any supporting files (such as ActiveX controls or icons). The wizard creates a standard Microsoft Windows Installer setup file (.msi).

• A source code database to help you discover how the wizards included with this package work.

• A Save As template that you can use to create the database templates to appear on the Getting Started screen. The template files have .accdt extensions.

• White papers on conditional formatting, normalization, and managing SQL Server security.

This concludes the printed portion of Microsoft Office Access 2007 Inside Out. If you’re interested in building project files that link directly to tables and queries stored in Microsoft SQL Server, be sure to read the chapters in Part 7 that you can find on the companion CD. The companion CD also includes a host of reference articles that you’ll find essential for increasing your knowledge about building applications using Access.