Access 2003 VBA Programmer's Reference

by Patricia Cardoza, Armen Stein, Graham Seach, et al.

What is this book about? Its power and short learning curve have made Access Microsoft's leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA...

• Format: Paperback
• Language: English
• ISBN: 0764559036
• ISBN13: 9780764559037
• Release Date: April 2004
• Publisher: Wrox Press
• Length: 984 Pages
• Weight: 1.50 lbs.
• Dimensions: 2.1" x 7.3" x 9.3"

Customer Reviews

Brings it all together

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.

This is the book I use most.

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.

"A Must Have Reference"

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.

Excellent, hands-on reference

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 book has it all!

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!