Introduction 1?

Part1: Basic Training 5?

Chapter 1: Access Basics 7?

Chapter 2: Finding Your Way in the Access Workspace 25?

Chapter 3: Database Basics 43?


Part2: Getting It All on the Table 63?

Chapter 4: Sounds Like a Plan 65?

Chapter 5: Table Tune-Ups 77?

Chapter 6: Remodeling Your Data 95?

Chapter 7: Types, Masks, and Triggers 111?


Part3: Data Management Mania 137?

Chapter 8: A Form for All Reasons 139?

Chapter 9: Importing and Exporting Data 159?

Chapter 10: Automatically Editing Data 173?

Chapter 11: Access and the Web 185?


Part4: The Power of Questions 199?

Chapter 12: Finding, Filtering, and Sorting Your Data - Fast 201?

Chapter 13: I Was Just Asking for Answers 219?

Chapter 14: I Want These AND Those OR Them 245?

Chapter 15: Number Crunching with the Total Row 255?

Chapter 16: Express Yourself with Formulas 267?

Chapter 17: Take Charge with Action Queries 281?


Part5: Simple and Snazzy Reporting 293?

Chapter 18: Fast and Furious Automatic Reporting 295?

Chapter 19: Professionally Designed Reports Made Easy 313?

Chapter 20: Groups and Page Breaks, Headers and Footers 333?


Part6: The Part of Tens 351?

Chapter 21: Ten Common Problems 353?

Chapter 22: Ten Uncommon Tips 365?

Appendix A: Getting Help 373?

Index 375