Access For Dummies
- 5h 44m
- Ken Cook, Laurie A. Ulrich
- John Wiley & Sons (US)
- 2021
Become a database boss —and have fun doing it—with this accessible and easy-to-follow guide to Microsoft Access
Databases 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 it
Microsoft 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.
About the Author
Laurie Ann Ulrich is a professional author and trainer on all things technology. Along with recent editions of Access For Dummies, she’s also written books on Excel, Photoshop, and Dreamweaver.
Ken Cook is a professional database developer and author who has written on Access and Excel.
In this Book
-
Introduction
-
Access Basic Training
-
Navigating the Access Workspace
-
Database Basics
-
Sounds Like a Plan
-
Table Tune-Ups
-
Remodeling Your Data
-
Types, Masks, and Triggers
-
A Form for All Reasons
-
Importing and Exporting Data
-
Automatically Editing Data
-
Access and the Web
-
Finding, Filtering, and Sorting Your Data — Fast
-
I was Just Asking … for Answers
-
I Want These AND Those OR Them
-
Number Crunching with the Total Row
-
Express Yourself with Formulas
-
Take Charge with Action Queries
-
Fast and Furious Automatic Reporting
-
Professionally Designed Reports Made Easy
-
Groups and Page Breaks, Headers and Footers
-
Mailings to the Masses
-
Ten Common Problems
-
Ten Uncommon Tips
