Access 2007 For Dummies

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