Access 2003 for Dummies

Access 2003 All-in-One Desk Reference for Dummies

Microsoft Access 2003 Forms, Reports, and Queries (Business Solutions)

Databases

Access Forms & Reports For Dummies

Format: Paperback
Author: Brian Underdahl
ReleaseDate: 30 September, 2005
Publisher: For Dummies
Rating:

How not to be an Access dummy
It is not a complete Access reference book. First, it is important to realize what this book is not. It will not teach you database theory and all aspects of data normalization. It does not cover advanced techniques such as VBA programming, the ADO object model or using the Windows API.

So what do you get from this book? A fantastic introduction to developing forms, reports and queries. In the tradition of the Dummies series, the author gently guides the novice towards building expertise in this narrow but all important aspect of Microsoft Access. With a conversational style, each step in creating a report, form or query is clearly explained. Also, the reasons for creating a report or form, and the differences between the two are presented. Although the title doesn't mention queries, because they are integral to producing reports and forms, several chapters deal with queries. Finally, two chapters discuss enhancing queries with SQL and troubleshooting those queries when things go wrong.

In summary, by spending a few days with the author, via this book, a beginning Access programmer can quickly become adept at designing forms and generating reports.

Access Forms & Reports for Dummies
However, recently I needed to get up to speed with Microsoft's Access, specifically in order to prepare reports. I have shelves filled with computer "How To" type books and in the past have stayed away from the "Dummies" series thinking them to be a bit too simplified. So I bought Access Forms & Reports for Dummies by Brian Underdahl. I found this book to be a refreshing diversion from the normally dry and sometimes obtuse computer books of the past. Mr. Underdahl has a colloquial writing style which is not only entertaining but highly informative. Within a very short period of time I found myself successfully creating Forms and Reports which made my work go much smoother. I highly recommend this book to anyone who needs to understand Access and quickly create Forms and Reports.

Makes Access Far More Useful
Unlike many of the big database programs, it is closely integrated with a quite sophisticated front end package to enable the creation of easy to use input forms and quite good looking reports to take the data stored in the database and present it to the outside world in a clear and useful format. Access is, of course, a database program.

A database is useless unless you have a way to put data into and take it out of the database. This book mostly covers the setting up of input forms and output reports. It obviously won't be your only Access book, because you'll need something to describe how to set up a database. So this is a specialty book, that does an excellent job of covering this important aspect.

Selecting data out of the database to then present is sometimes a problem. Most beginning books just use the Access QBE to produce the data. Often this is enough, but this book goes just a bit into SQL that allows you to do so much more. While this is not a book on SQL, this is a good start to give you enough information to know if this is a direction you need to go.

All in all, this is a very useful book to enable you to get more utility ot of an Access database.