Expert One-on-One Microsoft Access Application Development (Paperback)

On the other hand, the author presented 13 full pages of VBA code to demonstrate using the ItemsSelected collection of a MultiSelect listbox, a concept that could have been demonstrated in about 10 lines of code. I found it interesting that the author never mentioned the Control Wizard, which can automatically generate VBA code for many control events. Also the author never mentioned that a callback function could be used as the record source for a combobox (or listbox).

In the first half of the book the author uses the Toy Workshop database example to illustrate how to create/modify tables, relationships, forms, controls and reports. The reader very quickly must become familiar with the structure of this database. A complete summary of the tables (listing the fields), forms (listing the controls), queries, and reports in an appendix would have been very helpful. The reader is almost forced to download the sample databases from the Wrox website to get anything out of the book.

The author had many pages presenting the three add-ins that she developed: Design Schemes, LNC Rename and the Menu Manager add-in. On the surface these add-ins appear to be good tools for an Access developer, but the LNC Rename add-in (used to rename objects using the Leszynski naming convention) was not designed to work for controls with existing VBA code. And I wasn't crazy about the design of the main form created by the Menu Manager. Not to mention the fact that this add-in required you to rename your main form using a non-standard "fpri" tag. I would have liked for the author to give me the expert guidance that I need to create my own add-ins rather than to simply use the "canned" add-ins developed by the author.

I didn't read the chapters on Automation dealing with Word, Outlook or applications outside of Office. The chapter "Working With Word" probably is one of the best chapters since this subject appears to one of the author's areas of expertise. I did read the chapter on "Working with Excel". It was OK. It just scratched the surface of the subject of automation between Access and Excel, primarily dealing with how to programmatically export data from Access to Excel and import data from Excel into Access.

Before you decide to purchase this book, I'd recommend taking a look at Alison Balter's book "Mastering Microsoft Access 2000 Development " and Scott Barker's book "Microsoft Access 2000 Power Programming". And if you decide to purchase this book, plan on downloading the sample databases (Note: the three ZIP files are a whopping 114MB) and plan on spending a lot of time studying the sample tables, forms, queries, reports, and VBA code.

My only complaint concerns the sample files. Wrox used to include a CD, but now they seem to be leaining toward web downloads. Not a bad idea but, in this case, the files are over 100 MB. If you don't have broadband, you may be working in Access 2004 before you're finished downloading these samples.