Introduction 1Part 1: Basic Training 5Chapter 1: Access 2019 Basic Training 7Chapter 2: Navigating the Access Workspace 25Chapter 3: Database Basics 43Part 2: Getting it All on the Table 61Chapter 4: Sounds Like a Plan 63Chapter 5: Table Tune Ups 75Chapter 6: Remodeling Your Data 93Chapter 7: Types, Masks, and Triggers 109Part 3: Data Management Mania 133Chapter 8: A Form for All Reasons 135Chapter 9: Importing and Exporting Data 153Chapter 10: Automatically Editing Data 167Chapter 11: Access and the Web 179Part 4: The Power of Questions 191Chapter 12: Finding, Filtering, and Sorting Your Data -- Fast 193Chapter 13: I Was Just Asking for Answers 209Chapter 14: I Want These AND Those OR Them 235Chapter 15: Number Crunching with the Total Row 243Chapter 16: Express Yourself with Formulas 255Chapter 17: Take Charge with Action Queries 269Part 5: Simple and Snazzy Reporting 281Chapter 18: Fast and Furious Automatic Reporting 283Chapter 19: Professionally Designed Reports Made Easy 303Chapter 20: Groups and Page Breaks, Headers and Footers 329Chapter 21: Mailings to the Masses 351Part 6: The Parts of Tens 359Chapter 22: Ten Common Problems 361Chapter 23: Ten Uncommon Tips 373Appendix A: Getting Help 381Index 383
Laurie Ann Ulrich has trained more than 20,000 people to make better, more creative use of their computers. She has created online courses and written more than 30 books.Ken Cook built and manages a computer consulting business that has helped users for over 20 years. He's an expert at creating Microsoft Office and Access database solutions and teaches online Access courses.