Access 2000 Developer's Handbook - Volume 1

The latest from internationally recognized Access authorities Getz, Litwin, and Gilbert, the Access 2000 Developer's Handbook, Volume 1: Desktop Edition offers complete coverage of every aspect of building Access applications for single users and small workgroups, including the advanced topics you've got to master to take your work--and your career--to the next level. Inside, you'll profit from scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges.

Coverage includes:

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

• About the Authors
• Introduction
• Chapter 1: What's New in Access 2000
• 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 6
• Appendix B: Startup and Global Options
• Appendix C: Data Access Objects
• Index