Introduction 1
Part I: Basic Training 7
Chapter 1: Getting to Know Access 2007 9
Chapter 2: Finding Your Way Around Access 29
Chapter 3: Database Basics 51
Part II: Getting It All on the Table 69
Chapter 4: Keys, Relationships, and Indexes 71
Chapter 5: Remodeling Your Data 87
Chapter 6: What's Happening Under the Table? 103
Part III: Data Mania and Management 127
Chapter 7: Creating Data Forms 129
Chapter 8: Importing and Exporting Data 143
Chapter 9: Automatically Editing Data 155
Chapter 10: Gather Locally, Share Globally 167
Part IV: Ask Your Data, and Ye Shall Receive Answers 181
Chapter 11: Fast Finding, Filtering, and Sorting Data 183
Chapter 12: I Was Just Asking . . . For Answers 199
Chapter 13: I'll Take These AND Those OR Them 227
Chapter 14: Queries That Think Faster Than You 237
Chapter 15: Calculating with Your Data 251
Part V: Plain and Fancy Reporting 265
Chapter 16: Quick and Not-So-Dirty Automatic Reporting 267
Chapter 17: Dazzling Report Design 289
Chapter 18: Headers and Footers and Groups, Oh My! 315
Chapter 19: Magical Mass Mailings 335
Part VI: More Power to You 341
Chapter 20: Making It All Better with the Analyzer Tools 343
Chapter 21: Hello! Creating an Interface to Welcome Data Users 353
Part VII: The Part of Tens 365
Chapter 22: Ten Common Problems 367
Chapter 23: Ten Uncommon Tips 377
Appendix: Getting Help 383
Index 391
