Access 2000 Developer's Handbook 2 Volume Set [Paperback]

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

Book Description

ISBN-10: 0782123716 | ISBN-13: 978-0782123715 | Publication Date: December 15, 1999

Expert Instruction. Advanced Coverage. An Unbeatable Price.

This two-volume set gives you the opportunity to buy the two most advanced guides to Access development at a significantly reduced price. Inside, you'll find unparalleled instruction from three internationally recognized Access experts, organized to reflect the very different requirements and techniques associated with desktop and enterprise Access development. Filled with scores of practical examples illustrating effective, elegant solutions to real-world challenges, these books will foster the skills you need to take your work-and your career-to the next level.

Access 2000 Developer's Handbook, Volume 1: Desktop Edition
Design, Build, and Refine Access Databases to Meet the Special Needs of Individuals and Small Workgroups
Design Forms and Reports That Meet Users' Exact Needs
Use Access as an Automation Client or Automation Server
Take Advantage of Shared Microsoft Office Programmability

Access 2000 Developer's Handbook, Volume 2: Enterprise Edition
Build and Deploy Scalable Enterprise-wide Applications
Develop Multi-User File-Server Applications
Create Web Pages that Connect to Access and SQL Server/MSDE Data
Manage Concurrency using Stored Procedures

Editorial Reviews

From the Back Cover

Expert Instruction. Advanced Coverage. An Unbeatable Price.

This two-volume set gives you the opportunity to buy the two most advanced guides to Access development at a significantly reduced price. Inside, you'll find unparalleled instruction from three internationally recognized Access experts, organized to reflect the very different requirements and techniques associated with desktop and enterprise Access development. Filled with scores of practical examples illustrating effective, elegant solutions to real-world challenges, these books will foster the skills you need to take your work-and your career-to the next level.

Access 2000 Developer's Handbook, Volume 1: Desktop Edition
Design, Build, and Refine Access Databases to Meet the Special Needs of Individuals and Small Workgroups
Design Forms and Reports That Meet Users' Exact Needs
Use Access as an Automation Client or Automation Server
Take Advantage of Shared Microsoft Office Programmability

Access 2000 Developer's Handbook, Volume 2: Enterprise Edition
Build and Deploy Scalable Enterprise-wide Applications
Develop Multi-User File-Server Applications
Create Web Pages that Connect to Access and SQL Server/MSDE Data
Manage Concurrency using Stored Procedures

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: 2684 pages
• Publisher: Sybex (December 15, 1999)
• Language: English
• ISBN-10: 0782123716
• ISBN-13: 978-0782123715
• Product Dimensions: 9.2 x 7.7 x 5.8 inches
• Shipping Weight: 10.7 pounds
• Average Customer Review: 4.9 out of 5 stars  See all reviews (36 customer reviews)
• Amazon Best Sellers Rank: #1,988,240 in Books (See Top 100 in Books)
  • #89 in Books > Computers & Technology > Microsoft > Applications > Office 2000

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

43 of 43 people found the following review helpful:

5.0 out of 5 stars Think you are an Access 2000 master?, July 26, 2001

By 

JRK "jkunz" (N.H.) - See all my reviews

This review is from: Access 2000 Developer's Handbook 2 Volume Set (Paperback)

Then pick up this two-volume set and confirm it! I'll bet you there are still tips and tricks that you can learn and this set will show them to you. Both books definitely fall under the Intermediate-Advanced Access 2000 users category....

Volume 1 still covers mostly design environment topics, like advanced reporting & forms, SQL, using ADO code to loop through recordsets, VBA tricks, working with other Office apps. If you are looking for advanced Access info like migrating to SQL Server, optimizing multiuser performance, Data Access Pages or setup/deployment of an application, look at Volume 2.

I can't even get in to the level of detail these books provide, so here are just a few examples of tips/tricks I found useful in my corporate development:

1. Building an Append query in Access query viewer that actually hits an external Excel or .txt file.
2. Using a report's NoData event to display a message that there is no data in a report rather than returning or printing a blank report.
3. Sorting & grouping a report on the fly by asking the user in a form how they want to group or sort, then doing it with code.
4. An incredible section on how to dynamically optimize the application's screen resolution based on the user's screen size, complete with code you can paste and use!
5. Custom autonumber (so my records are ordered sequentially, rather than having number gaps after deleting an autonumbered data type field).

There are plenty more that I could add but I assume you get the picture! If you are very comfortable with Access, you need this set to complete your library and call yourself an Access Master!

54 of 59 people found the following review helpful:

5.0 out of 5 stars Valuable Resource for Access Development, March 24, 2000

By 

Stephen M. Suazo (Billings, Montana) - See all my reviews

This review is from: Access 2000 Developer's Handbook 2 Volume Set (Paperback)

As a small developer, my resources for materials is somewhat limited among the thousands available. I have found the Developer's Handbook(s) from Sybex to be valuable in my daily development. They are written so that beginning chapters are easily understand even by beginning developers and continue on with a wealth of reference for the most advanced. With these books, I can honestly say that I have not yet found any programming problem I cannot solve.

29 of 30 people found the following review helpful:

5.0 out of 5 stars Simply the best..., December 3, 2001

By 

Jack H. Griswold (Charlotte, NC USA) - See all my reviews

This review is from: Access 2000 Developer's Handbook 2 Volume Set (Paperback)

I've been programming in Access for over six years and have never come across a more comprehensive and easy-to-follow set of books than these Developer's Handbooks (both Desktop and Enterprise). I started with the 2000 version and will always purchase the next versions as they become available.

As an old Access 95 Microsoft Certified Professional (MCP) I thought I knew the majority of the ins-and-outs of Access programming. Paul Litwin, Ken Getz, Mike Gunderloy - I give you my thanks for teaching this old dog new tricks.