Access 2010 For Dummies

A friendly, step-by-step guide to the Microsoft Office database application Access may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learn to use Access 2010 quickly and easily. In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more. As the Microsoft Office database application, Access may be the least understood and most challenging part of the Office suite Access 2010 For Dummies walks newcomers through building and using their first database Covers linking information in a database, setting relationships, modeling data, and building tables Explores how to extract data from Access and get specific answers, create forms, and export data in reports A section for more experienced users looks at analyzing errors and creating an interface Fully updated for the newest version, Access 2010 For Dummies gets new Access users up to speed and helps veterans get the most from the Office database application.

A friendly, step-by-step guide to the Microsoft Office databaseapplicationAccess may be the least understood and most challengingapplication in the Microsoft Office suite. This guide is designedto help anyone who lacks experience in creating and managing adatabase learn to use Access 2010 quickly and easily.In the classic For Dummies tradition, the book providesan education in Access, the interface, and the architecture of adatabase. It explains the process of building a database, linkinginformation, sharing data, generating reports, and much more.* As the Microsoft Office database application, Access may be theleast understood and most challenging part of the Office suite* Access 2010 For Dummies walks newcomers through buildingand using their first database* Covers linking information in a database, settingrelationships, modeling data, and building tables* Explores how to extract data from Access and get specificanswers, create forms, and export data in reports* A section for more experienced users looks at analyzing errorsand creating an interfaceFully updated for the newest version, Access 2010 ForDummies gets new Access users up to speed and helps veteransget the most from the Office database application.

Introduction 1Part I: Basic Training 9Chapter 1: Getting to Know Access 2010 11Chapter 2: Finding Your Way Around Access 37Chapter 3: Database Basics 59Part II: Getting It All on the Table 79Chapter 4: Keys, Relationships, and Indexes 81Chapter 5: Remodeling Your Data 99Chapter 6: What's Happening Under the Table? 115Part III: Data Mania and Management 139Chapter 7: Creating Data Forms 141Chapter 8: Importing and Exporting Data 155Chapter 9: Editing Data Automatically 169Chapter 10: Gather Locally, Share Globally 181Part IV: Ask Your Data, and Ye Shall Receive Answers 201Chapter 11: Fast Finding, Filtering, and Sorting Data 203Chapter 12: I Was Just Asking . . . for Answers 219Chapter 13: I'll Take These AND Those OR Them 245Chapter 14: Queries That Think Faster Than You 255Chapter 15: Calculating with Your Data 267Chapter 16: Flying into Action Queries 283Part V: Plain and Fancy Reporting 295Chapter 17: Quick and Not-So-Dirty Automatic Reporting 297Chapter 18: Dazzling Report Design 319Chapter 19: Headers and Footers and Groups, Oh My! 345Chapter 20: Magical Mass Mailings 367Part VI: More Power to You 375Chapter 21: Making It All Better with the Analyzer Tools 377Chapter 22: Hello! Creating an Interface to Welcome Database Users 389Part VII: The Part of Tens 399Chapter 23: Ten Common Problems 401Chapter 24: Ten Uncommon Tips 413Index 421