And
the
Easiest
Way
To
Do
Them
2
1
A
Final
Word
(or
Two)
3
2
2
Microsoft
Access
97
Database
Basics
5
14
Understanding
Access
Databases
6
2
Starting
Microsoft
Access
97
8
1
Viewing
the
Access
Window
10
1
Working
with
Menus
and
Toolbars
11
1
Working
with
Dialog
Boxes
12
1
Getting
Help
Using
the
Help
Pointer
13
1
Getting
Help
Using
the
Help
Dialog
Box
14
2
Getting
Help
Using
the
Office
Assistant
16
2
Closing
a
Database
and
Exiting
Access
18
1
3
Working
with
Database
Tables
19
14
Opening
and
Closing
Tables
20
2
Viewing
Multiple
Tables
22
1
Scrolling
Through
a
Table
24
1
Freezing
an
Unfreezing
Columns
26
1
Hiding
and
Displaying
Columns
27
1
Changing
the
Size
of
Rows
and
Columns
28
2
Moving
to
a
Specific
Record
in
a
Table
30
3
4
Locating
and
Viewing
Specific
Records
33
12
Searching
for
Text
in
Records
34
2
Changing
the
Order
of
Records
Displayed
in
a
Table
36
2
Arranging
Records
Based
on
Multiple
Fields
38
1
Finding
and
Replacing
Text
in
a
Table
39
1
Viewing
Specific
Records
Using
a
Filter
40
1
Saving
a
Customized
Filter
41
1
Creating
More
Complex
Filters
Using
a
Form
42
3
5
Retrieving
Records
from
a
Database
45
12
Understanding
the
Different
Types
of
Queries
46
1
Creating
a
Query
from
Scratch
47
1
Creating
a
Query
Using
the
Query
Wizard
48
2
Changing
the
Fields
in
a
Query
50
2
Retrieving
Only
the
Records
You
Want
52
2
Creating
a
Query
to
Summarize
Values
54
2
Displaying
a
Query
in
Design
View
56
1
6
Putting
Queries
to
Work
57
14
Comparing
Values
in
Section
Criteria
58
2
Calculating
Values
in
a
Query
60
1
Changing
the
Appearance
of
Values
61
1
Creating
a
Query
to
Add
Records
62
2
Creating
a
Query
to
Create
a
New
Table
64
2
Creating
a
Query
to
Delete
Records
66
1
Creating
a
Query
to
Update
Records
67
1
Speeding
Up
Searches
with
Indexing
68
2
Creating
Multiple
Field
Indexing
70
1
7
Creating
a
Database
71
18
Creating
a
Database
with
a
Wizard
74
2
Creating
Tables
in
a
Database
76
1
Working
in
Design
View
77
1
Creating
Tables
the
Easy
Way
78
2
Assigning
a
Primary
Key
80
1
Assigning
Table
Relationships
in
the
Table
Wizard
81
1
Displaying
a
Table
in
Design
View
82
1
Specifying
Data
Types
83
1
Adding,
Deleting,
and
Changing
the
Order
of
Fields
84
2
Creating
a
Custom
Table
86
2
Setting
Field
Properties
88
1
8
Maintaining
Database
Information
89
20
Entering
Records
in
a
Table
90
2
Copying
and
Pasting
Records
94
2
Entering
Data
More
Accurately
with
AutoCorrect
96
2
Editing
Text
in
Records
98
1
Checking
Your
Spelling
100
2
Getting
Data
from
Other
Programs
102
2
Exporting
Data
to
Other
Programs
104
2
Merging
Data
with
Word
106
2
Analyzing
Data
with
Excel
108
1
9
Creating
Reports
109
20
Exploring
Different
Ways
to
Create
Reports
110
1
Modifying
a
Report
in
Design
View
111
1
Creating
a
Report
the
Easy
Way
112
2
Creating
a
Report
Using
the
Report
Wizard
114
2
Working
with
Report
Controls
116
2
Changing
the
Spacing
in
a
Report
118
2
Creating
Calculations
in
a
Report
120
2
Grouping
Records
in
a
Report
122
2
Previewing
a
Report
124
2
Inserting
Information
in
Headers
and
Footers
126
1
Creating
Access
Forms
130
1
Working
with
Controls
131
1
Creating
a
Form
the
Easy
Way
132
2
Creating
a
Custom
Form
134
2
Creating
a
Form
from
Scratch
136
1
Adding
and
Removing
Controls
137
1
Displaying
a
Form
in
Design
View
138
1
Modifying
a
Form
in
Design
View
139
1
Using
Toolbox
Buttons
and
Controls
140
2
Sizing
and
Moving
Controls
in
a
Form
142
2
Using
the
Control
Wizard
144
3
11
Improving
the
Appearance
of
Forms
and
Reports
147
10
Identifying
Ways
to
Enhance
Forms
and
Reports
148
2
Changing
the
Appearance
of
Text
150
1
Formatting
a
Form
or
Report
the
Easy
Way
151
1
Adding
Lines
and
Borders
152
1
Changing
the
Thickness
of
Lines
and
Borders
153
1
Applying
Special
Effects
to
Controls
156
1
12
Adding
Graphics
to
Forms
and
Reports
157
20
Sharing
Information
Among
Documents
158
1
Copying
and
Pasting
Objects
159
1
Inserting
a
New
Object
160
2
Inserting
an
Object
from
a
File
162
2
Inserting
a
Picture
164
2
Moving
and
Resizing
an
Object
167
1
Inserting
Excel
Charts
and
Worksheets
168
2
Inserting
a
Graph
Chart
172
2
Selecting
a
Chart
Type
174
2
13
Accessing
the
Internet
177
18
Inserting
Hyperlinks
in
Forms
and
Reports
178
2
Inserting
Hyperlinks
in
Table
Fields
180
1
Using
the
Web
Toolbar
181
1
Jumping
to
Hyperlinked
Documents
182
2
Navigating
Hyperlinks
184
2
Searching
for
Information
on
the
Web
186
2
Returing
to
Favorites
188
1
Getting
Media
Clips
from
the
Web
189
1
Inserting
ActiveX
Controls
190
2
Publishing
to
the
World
Wide
Web
192
2
Accessing
Microsoft
on
the
Web
194
1
14
Maximizing
Database
Performance
195
22
Working
with
Multiple
Tables
196
1
Understanding
Referential
Integrity
197
1
Defining
Table
Relationships
198
2
Setting
Up
Accounts
and
Permissions
200
2
Securing
a
Database
202
2
Reducing
Database
Size
204
2
Replicating
a
Database
206
2
Repairing
a
Database
208
1
Adding
Functionality
with
Add-ins
209
1
Using
Previous-Version
Access
Databases
212
2
Analyzing
a
Database
214
2
Documenting
Objects
216
1
15
Customizing
Access
217
16
Creating
a
Shortcut
on
the
Desktop
218
1
Customizing
the
Menu
Bar
219
1
Customizing
Toolbars
220
2
Customizing
a
Database
Startup
222
2
Specifying
Keyboard
and
Viewing
Options
224
1
Learning
About
Macros
225
1
Running
and
Testing
a
Macro
228
2
Adding
a
Macro
to
a
Toolbar
230
3