Access 2007 VBA Programmer's Reference covers a wide spectrum of programming topics relevant to Access. Although it assumes the reader has some familiarity with VBA programming language, it begins with a brief introduction to VBA. And to help you leverage the tools that Access provides, a chapter highlights the new features in Microsoft Office Access 2007 -- including new wizards and GUI (graphical user interface) elements that previously required VBA code, as well as new VBA features. The book also discusses how to create and name variables, how to use Data Access Object (DAO) and ActiveX Data Object (ADO) to manipulate data both within Access and within other applications, proper error handling techniques, and advanced functions such as creating classes and using APIs. Key new objects such as using Macros and the Ribbon are explored, too, as are forms and reports, the two most powerful tools for working with and displaying data. Working with other applications is covered extensively both in a general nature and for working specifically with Microsoft Office applications, Windows SharePoint Services, and SQL Server. Of course, this book wouldn't be complete without discussing security issues and the Developer Extensions.
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 Transition
Published by Thriftbooks.com User , 17 years ago
I starting developing with Access 97 and have used each version since. I specialize in accounting applications and there have licensed several Access accounting applications for modification. This book addressed (easy to understand format) the areas that affect developers most (the U.I., code, classes). It is definitely for the experienced. It is a welcome addition to my library.
Fantastic! BEST book on Access
Published by Thriftbooks.com User , 17 years ago
Without a doubt, the Access 2007 VBA Programmers Reference by Teresa Hennig, Rob Cooper, Geoff Griffith, and Armen Stein is the BEST technical book I have had the pleasure to read. Teresa's energy and enthusiasm shows on every page. Rob, Geoff, and Armen add greatness to the team. I absolutely love the path that the book takes! Unlike the title suggests, this book covers far more than VBA. I got much more than I was expecting; thought it would be focused on code -- but No! For someone who is transitioning to 2007 from previous versions, there is extensive knowledge on what to expect in the new version -- not just lists, but thorough and easy-to-understand explanations. For someone starting with Access 2007, everything is interesting and very well-explained! ... whether you used previous versions or not. It is a hard book to put down (even though it is so big)! I would recommend this book to anyone who is developing with Access (no matter what version), anyone who WANTS to be a programmer, and finally, anyone who just uses Access (you will be assimilated ). The book is so much more than code ... and for those looking for a great code reference, you found it! Warm Regards, Crystal * (: have an awesome day :) *
Great Desk Reference and Self paced study system.
Published by Thriftbooks.com User , 17 years ago
My copy of the Access 2003 VBA was well worn by the time Access 2007 VBA Programmer's Reference became available. This new book is well written and organized and it is a great successor to the previous version. The team did an excellent job explaining and illustrating the new features in Access 2007, as well as the features that existed in previous versions of Access. There are many new features in Access 2007 and this reference helps the developer get the best performance from Access 2007. I would recommend this book for all skill levels.
Excellent Self-Study for Access 2007 VBA
Published by Thriftbooks.com User , 17 years ago
This book has extensive coverage of an area vital to Access developers and power users, by a very knowledgeable team, ably led by Teresa Hennig. It includes something more than an overview explaining new features of Access 2007. That is important because: many features are new and changed in Access 2007, much of what we do with VBA is automating and enhancing features we use manually via the user interface, and the new Office 2007 user interface can be overwhelming without a helping "hand up". Then the book covers VBA from the basics to in-depth advanced levels. It is a worthy successor to the Access 2003 VBA Programmer's Reference and, in my opinion, "raises the bar" for VBA books. I'll be using it as a reference in presentations to my Access user groups, as well as a handy reference for my own work. I recommend it to Access power users, as well as aspiring and working Access developers. Larry Linson Microsoft Office Access MVP (see http://mvp.support.microsoft.com) Co-Leader, Access Special Interest Group, North Texas PC User Group
ThriftBooks sells millions of used books at the lowest everyday prices. We personally assess every book's quality and offer rare, out-of-print treasures. We deliver the joy of reading in recyclable packaging with free standard shipping on US orders over $15. ThriftBooks.com. Read more. Spend less.