Beschreibung
Do you have tons and tons of data on your computer but youre not quite sure how to make heads or tails of themor 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 communicatewhile sparing you of any fancy language. This hands-on guide features clear, concise instructions that show you how to:
Orient yourself with forms and reportsCreate and modify queriesBuild and edit formsDesign and update reportsTroubleshoot queries, forms, and reportsMake your forms usefulAdd multiple tables to formsAdd finishing touches to reports
Thanks to the included references, Web sites, and informative tips, putting your data to good use has never been easier. Youll even add some pizzazz to your reports with handy suggestions on ways to wow your viewers. WithAccess 2007 Forms& Reports for Dummies, you will be creating effective queries, forms, and reports in no time!
Autorenportrait
Brian Underdahl is the well-known, bestselling 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 its the author who should do the work so that readers can get their moneys worth. Thats why his books are different he takes the time to explain whats going on so that readers can understand the subjects easily.
Darlene Underdahl spent many years as a Quality Assurance expert. She is applying that attention to detail in the writing she does today. In addition to technical writing, she has written a memoir of her early years and is gathering notes for future projects. She works and lives with her husband, the bestselling author Brian Underdahl, in the mountains above Reno, Nevada.
Inhalt
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
Informationen zu E-Books
„E-Book“ steht für digitales Buch. Um diese Art von Büchern lesen zu können wird entweder eine spezielle Software für Computer, Tablets und Smartphones oder ein E-Book Reader benötigt. Da viele verschiedene Formate (Dateien) für E-Books existieren, gilt es dabei, einiges zu beachten.
Von uns werden digitale Bücher in drei Formaten ausgeliefert. Die Formate sind EPUB mit DRM (Digital Rights Management), EPUB ohne DRM und PDF. Bei den Formaten PDF und EPUB ohne DRM müssen Sie lediglich prüfen, ob Ihr E-Book Reader kompatibel ist. Wenn ein Format mit DRM genutzt wird, besteht zusätzlich die Notwendigkeit, dass Sie einen kostenlosen Adobe® Digital Editions Account besitzen. Wenn Sie ein E-Book, das Adobe® Digital Editions benötigt herunterladen, erhalten Sie eine ASCM-Datei, die zu Digital Editions hinzugefügt und mit Ihrem Account verknüpft werden muss. Einige E-Book Reader (zum Beispiel PocketBook Touch) unterstützen auch das direkte Eingeben der Login-Daten des Adobe Accounts – somit können diese ASCM-Dateien direkt auf das betreffende Gerät kopiert werden.
Da E-Books nur für eine begrenzte Zeit – in der Regel 6 Monate – herunterladbar sind, sollten Sie stets eine Sicherheitskopie auf einem Dauerspeicher (Festplatte, USB-Stick oder CD) vorsehen. Auch ist die Menge der Downloads auf maximal 5 begrenzt.
