Access 2002 Desktop Developer's Handbook

The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Desktop Developer's Handbook offers complete coverage of every aspect of building Access applications for single users and small workgroups. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges.

Coverage includes

• Understanding the Access event model
• Using VBA class modules
• Applying sound database design principles
• Using Access SQL
• Controlling controls
• Using ActiveX Data Objects (ADO)
• Designing effective forms and reports
• Taking advantage of shared Office programmability
• Controlling your printer
• Using Access as an automation client and server
• Debugging and handling errors
• Optimizing your application
• Accessing DLLs and the Windows API
• Adding professional features offered by Access Wizards
• Building COM add-ins and MDA files
• Using Reddick VBA naming conventions

Contents

• Introduction
• Chapter 1: What's New in Access 2002
• Chapter 2: The Access Event Model
• Chapter 3: Using VBA Class Modules
• Chapter 4: Database Design
• Chapter 5: Access SQL
• Chapter 6: ActiveX Data Objects
• Chapter 7: Controlling Controls
• Chapter 8: Topics in Form Design and Usage
• Chapter 9: Topics in Report Design
• Chapter 10: Controlling Your Printer
• Chapter 11: Shared Office Programmability
• Chapter 12: Using Access As an Automation Client
• Chapter 13: Access As an Automation Server
• Chapter 14: Error Handling and Debugging
• Chapter 15: Application Optimization
• Chapter 16: Accessing DLLs and the Windows API
• Chapter 17: Harnessing Wizard Magic
• Chapter 18: Building Add-Ins
• Appendix A: The Reddick VBA Naming Conventions, Version 7
• Appendix B: Data Access Objects
• Appendix C: Controlling Your Printer
• Index