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.

As the most popular database system in the world, Microsoft Access is used by millions of people and supported by hundreds of thousands of Access developers. The 2007 version marks the largest release of Access in five years. Written by design engineers on the Access test team at Microsoft, this book introduces you to the many new features of Access 2007 and shows you innovative ways of looking at old problems such as automation, debugging, and deployment.

The authors break down the book into four parts—programming Access applications, data manipulation, interacting with the application, and finalizing the application—in order to walk you through the important steps of creating a full-featured application. They also provide you with in-depth examples that require only minor modifications and then can be easily implemented in the real world. You'll quickly learn how the 2007 version makes it simpler to write quality Access applications with XML, C#, and other .NET languages that are actually fun to write, feature rich, and easy to use.

What you will learn from this book

* The basics of working with managed code, particularly C# and VB.NET
* How to create different types of forms and customize navigation solutions for forms
* The advantages of developing databases for a global marketplace
* Various techniques that can simplify the development process and provide consistency across multiple applications
* How to use Report view to create compelling scenarios for users such as sorting and filtering
* Ways to find, view, categorize, and interact with data

Who this book is for

This book is for experienced Access application developers who use VBA and SQL. Familiarity with Access 2007 is helpful but not required.

Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.