Bookstore

Become a database boss --and have fun doing it--with this accessible and easy-to-follow guide to Microsoft AccessDatabases hold the key to organizing and accessing all your data in one convenient place. And you don't have to be a data science wizard to build, populate, and organize your own. With Microsoft Access For Dummies, you'll learn to use the latest version of Microsoft's Access software to power your database needs.Need to understand the essentials before diving in? Check out our Basic Training in Part 1 where we teach you how to navigate the Access workspace and explore the foundations of databases.Ready for more advanced tutorials? Skip right to the sections on Data Management, Queries, or Reporting where we walk you through Access's more sophisticated capabilities. Not sure if you have Access via Office 2021 or Office 365? No worries - this book covers Access now matter how you access it.The book also shows you how to:* Handle the most common problems that Access users encounter* Import, export, and automatically edit data to populate your next database* Write powerful and accurate queries to find exactly what you're looking for, exactly when you need itMicrosoft Access For Dummies is the perfect resource for anyone expected to understand, use, or administer Access databases at the workplace, classroom, or any other data-driven destination.

Access For Dummies

Introduction 1Part 1: Basic Training 5Chapter 1: Access Basic Training 7Chapter 2: Navigating the Access Workspace 25Chapter 3: Database Basics 43Part 2: Getting It All on the Table 63Chapter 4: Sounds Like a Plan 65Chapter 5: Table Tune-Ups 77Chapter 6: Remodeling Your Data 95Chapter 7: Types, Masks, and Triggers 111Part 3: Data Management Mania 135Chapter 8: A Form for All Reasons 137Chapter 9: Importing and Exporting Data 157Chapter 10: Automatically Editing Data 171Chapter 11: Access and the Web 183Part 4: The Power of Questions 197Chapter 12: Finding, Filtering, and Sorting Your Data -- Fast 199Chapter 13: I Was Just Asking for Answers 215Chapter 14: I Want These AND Those OR Them 241Chapter 15: Number Crunching with the Total Row 249Chapter 16: Express Yourself with Formulas 263Chapter 17: Take Charge with Action Queries 277Part 5: Simple and Snazzy Reporting 289Chapter 18: Fast and Furious Automatic Reporting 291Chapter 19: Professionally Designed Reports Made Easy 313Chapter 20: Groups and Page Breaks, Headers and Footers 341Chapter 21: Mailings to the Masses 363Part 6: The Part of Tens 371Chapter 22: Ten Common Problems 373Chapter 23: Ten Uncommon Tips 385Appendix A: Getting Help 393Index 395