Access 2002 Desktop Developer's Handbook (Paperback)

by Paul Litwin (Author), Ken Getz (Author), Mike Gunderloy (Author) "Chances are, if you're reading this book, you've already decided that Microsoft Access 2002 (we'll refer to it hereafter as Access 2002) is a worthy..." (more)
Key Phrases: direct table recordsets, using default collections, full test procedures, End Function, Public Sub, Select Case (more...)

Editorial Reviews

Product Description
--This updated version of the best-selling book focuses on the broad issues of database design and the single-user implementation of an Access database.

Learn how to create elegant user interfaces and develop fast, user-friendly applications for your stand-alone version of Access while reaping the benefits of new capabilities. --The CD contains a ton of usable code.

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

See all Editorial Reviews

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 (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars See all reviews (11 customer reviews)
• Amazon.com Sales Rank: #83,320 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

32 of 33 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

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

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)

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.