Read more
The best A-to-Z guide for working with Microsoft 365® Access(TM) databases In
Microsoft 365® Access(TM) For Dummies, veteran database educators bring you up to speed on one of the most popular database applications on the market today. You'll learn how to create, maintain, troubleshoot, and secure your very own database on Microsoft Access. You'll also discover how to create informative and beautiful reports, forms to help speed up and improve data entry, and queries to bring any data to your screen in seconds. From hard-to-find and useful keyboard shortcuts to complete guides to the Access interface, this book has absolutely everything you need to get started today.
Inside... - Navigate the Access interface
- Import and export data
- Create stunning data visualizations
- Get the answers you need from your data
- Learn useful hotkeys, shortcuts, and tips
- Construct powerful data queries
- Build your database on the cloud
- Draft compelling data reports
List of contents
Introduction 1
Part 1: Basic Training 5 Chapter 1: Access Basics 7
Chapter 2: Finding Your Way in the Access Workspace 25
Chapter 3: Database Basics 43
Part 2: Getting It All on the Table 63 Chapter 4: Sounds Like a Plan 65
Chapter 5: Table Tune-Ups 77
Chapter 6: Remodeling Your Data 95
Chapter 7: Types, Masks, and Triggers 111
Part 3: Data Management Mania 137 Chapter 8: A Form for All Reasons 139
Chapter 9: Importing and Exporting Data 159
Chapter 10: Automatically Editing Data 173
Chapter 11: Access and the Web 185
Part 4: The Power of Questions 199 Chapter 12: Finding, Filtering, and Sorting Your Data - Fast 201
Chapter 13: I Was Just Asking for Answers 219
Chapter 14: I Want These AND Those OR Them 245
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 5: Simple and Snazzy Reporting 293 Chapter 18: Fast and Furious Automatic Reporting 295
Chapter 19: Professionally Designed Reports Made Easy 313
Chapter 20: Groups and Page Breaks, Headers and Footers 333
Part 6: The Part of Tens 351 Chapter 21: Ten Common Problems 353
Chapter 22: Ten Uncommon Tips 365
Appendix A: Getting Help 373
Index 375
About the author
Laurie A. Ulrich is a professional author and technology educator who has also written books about Microsoft Office, including Excel, and about Adobe Photoshop.
Ken Cook is an experienced database developer and author who has written on the subjects of Microsoft Access and Excel.
