Underdahl Access 2007 Forms and Reports For Dummies

1. Auflage 2013
ISBN: 978-0-470-12061-3
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 416 Seiten, E-Book

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 reports
Thanks 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!

Autoren/Hrsg.

Underdahl, Brian

Underdahl, Darlene

Inhaltsverzeichnis

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

Über Autor(innen)

Brian Underdahl is the well-known, bestselling author ofover 70 computer books on a broad range of subjects. He hasappeared on a number of TV shows, including the ComputerChronicles, and several TechTV programs, and is thesubject of an hour-long interview on the syndicated ComputerOutlook radio program. One of his titles was recentlyrecommended to viewers by Scott Gurvey, Bureau Chief, on theNightly Business Report on PBS, and his books have wonawards including an Award of Merit from the Northern CaliforniaTechnical Communications Competition and the ReferencewareExcellence Award for best title in the Graphic Design andMultimedia category.
Brian has been involved in personal computers from their beginningand has a background in electrical engineering. His last"real" job was as a Senior Programmer/Analyst for alarge company, where he worked hard to bring the power and freedomof PCs to the desktops.
Brian figures that it's the author who should do the work sothat readers can get their money's worth. That's whyhis books are different -- he takes the time to explainwhat's going on so that readers can understand the subjectseasily.
Darlene Underdahl spent many years as a Quality Assuranceexpert. She is applying that "attention to detail" inthe writing she does today. In addition to technical writing, shehas written a memoir of her early years and is gathering notes forfuture projects. She works and lives with her husband, thebestselling author Brian Underdahl, in the mountains above Reno,Nevada.