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.

I have been writing Excel-based VBA applications for years and always struggled to find a good reference for various functions, properties, and objects. I recently moved up from Excel 97 to Excel 2000 and was struggling. I had continued to use my old Excel 5.0 references because I had trouble finding newer ones that contained substabtial information. Some of my old VBA code wasn't working in Excel 2000 (VBA has been enhanced considerably since Excel 5.0)so I was stuck. I found this book listed at Amazon.com and ordered it as a trial. If you're an Excel 2000 user who writes a lot of VBA code, this book is the reference I recommend. There are some reviews here that complain about the format of this book not matching other Wrox publications and being harder to use. That may be true - I haven't used other Wrox publications - but I found everything I needed and a few extras in here. It's not the only Excel 2000 VBA reference I have on my shelf - check out Microsoft Excel 2000 Power Programming with VBA by John Walkenbach and SAMS Teach Yourself Excel 2000 Programming in 21 Days by Matthew Harris - they're both good references as well.

Many programmers are not satisfied that their programs work, but they also want to know if the techniques they employ are the most efficient, or if there is a better means of doing something. For those readers who want to make use of Excels sophisticated object model this is a great book to learn how to do it best. Just about every programming technique I have needed has been covered, allowing me to develop Excel applications written with efficient code that is FAST.

John Green seems to stay one step ahead by pre-empting any questions the reader has, and all the points he covers are backed up with code. Often the author will give several alternative approaches to solving a particular task programmatically, and also explain which approach is more effective / efficient and why.

Although some explanation of basic programming techniques are covered in the "Primer in Excel VBA" chapter, this book is probably best suited to readers who have some programming background (although you don't have to be a pro either).

My one criticism is directed more at Wrox Press than John Green, and is the reason I have only given four stars not five. As has been already mentioned in other reviews, the index is very poor, and is little more than an extended Table Of Contents - a trait in common with other Wrox books I have read. Finding that "golden nugget" in this is a gold mine of information is very time consuming. For example, trying to find the section on the EVALUATE or CALLER methods from the index won't yield much success unless you already know that they are covered in "Chapter Three: The Application Object Model" - this is what you look up in the index - crazy! Finding other entries in the index is just impossible since they are not there.

My suggestion is buy this book, but as you read it through for the first time, use a highlighter on any points that you think may be of significant interest.

As a professional VBA programmer, I found this book to be an excellent reference. Although I use Excel 97, many of the programming concepts are the same as for Excel 2000. Each chapter maps well onto real-world issues that are likely to come up in an intensive programming environment. A good example of this is the chapter on International issues: I have recently been involved in developing a system installed in several countries across Europe, where the users previously had to switch to UK settings in order for the system to work. The book is not intended as a 'learn to program' guide, a genre which is too heavily catered for already, rather as a programmer's reference laid out in such a way as to find solutions to real-world problems quickly.