Product Description: This resource provides the tools you need to leverage Access 2007’s built-in functionality and VBA in order to build more dynamic applications. The author team explores all aspects of VBA programming for Access, describes the latest innovations, and explains how to take advantage of key new objects, enhanced macros, and the Office Ribbon. Plus, you’ll find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
This book Rocks! I have definitely come to respect the Wrox writers. Whenever I am in need of additional assistance, I look to these books first. The Access 2007 VBA Programmers Guide has everything I need in it and is written in an easy to follow manner. My skill level is just above beginner, but there are sections of the book for more advanced programming that I have not looked at. I highly recommend all books by Wrox (I have used their SharePoint books extensively).
Excellent! This books was a TREMENDOUS help in writing a Human Resources application for my company. I'm no programmer--but this book helped me a great deal with some of the VB that was needed for the database. I did also rely on the internet a lot but this was a handy tool that covered a majority of the basics--the internet was for more advanced scripting. I highly recommend the book for those who work with Access often...and even for those who want to take advantage of the cool things code will enable you to do.
Great Resource for ANYONE working with Access Access 2007 VBA is a great book for experienced and novice programmers alike. It is thoroughly detailed and yet covers the VBA basics at the beginning. What I like about this book is that it covers details that other books seem to always miss. This would include Microsoft Office integration. Or, in other words, the code that lets you work with other Office applications like manipulating Excel from Access or Word from Access. It also goes into working with Outlook and even SharePoint, which are two of the hardest to find information on when working with Access VBA. I am finding this book to be a great addition to my library and I believe you will too.
Bob Larson Access World Forums Super Moderator Utter Access VIP
Access 2007 VBA Concisely Explained This book delivers exactly what it promises - namely, to provide the reader with the necessary tools to use VBA against the various Access 2007 object models to amplify the capabilities of a custom Access 2007 solution. You will be shown the differences between using the DAO and ADO data access technologies, as well as the costs and benefits of using the older mdb file types versus the new accdb and project-related adp file types. A cogent explanation of the additional security features embedded in Access 2007 is also nicely covered.
The authors present a broad coverage of the subject matter which is amplified by their substantial real world experience - a nice benefit considering the myriad of texts that simply offer a better organized rehash of the help files.
A final comment will address the number of helpful sidebars presented in the text dealing with such issues as: using the "SQL Server Profiler", how to programmatically add, delete, and modify registry entries to persist user related variables; and receiving insider's expert information on undocumented legacy functionality.
An excellent text for what it sets out to accomplish.
Extremely Good Text I've been using Access off and on since Windows 95 and Access 2. This is absolutely one of the best texts on VBA I have read. Examples are clear, and appropriate; and explainations are complete without being longer than the need to be. The coverage of Access 2007's new features appears to be right on the money.
Anything Goes Trivia
Trevor
Megaton Man
