Table of Contents
Introduction 1
Part 1: Basic Training 5
Chapter 1: Access Basic Training 7
Chapter 2: Navigating the Access Workspace 25
Chapter 3: Database Basics 43
Part 2: 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
Part 3: Data Management Mania 135
Chapter 8: A Form for All Reasons 137
Chapter 9: Importing and Exporting Data 157
Chapter 10: Automatically Editing Data 171
Chapter 11: Access and the Web 183
Part 4: The Power of Questions 197
Chapter 12: Finding, Filtering, and Sorting Your Data — Fast 199
Chapter 13: I Was Just Asking for Answers 215
Chapter 14: I Want These AND Those OR Them 241
Chapter 15: Number Crunching with the Total Row. 249
Chapter 16: Express Yourself with Formulas 263
Chapter 17: Take Charge with Action Queries 277
Part 5: Simple and Snazzy Reporting. 289
Chapter 18: Fast and Furious Automatic Reporting 291
Chapter 19: Professionally Designed Reports Made Easy 313
Chapter 20: Groups and Page Breaks, Headers and Footers 341
Chapter 21: Mailings to the Masses 363
Part 6: The Part of Tens 371
Chapter 22: Ten Common Problems 373
Chapter 23: Ten Uncommon Tips 385
Appendix A: Getting Help 393
Index 395