Table of Contents

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

About the Author

Laurie Ulrich Fuller is a highly experienced tech author, consultant, and Office trainer. Her consulting firm, Limehat & Company, offers training, Web development, and marketing services.

Ken Cook is a database design expert, consultant, and author of several books on Office and Excel.