Microsoft 365 Access For Dummies

by Laurie A. Ulrich, Ken Cook

Overview

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.

Product Details

ISBN-13:	9781394295654
Publisher:	Wiley
Publication date:	02/11/2025
Edition description:	2nd ed.
Pages:	416
Product dimensions:	9.10(w) x 7.40(h) x 0.90(d)

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.

Table 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