Access Forms and Reports for Dummies

by Brian Underdahl

Create queries that make forms and reports useful

Develop forms to access the data you need and make reports thatmake sense

If you thought you had to use a spreadsheet program to producereports and forms, guess what Access can turn out great-lookingforms and reports that actually show what's going on with your data-- if you know how to ask it nicely. This hands-on guide helps youdo just that, and it works with all versions of Access.

Discover...

• Format: Paperback
• Language: English
• ISBN: 0764599658
• ISBN13: 9780764599651
• Release Date: September 2005
• Publisher: For Dummies
• Length: 416 Pages
• Weight: 1.40 lbs.
• Dimensions: 1.0" x 7.4" x 9.5"

Customer Reviews

How not to be an Access dummy

First, it is important to realize what this book is not. It is not a complete Access reference book. 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

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. However, recently I needed to get up to speed with Microsoft's Access, specifically in order to prepare reports. 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

Access is, of course, a database program. 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. 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.

Best Access book I've found

I bought a bunch of Access books, but this one is by far the most helpful one yet. It shows me how to do a lot of things I've wanted to do, but simply couldn't figure out on my own (or from any of those other books). You really need to add this one to your collection!

Great Reference Book, too

I know how to use Access... sort of. I took this book and used it to update my knowledge of Access Forms & Reports. I just didn't realize how MUCH I was lacking in my understanding of what is available. This book is not only a great book for covering the basics (and advanced topics) for using Forms and Reports (templates and creating your own). It is ALSO a great reference book. I have a lot of Brian Underdahl's books on my shelf. Most of them I use continually as reference - when I simply cannot remember (or find) how to do something with the software I use, I find myself STILL reaching for his books. Great book - five stars. Mr. Underdahl's writing style is what I enjoy and when you find a technical writer that you enjoy, you sick with him/her. Check out his other books, "Flash MX Complete Reference" and "Create Your OWn DVDs" - I use these ALL the time. J