Access 2013 For Dummies Book

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