Instant Access Databases [With CDROM]

by Greg Buczek

Book Overview

This work aims to act as a cookbook for professional developers and database administrators who want to get the most from their Access databases. It provides complete recipes for a number of Access... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072130768
• ISBN13: 9780072130768
• Release Date: December 2000
• Publisher: McGraw-Hill Companies
• Length: 759 Pages
• Weight: 3.45 lbs.
• Dimensions: 1.8" x 7.3" x 9.2"

Customer Reviews

A very nice book

This was really an excellent book. It contains many great sample databases. You will get your money's worth in DAO.recordset operations. One section of sample code just did not work, which caused me to spend some extra time fixing. It was the code to generate Word Tables (Chapter 14). Better instructions for creating grouped Data Access Pages (Chapter 17) were also needed. I also thought that instructions on running all the code in the last chapter concerning Active Server Pages were lacking. Other than these set backs it was still a great book. I think that in many places in the code there were opportunities for the author to implement domain aggregate functions instead of recordsets, With/End With code blocs, case expressions, Between/ And Where clauses in queries as opposed to two expressions joined together by an OR clause, Between/ And clauses in validation rules for tables, the IN operator in queries to avoid expressions with multiple OR operators, and general sub procedures for events that call the same actions. The more experienced reader will find these places and modify the code if he or she so desires. The author seemed to use the same techniques all the time no matter what the situation was as a way to keeping things as simple as possible, without bombarding the reader with other alternatives.

Great Guide!!!

I knew the basics of Access. I can create tables, use the wizards to create forms and use the wizards to create reports. I have found many books that can teach me that.But I needed to go further. I needed to start writing code that powered my Access databases. This book showed me how to do that.The author took me step by step through numerous examples that have empowered me to write code that really make my applications so much better.I highly recommend this book.

I've used his ASP books - this is just as good

I first read the author's work when I needed a "direct approach" to ASP scripts, so I thought I'd give his Access book a try because I saw an example like what I needed to develop. I am VERY pleased - his ability to clearly convey a tramendous amount of information embedded in nice, concise examples is this author's strength. Very much to the point - numerous examples - it's a whole book of well-explained examples. Very good book if you want to put together a successful applicatin in a hurry. Thanks again!