Microsoft 365 Access For Dummies
2nd Edition
Published on 13. February 2025
Book
Paperback/Softback
416 pages
978-1-394-29565-4 (ISBN)
Description
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.
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.
More details
Edition
2nd edition
Language
English
Place of publication
United States
Publishing group
John Wiley & Sons Inc
Dimensions
Height: 233 mm
Width: 188 mm
Thickness: 28 mm
Weight
762 gr
ISBN-13
978-1-394-29565-4 (9781394295654)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Laurie A. Ulrich | Ken Cook
Microsoft 365 Access For Dummies
E-Book
01/2025
2nd Edition
Wiley
€19.99
Available for download
Laurie A. Ulrich | Ken Cook
Microsoft 365 Access For Dummies
E-Book
01/2025
2nd Edition
Wiley
€19.99
Available for download
Previous edition
Laurie A. Ulrich
Access For Dummies
Book
02/2022
1st Edition
Wiley
€30.94
Article exhausted; check for reprint
Persons
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.
Ken Cook is an experienced database developer and author who has written on the subjects of Microsoft Access and Excel.
Content
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
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