Professional Access 2000 Programming

I've created basic database structures and applications for about five years and pledged never to go past writing macros, because I didn't want to be forced to learn VBA. I run a realty and mortgage office and just couldn't spare the time. Now that Outlook and the Office suite is becoming more familiar with my crew and now that we've joined a WAN and some B2B data sharing, the basic stuff just didn't fill the bill. I've bought quite a few books on Access recently (not to mention dozens from the past few years) and have found this one to be one of the best in its presentation and content. It gave me some real insight on how I should be considering networking and upsizing. I answered more questions I had after spending 12 hours with the book, than I had spent searching the net or reading the other books for several months. I even read though the code and understood it, and contrary to the warnings the presentation still flowed well. I still know little VBA and am now going back to get a Wrox book on Beginnng Access 2000 VBA. Concise, very detailed, stuffed full of info and reference. I'm a Wrox fan now.

I've been consulting for over 5 years with Access in all it's iterations except 1.0 and I must say that this is the best book on intermediate topics that I have found. There is no "fluff" like in books from other publishers (especially Queue in my opinion). This book is concise with real world examples for real world issues. When I first opened this book and read a bit I realized this book was written by consultants/developers who have gotten there hands dirty and not "feel good" academics who have never written a line of code for a company. Keep this one handy if you're the Access guru at your firm.

Professional Access 2000 Programming is a combination of a training book to heighten your programming skills, and a reference work that will give you a complete overview of Access 2000 and it's related programming environment. It's written in the traditional Wrox style that is so easy to read and usable for developers.One thing I do miss, is the usual Wrox opening statement where it is described whom the book is written for and if any previous programming skills are assumed. It's not until chapter 3 that you find out VB or VBA programming experience is assumed to make use of the chapter. Don't start on this book without any knowledge of VBA, since it is used in most of the coding examples. If you don't know VBA check out the following books: ISBN 0782123244, ISBN 1861001762 and ISBN 0735605920. An understanding of ADO would also improve on the usability of the book.To make use of the books fullest potential, have a design plan of your database next to it and make notes or check for errors in your design when you go through the chapters. This helped me to improve on the design of my database.Not essential, but it would have been nice if the sample code used in the book had been made available to the reader. At one place in the book the author even writes that the sample code is available from Wrox' website, but as of today it is not.This book has given me the skills and confidence to start working on client/server solutions and integrating SQL server. It breaks down the entire complexity surrounding Access 2000 and database development to sizeable blocks and tools that I can piece together according to programming and design goals. A must have for any Access programmer on his way to become a true professional.