Access 2002 VBA Handbook

The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step-by-step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes

• Running queries to find specific records
• Automating complex and time-consuming procedures
• Importing data from existing data sources
• Synchronizing forms and tables
• Understanding the ADO and DAO models
• Understanding the essentials of Visual Basic for Applications (VBA)
• Customizing the Access user interface
• Creating procedures to change Access's default error-handling processes
• Accessing data using OLE DB and ODBC
• Creating VBA procedures for navigating a database or project
• Writing VBA procedures using object properties and methods
• Creating relationships between forms
• Executing commands using SQL statements in VBA code
• Using ActiveX controls in your VBA procedures

• Introduction
• Chapter 1: Automating a Database without Programming
• Chapter 2: Getting Started with Objects and Events
• Chapter 3: Introducing the Access Object Model
• Chapter 4: Communicating with Forms
• Chapter 5: VBA Programming Essentials
• Chapter 6: Understanding the ADO Object Model
• Chapter 7: Writing Procedures
• Chapter 8: Using Variables
• Chapter 9: Controlling Execution
• Chapter 10: Dealing with Errors in VBA
• Chapter 11: Navigating with Access VBA
• Chapter 12: Maintaining Data with Access VBA
• Chapter 13: Working with Groups of Records Using Access VBA
• Chapter 14: Creating and Modifying Database Objects
• Chapter 15: Expanding Access
• Appendix A: Glossary
• Appendix B: Data Access Object (DAO) Model
• Index