Expert Access 2007 Programming (Paperback)

Description

Expert Access 2007 Programming shows experienced developers how to create professional-level Access database applications. The authors--software engineers on the Access development team at Microsoft--show how to apply software engineering methodologies to Access application development. The book is organized to cover all phases of Access development.

The authors demonstrate techniques for creating Access controls, forms, and reports that help streamline development and produce more user-friendly applications. They also cover such overlooked areas as custom deployment and documentation. The book contains many useful code examples designed so they can be used with minimal modification.

Introduction.

Overview of Programming for Access.

Extending Applications Using the Windows API.

Programming Class Modules.

Debugging Error Handling and Coding Practices.

Parsing Data.

Structured Query Language (SQL).

Managing Data.

Using Code to Add Advanced Functionality to Forms.

Using Code to Add Advanced Functionality to Reports.

Using Automation to Add Functionality.

Creating Dynamic Ribbon Customizations.

Configuration and Extensibility.

Personalization and Security.

Deployment.

Help and Documentation.

Programming Tips and Tricks.

Query Performance.

Patterns Reference.

Index.