Access 2002 Desktop Developer's Handbook^TM

by Paul Litwin; Ken Getz; Mike Gunderloy

• ISBN13: 9780782140095
• ISBN10: 0782140092
• Edition: CD
• Format: Paperback
• Copyright: 2001-10-01
• Publisher: Sybex

Summary

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

Author Biography

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.

Table of Contents

Introduction	xxxviii
What's New in Access 2002	1	(10)
The Access Event Model	11	(30)
Using VBA Class Modules	41	(44)
Database Design	85	(28)
Access SQL	113	(76)
ActiveX Data Objects	189	(108)
Controlling Controls	297	(134)
Topics in Form Design and Usage	431	(156)
Topics in Report Design	587	(88)
Controlling Your Printer	675	(24)
Shared Office Programmability	699	(96)
Using Access As an Automation Client	795	(66)
Access As an Automation Server	861	(36)
Error Handling and Debugging	897	(56)
Application Optimization	953	(60)
Accessing DLLs and the Windows API	1013	(40)
Harnessing Wizard Magic	1053	(90)
Building Add-Ins	1143	(74)
Appendix A: The Reddick VBA Naming Conventions, Version 7	1217	(22)
Appendix B: Data Access Objects	1239	(60)
Appendix C: Controlling Your Printer	1299	(64)
Index	1363