Access 2007 Forms and Reports For Dummies

Do you have tons and tons of data on your computer but you re not quite sure how to make heads or tails of them or even organize them? Are you using Access as spreadsheet rather than what it was really meant for? If you have trouble finding meaning in your data, then Access 2007 Forms & Reports for Dummies let you discover the wonders of this highly useful program. This no-nonsense guide gets right down to business by showing you the easy way to use this powerful tool. It gets you started with selective, targeted queries; forms that improve efficiency; and reports that communicate while sparing you of any fancy language. This hands-on guide features clear, concise instructions that show you how to: Orient yourself with forms and reports Create and modify queries Build and edit forms Design and update reports Troubleshoot queries, forms, and reports Make your forms useful Add multiple tables to forms Add finishing touches to reports Thanks to the included references, Web sites, and informative tips, putting your data to good use has never been easier. You ll even add some pizzazz to your reports with handy suggestions on ways to wow your viewers. With Access 2007 Forms & Reports for Dummies, you will be creating effective queries, forms, and reports in no time!

Do you have tons and tons of data on your computer but you'renot quite sure how to make heads or tails of them--or evenorganize them? Are you using Access as spreadsheet rather than whatit was really meant for? If you have trouble finding meaning inyour data, then Access 2007 Forms & Reports for Dummieslet you discover the wonders of this highly useful program.This no-nonsense guide gets right down to business by showingyou the easy way to use this powerful tool. It gets you startedwith selective, targeted queries; forms that improve efficiency;and reports that communicate--while sparing you of any fancylanguage. This hands-on guide features clear, concise instructionsthat show you how to:* Orient yourself with forms and reports* Create and modify queries* Build and edit forms* Design and update reports* Troubleshoot queries, forms, and reports* Make your forms useful* Add multiple tables to forms* Add finishing touches to reportsThanks to the included references, Web sites, and informativetips, putting your data to good use has never been easier.You'll even add some pizzazz to your reports with handysuggestions on ways to wow your viewers. With Access 2007 Forms& Reports for Dummies, you will be creating effectivequeries, forms, and reports in no time!

Introduction 1Part I: Accessing Both Ends: Getting Data In and Info Out 7Chapter 1: Getting to Know Forms and Reports 9Chapter 2: Getting Started with Queries 23Chapter 3: Creating Simple Forms 43Chapter 4: Building Basic Reports 65Part II: Creating Effective Queries 91Chapter 5: Creating Multi-Table Queries 93Chapter 6: Modifying Data with Queries 111Chapter 7: Expanding Queries with SQL 131Chapter 8: Dealing with Quarrelsome Queries 151Part III: Building Really Useful Forms 171Chapter 9: Building Better Forms by Using Controls 173Chapter 10: Using Multiple Tables in Forms 193Chapter 11: Fixing Form Faults 207Part IV: Designing Great Reports 221Chapter 12: Adding Fancy Touches to Reports 223Chapter 13: Creating Reports That Summarize Data 245Chapter 14: When Reports Go Wrong 263Part V: Way Cool Advanced Queries, Forms, and Reports 273Chapter 15: Tricks for Finding Data with Queries 275Chapter 16: Tricks for Updating with Queries 291Chapter 17: Killer Ways to Improve Forms 305Chapter 18: Expert Methods for Sharing Reports 327Chapter 19: Making Reports Look Better 339Chapter 20: Adding Efficiency with Great Tools 353Part VI: The Part of Tens 365Chapter 21: Ten Great Access Sites Online 367Chapter 22: Ten Things to Know about Queries (That Also Help You with Forms and Reports) 373Index 377