Access
For Dummies
by Laurie A. Ulrich and Ken
Cook John Wiley & Sons © 2021
Book: 432 pages
Table of Contents
Part
1 - Basic Training
Chapter
1Access Basic Training
What is Access Good for,
Anyway?
How Access Works and How
You Work with it
Chapter
2Navigating the Access Workspace
Working with Onscreen
Tools in Access
Customizing the Access
Workspace
Navigating Access with the
Alt Key
Chapter
3Database Basics
Choosing between Flat and
Relational Databases
Part
2 - Getting it All on the Table
Chapter
4Sounds Like a Plan
Building Tables in Design
View
Chapter
5Table Tune-Ups
Chapter
6Remodeling Your Data
Chapter
7Types, Masks, and Triggers
Give Your Fingers a Mini
Vacation by Default
Part
3 - Data Management Mania
Chapter
8A Form for All Reasons
Chapter
9Importing and Exporting Data
Retrieving Data from other
Sources
Chapter
10Automatically Editing Data
Creating Consistent
Corrections
Using Queries to Automate
the Editing Process
Chapter
11Access and the Web
Using the Access Web
Browser Control
Part
4 - The Power of Questions
Chapter
12Finding, Filtering, and Sorting Your Data — Fast
Sorting Alphabetically and
Numerically
Chapter
13I was Just Asking … for Answers
Simple (Yet Potent) Filter
and Sort Tools
Getting Your Feet Wet with
Ad Hoc Queries
Chapter
14I Want These AND Those OR Them
Combining AND with OR and
OR with AND
Chapter
15Number Crunching with the Total Row
Adding the Total Row to
Your Queries
Giving the Total Row a
Workout
Creating Your Own Top-Ten
List
Choosing the Right Field
for the Summary Instruction
Chapter
16Express Yourself with Formulas
Chapter
17Take Charge with Action Queries
Part
5 - Simple and Snazzy Reporting
Chapter
18Fast and Furious Automatic Reporting
Quick and Not-S0-Dirty
Automatic Reporting
Beauty is Only Skin
(Report) Deep
Chapter
19Professionally Designed Reports Made Easy
Chapter
20Groups and Page Breaks, Headers and Footers
A Place for Everything and
Everything in its Place
Chapter
21Mailings to the Masses
Massive Mailings with the
Label Wizard
Part
6 - The Part of Tens
Chapter
22Ten Common Problems
You Type 73.725, but it
Changes to 74
Where’s That Word I Just
Typed?
You Run a Query, but the
Results Aren’t What You Expect
The Dreaded Parameter
Dialog Box
Your Database File is
Ginormous
You Get a Mess When
Importing Your Spreadsheet
We’re Sorry; Your Database
File is Corrupt
Chapter
23Ten Uncommon Tips
Document Everything as If
Your Life Depended on it
Keep Your Fields as Small
as Possible
Use Number Fields for Real
Numbers
Use Understandable Names
to Keep Things Simple
Get Organized and Stay
Organized
There’s No Shame in Asking
for Help
Appendix
AGetting Help
Use of
