Contents at a Glance
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
www.allitebooks.