Access 2000 Developer's Handbook 2 Volume Set
by Ken Getz, Mike Gilbert, Paul Litwin

Our Price: $242.99
Availability: Usually ships in 1-2 business days
Buy Used: from $4.85 (click here)
Category: Book
See more book details and other editions

Book Summary Information

Book Reviews of Access 2000 Developer's Handbook 2 Volume Set

Book Review: Think you are an Access 2000 master?
Summary: 5 Stars

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!

Summary of Access 2000 Developer's Handbook 2 Volume Set

Databases Books

• Subjects > Computers & Technology > Databases
• Microsoft > Applications > Office 2000
• Programming > Software Design, Testing & Engineering > Software Development
• Software