Access Forms & Reports For Dummies


Create queries that make forms and reports useful

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

If you thought you had to use a spreadsheet program to produce reports and forms, guess what! Access can turn out great-looking forms and reports that actually show what's going on ...

See more details below
Other sellers (Paperback)
  • All (35) from $1.99   
  • New (13) from $4.00   
  • Used (22) from $1.99   
Sending request ...


Create queries that make forms and reports useful

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

If you thought you had to use a spreadsheet program to produce reports and forms, guess what! Access can turn out great-looking forms 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 you do just that, and it works with all versions of Access.

Discover how to
* Ask Access the right questions
* Work with sets of data
* Create simple forms with a wizard
* Use queries to create new tables
* Troubleshoot queries
* Add visual features to reports

Read More Show Less

Product Details

  • ISBN-13: 9780764599651
  • Publisher: Wiley
  • Publication date: 9/30/2005
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 408
  • Sales rank: 1,410,771
  • Product dimensions: 9.24 (w) x 10.90 (h) x 0.88 (d)

Meet the Author

Brian Underdahl is the well-known, best selling author of over 70 computer books on a broad range of subjects. He has appeared on a number of TV shows, including the Computer Chronicles, and several TechTV programs, and is the subject of an hour-long interview on the syndicated Computer Outlook radio program. One of his titles was recently recommended to viewers by Scott Gurvey, Bureau Chief, on the Nightly Business Report on PBS, and his books have won awards including an Award of Merit from the Northern California Technical Communications Competition and the Referenceware Excellence Award for best title in the Graphic Design and Multimedia category.
Brian has been involved in personal computers from their beginning and has a background in electrical engineering. His last “real” job was as a Senior Programmer/Analyst for a large company, where he worked hard to bring the power and freedom of PCs to the desktops.
Brian figures that it’s the author who should do the work so that readers can get their money’s worth. That’s why his books are different — he takes the time to explain what’s going on so that readers can understand the subjects easily.

Read More Show Less

Table of Contents


Part I: Accessing Both Ends: Getting Data In and Info Out.

Chapter 1: Getting to Know Forms and Reports.

Chapter 2: Getting Started with Queries.

Chapter 3: Creating Simple Forms.

Chapter 4: Building Basic Reports.

Part II: Creating Effective Queries.

Chapter 5: Creating Multi-Table Queries.

Chapter 6: Modifying Data with Queries.

Chapter 7: Expanding Queries with SQL.

Chapter 8: Dealing with Quarrelsome Queries.

Part III: Building Really Useful Forms.

Chapter 9: Building Better Forms by Using Controls.

Chapter 10: Using Multiple Tables in Forms.

Chapter 11: Fixing Form Faults.

Part IV: Designing Great Reports.

Chapter 12: Adding Fancy Touches to Reports.

Chapter 13: Creating Reports that Summarize Data.

Chapter 14: When Reports Go Wrong.

Part V: Way Cool Advanced Queries, Forms, and Reports.

Chapter 15: Tricks for Finding Data with Queries.

Chapter 16: Tricks for Updating with Queries.

Chapter 17: Killer Ways to Improve Forms.

Chapter 18: Expert Methods for Sharing Reports.

Chapter 19: Making Reports Look Better.

Chapter 20: Adding Efficiency with Great Tools.

Part VI: The Part of Tens.

Chapter 21: Ten Great Access Sites Online.

Chapter 22: Ten Things to Know About Queries (That Also Help You with Forms and Reports).


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted February 26, 2006

    Access Forms and 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.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)