Expanded and updated edition to help data newcomers better understand Access's role in the world of data analysis and data science Your all-access guide to all things Access 2016 If you don't know a relational database from an isolationist table but still need to figure out how to organize and analyze your data Access 2016 For Dummies is for you. Introduction 1 Part I: Getting Started with Access 2016 5 Chapter 1: Access 2016 Basic Training 7 Chapter 2: Navigating the Access Workspace 27 Chapter 3: Database Basics 49 Chapter 4: Sounds Like a Plan 67 Part II: Getting It All on the Table 77 Chapter 5: Table Tune Ups 79 Chapter 6: Remodeling Your Data 97 Chapter 7: Types, Masks, and Triggers 113 Part III: Data Management Mania 137 Chapter 8: A Form for All Reasons 139 Chapter 9: Importing and Exporting Data 157 Chapter 10: Automatic Data Editing 171 Chapter 11: Access and the Web 183 Part IV: The Power of Questions 203 Chapter 12: Finding, Filtering, and Sorting Your Data Fast 205 Chapter 13: I Was Just Asking   . for Answers 221 Chapter 14: I Want These AND Those OR Them 247 Chapter 15: Number Crunching with the Total Row 255 Chapter 16: Express Yourself with Formulas 267 Chapter 17: Take Charge with Action Queries 281 Part V: Simple and Snazzy Reporting 291 Chapter 18: Fast and Furious Automatic Reporting 293 Chapter 19: Professionally Designed Reports Made Easy 315 Chapter 20: Headers and Footers and Groups, Oh My! 341 Chapter 21: Magical Mass Mailings 361 Part VI: More Power to You 369 Chapter 22: Analyze This! 371 Chapter 23: Steer Users in the Right Direction with Navigation Forms 381 Part VII: The Part of Tens 391 Chapter 24: Ten Common Problems 393 Chapter 25: Ten Uncommon Tips 403 Appendix A: Getting Help 409 Index 417