Product 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.
The vast majority of the code is visual basic From the back cover: "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."
But almost all of the code is in visual basic, a language that's not fun to write.
I'll update this review/rating after going through the book, but I'll never give it 5 stars for that completely misleading sentence on the back cover.
A legend in the making ... I don't know how much I can add to the information that has already been said, but ... here goes. Expert Access 2007 Programming has been written extremely well: very clear examples, great screen shots, and verbage that real people use! The topics discuss are what many developers crave .. API calls, Automation, Late vs Early binding, Working with the Registry, the list just goes on and on! ...
I make the claim that this book will be legendary simply because it covers so much and presents it so well. I am sure MANY will use its wealth of information well into the future and beyond Access 2007.
Brent Spaulding aka: datAdrenaline Access MVP
Complete Application Guide This is not the first book on Access to own unless you fairly comfortable with developing applications using another tool. Check out Wrox's Beginning Access 2007 title. But if your goal is to create an application to sell or use within your company this book provides all the info you need to get started and succeed. As a read it I recognized a lot of the tips that I had gathered over years of work and research. Would have been great if I could have just bought this book years ago. Section 4, "Finalizing the Application" covers great material; some knowledge of .Net would be beneficial if you are interested in DLLs (like resource libraries) or the build utility that comes with the book. Next to the Access Developer Handbook series I'd say this is the best book I've read on Access application development and deployment.
The got to have it book As I was reading through this book, it became clear to me that this is one book anyone who develops in Access should have.
The book is written true to Rob and Michael's form: The content is clear and the information useful. I enjoyed discovering new "toys" in the debugging chapter, and the error logging code is a gem that will be utilized in deployed applications. Going through the Add Advanced Functionality to Forms and Add Advanced Functionality to Reports chapters was like walking into a candy store that carries your long lost favorite childhood candy -- a joy. The ribbon chapter enhanced the knowledge I had prior to reading it. I was first introduced to Ribbon customization while listening to Rob [passionately] presenting the topic in an Access developers' group, and this chapter built on that presentation.
If you want to get a book that will expand your knowledge on Access programming, this is the book to buy. Access 2007 Programming is a well worth resource to own.
Friendly and Informative This book covers a ton of Access coding techniques in an easy to understand way. The authors use a friendly tone with good, clear code examples. I particularly liked the chapters on adding advanced functionality to reports and forms, and the pragmatic security discussion. I'm an Access MVP and have been developing in it for years, but I still learned some cool new techniques from this book.