Access 2000 Developer's Handbook Volume 1: Desktop Edition [ILLUSTRATED] (Paperback)

~ Paul Litwin (Author), Ken Getz (Author), Mike Gilbert (Author) "Chances are, if you're reading this book, you've already decided that Microsoft Access 2000 (we'll refer to it hereafter as Access 2000) is a worthy..." (more)
Key Phrases: End Function, Select Case, Public Sub (more...)

Editorial Reviews

Product Description

Volume 1: Desktop Edition of this best-selling book focuses on getting desktop applications up and running. Of course, all the topics discussed in this volume apply to enterprise applications as well, but Volume I is aimed at issues that every Access developer will face. This newly rewritten volume includes coverage of database design, Jet 4.0 and SQL, query design, form and report design (including some tricks and documentation you won't find elsewhere), using Automation, error handling and debugging, optimization (including new tips for Jet 4.0), deep coverage of Windows API and many classes that wrap up important and useful API functionality, and building add-ins, including coverage of the new COM Add-in architecture. If you're an Access developer, or you'd like to be one, this is the book for you.

From the Back Cover

Design, build, and refine Access applications that meet smaller organizations' special needs.

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

See all Editorial Reviews

Product Details

• Paperback: 1664 pages
• Publisher: Sybex; 1 edition (September 2, 1999)
• Language: English
• ISBN-10: 0782123708
• ISBN-13: 978-0782123708
• Product Dimensions: 9.1 x 7.5 x 2.7 inches
• Shipping Weight: 6 pounds
• Average Customer Review: 4.7 out of 5 stars  See all reviews (27 customer reviews)
• Amazon.com Sales Rank: #177,565 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #7 in

  Books > Computers & Internet > Microsoft > Applications > Office 2000

Customer Reviews

Most Helpful Customer Reviews

141 of 142 people found the following review helpful:

5.0 out of 5 stars Definitive Resource for Microsoft Access And VBA Developers, November 6, 1999

By A Customer

The Access 2000 Developers Handbook is an essential resource for developing quality applications in Microsoft Access. It is the fourth book in the series, with equivalents written for each version of Access starting with Version 2.0, and all of them sit right next to each other on my bookshelf. The code included with the book's companion CD is worth the cover price alone! Although the book specifically targets Microsoft Access, it easily ports to Visual Basic and Active Server Pages applications.

The book contains thousands of lines of highly portable, usable and bug free code. The code included is more than just sample code; it is highly optimized, fully functional and rapidly incorporated into your project. Some outstanding examples include popup calendar and calculator controls, a Text File class which makes it simple to read, write and manipulate text files, form scaling code, Common File Dialog and Office File Open/Close Dialog wrappers, excellent automation samples including manipulating Outlook to generate time reports, and Word to print an invoice. Many of the code samples literally paste straight into the Visual Basic development environment with no modification, and have worked bug free in my applications for quite some time. Additionally, where appropriate, all code included with the Access 2000 Developers Handbook has been incorporated into class modules, which further makes it simple to incorporate into your projects.

The book also has some of the best information about relational database design, SQL syntax and, much more. Microsoft Access encompasses many new technologies, and this book does the best job of providing a navigational guide through them to enable its readers to become high quality, proficient developers. Access Developers can find work developing applications without reading this book, but it isn't a good idea!

If you buy only one book for Access 2000, the Access 2000 Developers Handbook should be the one.

61 of 61 people found the following review helpful:

5.0 out of 5 stars Simply Outstanding, January 6, 2000

By	Jeremy Farrance (Illinois, USA) - See all my reviews (REAL NAME)

As the word 'Developer' should imply, this book is not for MS Access beginners, but once you qualify yourself as 'intermediate' or better, you will feel right at home. Very little of this book is devoted to boring you with rehashes of stuff in the help file (as most other books seem to do). There is a great deal of depth and insight into areas that apply to everyday usage, complex projects, and solutions to many problems MS tends to ignore version after version.

The writing is excellent and they have a web site devoted to updates, errata and such which is very helpful. Chapters 10, 14 and 15 have had an extremely positive impact on the quality and usability of my projects in MS Access as well as VBA and Visual Basic.

Many of the code samples are outstanding and written so that you can just drop them in to your projects with no modifications. Many of them are done so well they seem like natural extensions to MS Access (stuff MS 'should' have included in the 1st place).

Complaints? None. Well, okay, I do have 1 minor complaint. They devoted almost 30 pages to The Office Assistant. IMHO these pages and the Office Assistant itself are a complete waste.

This book and its previous versions are the best money I have ever spent. They continue to save me hundreds of hours while adding reliability and capability to all my projects. Highly recommended!

55 of 55 people found the following review helpful:

5.0 out of 5 stars An Essential Reference, November 5, 1999

By A Customer

I purchased the Access 97 Developer's Handbook and was very impressed with the content. With it my skills in VB and in Access were greatly boosted. When I purchased Office 2000 I went ahead and purchased Access 2000 Developer's Handbook, not really expecting alot of new content - just updated content, which I felt I needed.

This book covers all of the Ins/Outs of Access programming. While it might be a bit much for an absolute beginner who has no prior programming skills, it is a good book for anyone who intends to do a significant amont of work in Access. This book has basic information as well as some rather advanced concepts and techniques. All topics are presented clearly and with good examples.

There is even a touch of humor interspersed throughout the text. Be sure to look for the discussion of the evolution of COM.

In comparison to the earlier version of book, the same general topics are covered but many of the solutions are even better than they were in the Access 97 Handbook. There are many examples of class modules and collections. The examples themselves are useful (I love the TaggedValues class - I only wish I had thought of it myself)and they provide a good jump off point for someone who wants to build his own class modules.

I would definately recommend this book to anyone using Access 2000, whether or not you already have the earlier version.