Table of Contents
Introduction 1
Part I: Getting Started with Access 2013 9
Chapter 1: Access 2013 Basic Training 11
Chapter 2: Navigating the Access Workspace 33
Chapter 3: Database Basics 55
Part II: Setting the Table 73
Chapter 4: Table Tune Ups 75
Chapter 5: Remodeling Your Data 91
Chapter 6: Types, Masks, and Triggers 109
Part III: Data Management Mania 131
Chapter 7: A Form for All Reasons 133
Chapter 8: Importing and Exporting Data 147
Chapter 9: Automatic Data Editing 159
Chapter 10: Access and the Web 171
Part IV: Ask Your Data, and Ye Shall Receive Answers 193
Chapter 11: Finding, Filtering, and Sorting Your Data — Fast 195
Chapter 12: I Was Just Asking for Answers 211
Chapter 13: I Want These AND Those OR Them 237
Chapter 14: Number Crunching with the Total Row 245
Chapter 15: Express Yourself with Formulas 257
Chapter 16: Take Charge with Action Queries 271
Part V: Simple and Snazzy Reporting 281
Chapter 17: Fast and Furious Automatic Reporting 283
Chapter 18: Professionally Designed Reports Made Easy 305
Chapter 19: Headers and Footers and Groups, Oh My! 331
Chapter 20: Magical Mass Mailings 353
Part VI: More Power to You 361
Chapter 21: Analyze This! 363
Chapter 22: Steer Users in the Right Direction with Navigation Forms 375
Part VII: The Part of Tens 383
Chapter 23: Ten Common Problems 385
Chapter 24: Ten Uncommon Tips 397
Appendix: Getting Help 405
Index 413