Table of Contents

Credits.Title Page.Copyright Page.Dedication.Acknowledgements.Author Bios.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.Index.

About the Author

Patricia Cardoza is an Access Developer and an Outlook MVP; she previously authored Special Edition Using Microsoft Outllook 11 (Que). Teresa Hennig is a database consultant specializing in Access; she is President of the two leading Acess user groups in the US. Armen Stein is the founder of J Street Technology, a team of database developers in Redmond Washington, and is Emeritus President of the Pacific Northwest Access Developers Group. Graham Seach is an Access MVP; he is also Director and Chief Developer for Pacific Database, a firm specializing in Microsoft Access and SQL Server.