Have one to sell? Sell yours here
Access 2000 Developer's Handbook Volume 1: Desktop Edition
 
 
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Paul Litwin (Author), Ken Getz (Author), Mike Gilbert (Author)
4.7 out of 5 stars  See all reviews (28 customer reviews)


Available from these sellers.


Textbook Student FREE Two-Day Shipping for Students. Learn more


Book Description

0782123708 978-0782123708 September 2, 1999 Volume 1: Desktop Edition
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


Editorial Reviews

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

About the Author

Paul Litwin, Ken Getz, and Mike Gilbert are co-authors of Access 2, Access 95 and Access 97 Developer's Handbooks from Sybex. Gilbert and Getz co-authored VBA Developer's Handbook also from Sybex. Litwin and Getz are co- and sole authors on related other books from other publishers. All three are MVPs on Microsoft's Access CompuServe Forum, and frequent contributors to Access, VBA, and Office Advisor Magazines.

Product Details

  • Paperback: 1664 pages
  • Publisher: Sybex; Volume 1: Desktop Edition 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 (28 customer reviews)
  • Amazon Best Sellers Rank: #741,883 in Books (See Top 100 in Books)

 

Customer Reviews

28 Reviews
5 star:
 (25)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
4.7 out of 5 stars (28 customer reviews)
 
 
 
 
Share your thoughts with other customers:
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
This review is from: Access 2000 Developer's Handbook Volume 1: Desktop Edition (Paperback)
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.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


61 of 61 people found the following review helpful:
5.0 out of 5 stars Simply Outstanding, January 6, 2000
By 
This review is from: Access 2000 Developer's Handbook Volume 1: Desktop Edition (Paperback)
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!

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


55 of 55 people found the following review helpful:
5.0 out of 5 stars An Essential Reference, November 5, 1999
By A Customer
This review is from: Access 2000 Developer's Handbook Volume 1: Desktop Edition (Paperback)
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.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews











Only search this product's reviews



Inside This Book (learn more)
First Sentence:
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 platform for your development endeavors. Read the first page
Key Phrases - Capitalized Phrases (CAPs): (learn more)
End Function, Select Case, Public Sub, Visual Basic, Case Else, Property Get, Property Let, Private Function, End Property, Exit Sub, Cancel As Integer, Nothing Set, Add-in Manager, Developer's Handbook, Form Wizard, Exit Function, Number Case, End If Next, Control Wizards, Microsoft Excel, Close Set, Microsoft Forms, End Select Resume, Private Const, Declare Function
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:




What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)

Your tags: Add your first tag
 

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums


Listmania!


So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject