Access 2002 Desktop Developer's Handbook [Paperback]

Paul Litwin (Author), Ken Getz (Author), Mike Gunderloy (Author)

Book Description

ISBN-10: 0782140092 | ISBN-13: 978-0782140095 | Publication Date: September 10, 2001

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

Editorial Reviews

From the Back Cover

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

About the Author

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.

Product Details

• Paperback: 1488 pages
• Publisher: Sybex (September 10, 2001)
• Language: English
• ISBN-10: 0782140092
• ISBN-13: 978-0782140095
• Product Dimensions: 9 x 7.5 x 2.5 inches
• Shipping Weight: 5.4 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #193,802 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

33 of 35 people found the following review helpful:

5.0 out of 5 stars This book can take your application to the next level, June 16, 2003

By A Customer

This review is from: Access 2002 Desktop Developer's Handbook (Paperback)

It should be known that this book is not for new Access users. However, it can make a beginner into a professional developer.

If you are at the point where you would like to start manipulating the controls without using Access' built-in functions and wizards, this book will serve you well.

Prior to using this book, I have only had a little experience with VB/VBA. After having used this book for a couple of months, I have gone from being fully dependant on Access' built-in queries/controls. Now, I do almost everything in the code-window. My code is no longer "spaghetti".

I like this book because it is not organized like an encyclopedia where the controls are given an over-simplified explaination in alphebetical order, nothing is left out- it's not a beginner's manual; however, little time is spent reviewing the basics. It is clearly written, everything is well spelled out for any learning ability. This is way better than all of the "Complete" editions.

You might consider yourself an advanced user until you see this book. It is humbling, you will realize how much more there is to learn. When you have read it over, you will be surprised how powerful of a tool Access can be.

33 of 37 people found the following review helpful:

5.0 out of 5 stars Real developer education, September 26, 2001

By 

Rick Burtaine (Allentown, PA United States) - See all my reviews

This review is from: Access 2002 Desktop Developer's Handbook (Paperback)

Of all of the systems and programming books that I have in my office on two full sized bookcases, the best of the best continues to be this series of books. I came to Access with version 2.0 and had the good luck to select the Access 2 Developer's Handbook. It was then, and it is now the best information to be had for this product and it sits beside the other books of this series. The writing style is concise and lucid in the way that only true masters of a subject are capable of. As further credit, all of the books remain relevant regardless of the Access version running on the computer. For me, a release of Access isn't official until Paul and Ken put a book on the shelves.

11 of 12 people found the following review helpful:

5.0 out of 5 stars Essential Reference, September 2, 2004

By 

Tee H. Hiett (Birmingham, AL USA) - See all my reviews
(REAL NAME)   

This review is from: Access 2002 Desktop Developer's Handbook (Paperback)

Don't let the "2002" in the title mislead you. This book is a valuable reference for Access 2003. If you are serious about the VBA programming, especially in Microsoft's Access, this book is essential. I have worked with the authors' and Access 97 and their Access 2000 versions and would have gone to their Access 2003 to version if it had been published. I agree with the publisher's choice to stick with the 2002 version because of the relative few changes to Access. Just last week, I referred to the textbook to see how to identify a control on a subform.

A second book I would recommend for VBA programmers is "Excel 2003: Power Programming with VBA" by John Walkenbach. Although this book focuses on VBA with Excel, the models and the presentation help develop a much richer understanding of VBA.