Access 2010 Programmer's Reference (Wrox Programmer to Programmer)

A comprehensive guide to programming for Access 2010 and 2007

Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.

With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.

Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Coverage Includes:

Introduction to Microsoft Access 2010
New Features
Upgrading and Converting to Access 2010
Macros in Access 2010
Using the VBA Editor
VBA Basics
Using VBA in Access
Creating Classes in VBA
Extending VBA with APIs
Working with the Windows Registry
Using DAO to Access Data
Using ADO to Access Data
Using SQL with VBA
Using VBA to Enhance Forms
Enhancing Reports with VBA
Customizing the Ribbon
Customizing the Office Backstage
Working with Office 2010
Working with SharePoint
Working with .NET
Building Client-Server Applications with Access
The Access 2010 Templates
Access Runtime Deployment
Database Security
Access 2010 Security Features

Customer Reviews:

Index is not adequate for a reference book

By quietstorm - September 26, 2011

It's not a bad book. I read the entire book even though I was disappointed early on (see my gripe about the index later in the review). To be brutally honest there are some classics out there that are better, and I am using some of them. But they are getting dated and I wanted to learn some new things and particularly get a good feel for the new version of Access 2010.

The style of sample code and follow-along examples is different from book to book. I prefer verbose and well-illustrated examples. The examples in this book are not quite to my liking, but some of you may find you prefer it. I won't try to explain further because if you've read a number of books you already know how examples and sample code are handled quite differently. I should mention the style of examples in this book varys a bit from chapter to chapter.

This book is the product of several/many authors and contributors; different authors wrote different chapters. Some of the chapters deliver... read more

Another winner for Hennig, et al

By Laurin M. Linson "Larry Linson" - September 14, 2010

Access 2010 Programmer's Reference is a well-written, well-thought-out, and very helpful book. It's another winner for the team of authors who wrote it.

Not only are the technical details of Access programming in-depth, complete and accurate, and exceptionally well-explained, the features and functions of Access that they are used to implement or supplement are thoroughly explained, too -- just so your memory will be refreshed on those with which you are already familiar and you can learn the ones that are new to this release of the Access product.

I have used Access since its Version 1.0, lead an Access user group, and have been honored by being recognized as a Microsoft Most Valuable Professional for the product. But I wouldn't willingly start an Access 2010 project that I knew would involve code without having this book close at hand. I'm happy to let these extremely knowledgeable authors "do some heavy lifting" for me in identifying new functions and... read more

Great book for beginners and seasoned developers

By Luiz C. C. Rocha "Luiz Cl?udio" - May 21, 2011

This is a very well written book.

At the same time, it's comprehensive and straight to the point: it covers almost all the possible topics about Access development, and on each topic it shows what is important to know, it does not waste reader's time. It explains why features are built this or that way, instead of only listing what the features are. In other words, it's a BOOK, not a MANUAL.

Whether you are a beginner or a seasoned Access developer (new to Access 2010), you will find this book to be very valuable.