Access 2003 VBA Programmer's Reference

I started working with VB back at the turn of the Century (yes, that was 8 years ago), same with ADO and databases in General. A little of this here, a little of that there It wasnt till the last year that I had to do VBA and Access, and this book brought it all together. Its not for a beginner. They dont discuss writting queries, or designing data bases nor branching and decision making. It DOES talk about Macros, Objects, Security, API and how to use the tools in Access to make full featured Access application and integrete it with other MS Office products. It gives subtle nauances that you just cant find no matter how often you push F1 I was getting this stuff on my own of course, but trying to figure out something from the Help documentation and NorthWind just wasnt doing it. Our clients give my consulting company a lot of money to get things done This book was just what I needed consoldate my skill set and meet our clients needs.

I count 6 MS Access books on my shelf at work. If I could only have one, it would be this one. I find information that I haven't found in any of the others. It's also the best reference on Access SQL. I'm in the process of developing from a casual access user to professional level, and have lots of questions.

As an Access Developer this is one of my most used Access VBA reference books. All of the authors present the material in a good comprehensive manner for all levels of Access development. There are many clearly presented code examples and Access information that will assist in all levels of development. There are many good chapters in the book; however don't overlook the Appendices as they are exceptional.(Note: Appendix I "Tips and Tricks") I know most Access Developers are selective in the books they buy. If you scan this book you will see how much above other VBA reference books this particular book is.

I have to agree with reviewer Paul E. that the authors did an outstanding job on this book.The book is comprehensive, covering just about everything you need to know when you're working with Access application development. For me, the 250 pages or so of appendixes have been the most useful, but there's also a sixty-page chapter on database security in the middle of the book that should be required reading for all Access developers.Here's the table of contents from my copy of the book:Introduction. 1. Intro to Access. 2. Access, VBA, and Macros. 3. New Features in 2003 (and 2002). 4. VBA Basics. 5. Using the VBA Editor. 6. Using DAO to Access Data. 7. Using ADO to Access Data. 8. Executing VBA. 9. VBA Error Handling. 10. Using VBA to Enhance Forms. 11. Enhancing Reports with VBA. 12. Creating Classes. 13. APIs. 14. SQL & VBA. 15. Working with Office Applications. 16. Security. 17. Understanding Client-Server Development with VBA. 18. Windows Registry. 19. Using the ADE Tools. 20. Macro Security. Appendix A: Upgrading to Access 2003. Appendix B: References for Projects. Appendix C: DAO Object Method and Property Descriptions. Appendix D: ADO Object Model Reference. Appendix E: Access Object Model. Appendix F: Windows API Reference Information . Appendix G: Naming Conventions. Appendix H: VBA Reserved Words. Appendix I: Tips and Tricks. Appendix J: ADO Object Argument Information. Appendix K: Access Wizards, Builders and Managers. Appendix L: Windows Registry Information.

This is a very special book. The authors obviously went way out of their way to include everything that you could need to be a successful Access developer. As far as I know, this extensive reference material has never before been assembled in one place. As a result, it is just the right thing for aspiring intermediate and advanced users of Microsoft Access. Even many developers with extensive experience will be surprised at what can finally become clear to them by checking out what this reference makes available. You'd have to search the Microsoft and other sites for weeks to assemble all this on your own.This well-written reference covers everything from VBA basics to using the new Access Developer Extensions, which are part of Visual Studio Tools for the Microsoft Office System. In between it also covers error handling, enhancing forms, enhancing reports, SQL coding, and even working with the Windows Registry. The appendices go all the way from A to L, or from Upgrading of Access (what other book covers this subject at all, never mind so thoroughly?) to VBA Reserved Words.I have never seen such comprehensive reference material! And is it loaded with tips, tips, tips! The authors have obviously lived in the trenches with Access for some time. They know what to watch out for. They know what kind of protocols you should set up yourself to boost your success.It took the experience of four co-authors and several other contributors to bring this work together. Patricia, Teresa, Graham and Armen have provided a unique Access reference that will get you up and going fast and save you scads of time that you would otherwise have wasted learning "the hard way" or, at best, wasted digging through a multitude of written and online references. This is a special, one-of-a kind reference work!