Access 2010 For Dummies

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