development
| » applied microsoft ... |
| SERCountTM Ratings | |
|---|---|
| Popularity | 6 |
Access 2000 Developer s Handbook Volume 1 Desktop
The following report compares books using the SERCount Rating (base on the result count from the search engine).
Rating: 4.78/5 from 27 reviews Think you are an Access 2000 master?An Essential Book for Access 2000 Automation and VBAI purchased this book on the recommendation of our local Access SIG group leader. He spoke highly of authors' Access 97 Handbook. I am new to Access and VBA. I was anxious to come up to speed quickly. I first purchased "Sams Teach Yourself Microsoft Access 2000 in 21 days" by Paul Cassel and Pamela Palmer. That book put me on the right path. After almost completing that book, I started tackling some complex automation projects. This book accelerated my learning to an amazing degree. This handbook explains the ADO Model, the Object Model and Automation very clearly and logically. The examples are excellent and the companion CD is really useful. The only topic this book does not cover is the DDE (Dynamic Data Exchange). On the other hand, after reading the book, I realized that the DDE is not necessary for automation since the Object Model is more powerful and efficient. I recommend this book to anyone who has the need to use VBA for automation and for extending the standard capability of Access 2000. Simply the bestThis book is simply fabulous. In fact both Volumes 1 and 2 are brilliant. If you need accurate, detailed, and to-the-point information about Microsoft Access then this is the only way to go. The Developer's Handbook has everything anyone could ever need to know about Access. Granted, it is not for Access beginners, but if you have a handle on tables, forms, queries, and reports, and you aren't afraid to get into a little bit of VBA, (i.e. if you're not in the market for "Access for Dummies" or "Access in 24 Hours") then skip the books for intermediate users, such as the completely inadequate Access Bible, and get the Developer's Handbook. Part of my job is developing Access databases for small businesses and I use this book on a daily basis. I have yet to find a single feature in Access that this book does not cover. And if you're trying to do something with Access that it doesn't readily perform, chances are this book will tell you exactly how to do it, or it will provide a work-around for the problem you are facing. Do yourself a favour: don't waste your time buying other Access books. Get the Developer's Handbook and you'll save hours of frustration. | ||||||||||||||||||||
This book 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 or setup/deployment of an application, look at Volume 2 ISBN 0782123724.
I can't even get in to the level of detail this book provides, so here are just a few examples of tips/tricks I found useful in my corporate development:
1. Building an Append query in Access that actually hits an external Excel 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 how they want to group or sort, then do 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!
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 book to complete your library and call yourself an Access Master!