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
Introduction.
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).
Index.
Anonymous
Posted Sun Feb 26 00:00:00 EST 2006
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 NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
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 ...