Microsoft 365 Access For Dummies

Join the millions of people already using Microsoft Access and become a database power-user in no time!

In the newly revised edition of Microsoft Access For Dummies, professional database developer and Access extraordinaire Laurie Ulrich-Fuller walks you through the ins-and-outs of one of the world's most popular database platforms. This is the perfect beginner's guide to Microsoft Access, showing you how to create databases, extract data, create reports, and more. The author demonstrates a ton of tips, tricks, and best practices you can use immediately to create, maintain, and improve your databases. You'll also find:

• Updates outlining edge browser controls in forms
• Step-by-step guides explaining how to import, export, and edit data
• Easy-to-follow query-writing tutorials to help you find the exact data you're looking for when you need it

Whether you're a database novice or a data science whiz, Microsoft Access For Dummies has the info you need to supercharge your database skills. It's the perfect, how-to guide to get you up-to-speed on everything you need to know to get started with Microsoft's world-famous database app.

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

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.

The best A-to-Z guide for working with Microsoft 365^® Access^™ databases

In Microsoft 365^® Access™ 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