Rating: 
Summary: An Essential Book for Access 2000 Automation and VBA
Review: I 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.
Rating:
Summary: Still waiting for the second volume
Review: I spent the first few days only looking at the awesome class modules provided on the CD that accompanied this book. It helped me a lot in understanding new techniques, and used some of the codes for developing the dbase for a research project I'm working on. Geek to geek..I strongly suggest having this book, the authors spent a great deal of time writing it for the ease of the rest of us. They have an extensive explanation how to incorporate Access with the rest of Microsoft components such as Outlook.
Rating: 
Summary: The Access Book I've Wanted for Years
Review: I started using Microsoft Access in 1993, and have been buried in it since then. I can only speak for myself (my co-authors will have to speak for themselves) but Access 2000 Developer's Handbook, Volume I, is the Access book I've wanted to write for a few versions now. In the Access 97 timeframe, class modules were added so late that we really couldn't use them in the book--we were all done writing before they were available in the product. This time, however, in addition to providing what we hope is the most comprehensive coverage available of programming Access in a single-user or small LAN environment, we've written a ton of reusable and modifiable classes, wrapping up all sorts of interesting and sometimes difficult functionality. The odd part is that very few of these classes really have much to do with Access itself--they just make it a lot easier to use Microsoft Access. (You might note that almost all the code provided in this book can be exported to, and used in, Access 97 with very little modification.) I hope you find this book to be as useful a reference as I do (I use the book and its code all the time, in other projects; some in Access, some in VB). Please, let us hear from you with suggestions and/or thoughts on the book. Stop by http://www.developershandbook.com to let us know who you are, and for updates, errata, downloads, articles, and anything else we can find to make available to you. Check out Access 2000 Developer's Handbook, Volume II (Enterprise Edition) for information on developing Access applications for use in an enterprise-wide environment. (There is no overlap of any kind between the two books' content.) If you're considering purchasing both books, you might look into the boxed set (Access 2000 Developer's Set) including both books, at a somewhat lower total cost. We're looking forward to hearing from you, and best wishes in your Access development. (By the way, we apologize for the heft of this book--it was originally to be much shorter. We just kept finding things that we thought developers might be interested in, and the book got longer and longer. Be thankful: the book doubles as weight-lifting equipment!)
Rating:
Summary: the coerced programmer's bible
Review: If you have the (mis)fortune to fall into the world of Access development as I did, you cannot go wrong with this book. I've been working with Access since version 2.0, and using the ADH since their 97 version. It's not really for an Access beginner, of course, but it can teach you everything you need to know to go from being an intermediate user to being a power developer, in really CLEAR language, and with tons of really reusable answers. I've looked at other Access books, used a few in my time, and they just read like books about Access. This gives you answers.
Rating:
Summary: the coerced programmer's bible
Review: If you have the (mis)fortune to fall into the world of Access development as I did, you cannot go wrong with this book. I've been working with Access since version 2.0, and using the ADH since their 97 version. It's not really for an Access beginner, of course, but it can teach you everything you need to know to go from being an intermediate user to being a power developer, in really CLEAR language, and with tons of really reusable answers. I've looked at other Access books, used a few in my time, and they just read like books about Access. This gives you answers.
Rating:
Summary: One of the finest Access resources available.
Review: Once again Ketz, Litwin, and Gilbert have provided the Access community with a "must have" book. No developer should be without this resource on his or her shelf. I have purchased a copy of every Access Developers Handbook to date and would be hard pressed to do without any of them. Time and time again it has provided in depth information needed in developing applications. When I have a problem or need information, it's the first thing I grab for. I would never be without it. Jim Dettman President, Online Computer Services of WNY, Inc. Sysop and member of the MS ACCESS forum on Compuserve.
Rating:
Summary: The finest Access book on the market for serious developers
Review: Our firm tried several books before we discovered the Access 97 Developer's Handbook. The search stopped there, and it wasn't long before we had the 95 version as well. There was no question that we'd buy the ADH2000 Vol 1, and we've no regrets. For serious developers, this is the only Access book to buy, with the exception of Microsoft-provided documentation, though with this book you probably won't need it.
Rating:
Summary: Definitive Resource for Microsoft Access And VBA Developers
Review: 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.
Rating:
Summary: The Definitive Access Bible
Review: The series of Developers handbooks by Litwin, Getz & Gilbert are No 1 Best sellers for one reason. They are the definitive Access Bible for both novice and professional Access developers. My battered and torn Access 97 developers Handbooks is testament to the number of times I re-read this book and the Access 2000 edition is even better. Both are now part of my "must have" travel accessories for wherever I contract. Whether you are a beginner starting out with access or a seasoned programmer in Access, there is always something new to be gained from these information packed pages. I recommend this book to my fellow Access developers, and I also recommend it to you.
Rating:
Summary: Think you are an Access 2000 master?
Review: Then pick up this book and confirm it! I'll bet you there are still tips and tricks that you can learn and this book will show them to you. This book definitely falls under the Intermediate-Advanced Access 2000 users category. Those new to Access should go to the Access Bible, ISBN 0764532863. 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!
| 
