Access 2002 Desktop Developer's Handbook
1st Edition
Published on 5. October 2001
Book
Paperback/Softback
1440 pages
978-0-7821-4009-5 (ISBN)
Description
DESIGN, BUILD, AND REFINE ACCESS APPLICATIONS THAT MEET YOUR ORGANIZATION'S SPECIAL NEEDS
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
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
More details
Persons
Paul Litwin is the owner of Litwin Consulting and a founding partner of Deep Training, where he focuses on training, mentoring, and writing about Access, ASP.NET, and Visual Studio.NET. He is the editor-in-chief of aspnetPRO, a magazine for ASP.NET developers.
Ken Getz is a senior consultant with MCW Technologies, where he focuses on development, training, and writing about Microsoft technologies, including Visual Studio.NET and Microsoft Office. He speaks regularly at industry conferences.
Mike Gunderloy, an independent consultant and developer in eastern Washington, is coauthor of Mastering SQL Server 2000 and SQL Server Developer's Guide to OLAP with Analysis Services, and author of Visual Basic Developer's Guide to ADO, all from Sybex. Paul, Ken, and Mike together wrote this book's companion volume, Access 2002 Desktop Developer's Handbook.
Ken Getz is a senior consultant with MCW Technologies, where he focuses on development, training, and writing about Microsoft technologies, including Visual Studio.NET and Microsoft Office. He speaks regularly at industry conferences.
Mike Gunderloy, an independent consultant and developer in eastern Washington, is coauthor of Mastering SQL Server 2000 and SQL Server Developer's Guide to OLAP with Analysis Services, and author of Visual Basic Developer's Guide to ADO, all from Sybex. Paul, Ken, and Mike together wrote this book's companion volume, Access 2002 Desktop Developer's Handbook.
Content
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.
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.