Home Page Icon
Home Page
Table of Contents for
Access 2016® For Dummies®
Close
Access 2016® For Dummies®
by Ken Cook, Laurie Ulrich Fuller
Access 2016 For Dummies
Cover
Cover
Introduction
About This Book
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Part I: Getting Started with Access 2016
Chapter 1: Access 2016 Basic Training
What Is Access Good For, Anyway?
What’s New in Access 2016?
Reach out with SharePoint
How Access Works and How You Work with It
Now What?
Chapter 2: Navigating the Access Workspace
Diving Right In
Working with Onscreen Tools in Access
Customizing the Access Workspace
Mousing Around
Navigating Access with the Alt Key
Chapter 3: Database Basics
Database Lingo
Field Types and Uses
Choosing Between Flat and Relational Databases
Building a Database
Adding and Removing Tables
Chapter 4: Sounds Like a Plan
Planning Your Database Tables
Building Tables in Design View
Part II: Getting It All on the Table
Chapter 5: Table Tune Ups
The Primary Key to Success
Making Tables Get Along
Building Table Relationships
Indexing for Faster Queries
Chapter 6: Remodeling Your Data
Opening a Table for Editing
Inserting Records and Fields
Modifying Field Content
Name-Calling
Turn Uh-Oh! into Yee-Hah!
Chapter 7: Types, Masks, and Triggers
Access Table Settings
Field Data Formats
Gaining Control of Data Entry
Give Your Fingers a Mini Vacation by Default
Part III: Data Management Mania
Chapter 8: A Form for All Reasons
Generating Forms
Customizing Form Parts
Managing Data in Form View
Chapter 9: Importing and Exporting Data
Retrieving Data from Other Sources
Hit the Road, Data
Chapter 10: Automatic Data Editing
Please Read This First!
Creating Consistent Corrections
Using Queries to Automate the Editing Process
Chapter 11: Access and the Web
How Access Works with the Web
Understanding Office 365
Connect Office 365 to Access 2016
Meet the Custom Web App
Click! Using Hyperlinks in Your Desktop Access Database
Part IV: The Power of Questions
Chapter 12: Finding, Filtering, and Sorting Your Data — Fast
Using the Find Command
Sorting from A to Z or Z to A
Fast and Furious Filtering
Chapter 13: I Was Just Asking … for Answers
Simple (Yet Potent) Filter and Sort Tools
Select Queries
Getting Your Feet Wet with Ad Hoc Queries
Chapter 14: I Want These AND Those OR Them
Working with AND and/or OR
Combining AND with OR and OR with AND
Chapter 15: Number Crunching with the Total Row
Say Hello to the Total Row
Adding the Total Row to Your Queries
Working Out the Total Row
Creating Your Own Top-Ten List
Choosing the Right Field for the Summary Instruction
Chapter 16: Express Yourself with Formulas
A Simple Calculation
Complex Calculations
Hooray for Expression Builder
Chapter 17: Take Charge with Action Queries
Easy Update
Add Records in a Flash
Quick Cleanup
Part V: Simple and Snazzy Reporting
Chapter 18: Fast and Furious Automatic Reporting
Quick and Not-S0-Dirty Automatic Reporting
Previewing Your Report
Beauty Is Only Skin (Report) Deep
Chapter 19: Professionally Designed Reports Made Easy
Report Repairs
Report Organization
Formatting Stuff
Sneaking a Peek
Getting a Themes Makeover
Adding More Design Elements
Chapter 20: Headers and Footers and Groups, Oh My!
A Place for Everything and Everything in Its Place
Customizing Properties
Chapter 21: Magical Mass Mailings
Massive Mailings with the Label Wizard
Part VI: More Power to You
Chapter 22: Analyze This!
From Flat File to Relational Tables with Table Analyzer
Record Database Object Information with the Database Documenter
Improve Database Performance without Steroids
Chapter 23: Steer Users in the Right Direction with Navigation Forms
The Comings and Goings of a Navigation Form
Am I in the Right Place? Testing Navigation Forms
Maintaining the Navigation Form
Displaying the Navigation Form at Startup
Part VII: The Part of Tens
Chapter 24: Ten Common Problems
That’s Just Not Normal
You Type 73.725, but It Changes to 74
The Words They Are A-Changing
Was There and Now It’s Gone
You Run a Query, but the Results Aren’t What You Expect
The Dreaded Parameter Dialog Box
The Slowest Database in Town
Your Database File Is as Big as a Whale
You Get a Mess When Importing Your Spreadsheet
We’re Sorry; Your Database File Is Corrupt
Chapter 25: Ten Uncommon Tips
Document Everything as Though One Day You’ll be Questioned by the FBI
Keep Your Fields as Small as Possible
Use Number Fields for Real Numbers
Validate Your Data
Use Understandable Names to Keep Things Simple
Delete with Great Caution
Backup, Backup, Backup
Think, Think, and Think Again
Get Organized and Stay Organized
There’s No Shame in Asking for Help
Appendix A: Getting Help
Asking Access for Help
Online Help
Who’s Our Next Caller?
About the Authors
Cheat Sheet
Advertisement Page
Connect with Dummies
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Introduction
Access 2016® For Dummies®
Visit
www.dummies.com/cheatsheet/access2016
to view this book's cheat sheet.
Table of Contents
Cover
Introduction
About This Book
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Part I: Getting Started with Access 2016
Chapter 1: Access 2016 Basic Training
What Is Access Good For, Anyway?
What’s New in Access 2016?
Reach out with SharePoint
How Access Works and How You Work with It
Now What?
Chapter 2: Navigating the Access Workspace
Diving Right In
Working with Onscreen Tools in Access
Customizing the Access Workspace
Mousing Around
Navigating Access with the Alt Key
Chapter 3: Database Basics
Database Lingo
Field Types and Uses
Choosing Between Flat and Relational Databases
Building a Database
Adding and Removing Tables
Chapter 4: Sounds Like a Plan
Planning Your Database Tables
Building Tables in Design View
Part II: Getting It All on the Table
Chapter 5: Table Tune Ups
The Primary Key to Success
Making Tables Get Along
Building Table Relationships
Indexing for Faster Queries
Chapter 6: Remodeling Your Data
Opening a Table for Editing
Inserting Records and Fields
Modifying Field Content
Name-Calling
Turn Uh-Oh! into Yee-Hah!
Chapter 7: Types, Masks, and Triggers
Access Table Settings
Field Data Formats
Gaining Control of Data Entry
Give Your Fingers a Mini Vacation by Default
Part III: Data Management Mania
Chapter 8: A Form for All Reasons
Generating Forms
Customizing Form Parts
Managing Data in Form View
Chapter 9: Importing and Exporting Data
Retrieving Data from Other Sources
Hit the Road, Data
Chapter 10: Automatic Data Editing
Please Read This First!
Creating Consistent Corrections
Using Queries to Automate the Editing Process
Chapter 11: Access and the Web
How Access Works with the Web
Understanding Office 365
Connect Office 365 to Access 2016
Meet the Custom Web App
Click! Using Hyperlinks in Your Desktop Access Database
Part IV: The Power of Questions
Chapter 12: Finding, Filtering, and Sorting Your Data — Fast
Using the Find Command
Sorting from A to Z or Z to A
Fast and Furious Filtering
Chapter 13: I Was Just Asking … for Answers
Simple (Yet Potent) Filter and Sort Tools
Select Queries
Getting Your Feet Wet with Ad Hoc Queries
Chapter 14: I Want These AND Those OR Them
Working with AND and/or OR
Combining AND with OR and OR with AND
Chapter 15: Number Crunching with the Total Row
Say Hello to the Total Row
Adding the Total Row to Your Queries
Working Out the Total Row
Creating Your Own Top-Ten List
Choosing the Right Field for the Summary Instruction
Chapter 16: Express Yourself with Formulas
A Simple Calculation
Complex Calculations
Hooray for Expression Builder
Chapter 17: Take Charge with Action Queries
Easy Update
Add Records in a Flash
Quick Cleanup
Part V: Simple and Snazzy Reporting
Chapter 18: Fast and Furious Automatic Reporting
Quick and Not-S0-Dirty Automatic Reporting
Previewing Your Report
Beauty Is Only Skin (Report) Deep
Chapter 19: Professionally Designed Reports Made Easy
Report Repairs
Report Organization
Formatting Stuff
Sneaking a Peek
Getting a Themes Makeover
Adding More Design Elements
Chapter 20: Headers and Footers and Groups, Oh My!
A Place for Everything and Everything in Its Place
Customizing Properties
Chapter 21: Magical Mass Mailings
Massive Mailings with the Label Wizard
Part VI: More Power to You
Chapter 22: Analyze This!
From Flat File to Relational Tables with Table Analyzer
Record Database Object Information with the Database Documenter
Improve Database Performance without Steroids
Chapter 23: Steer Users in the Right Direction with Navigation Forms
The Comings and Goings of a Navigation Form
Am I in the Right Place? Testing Navigation Forms
Maintaining the Navigation Form
Displaying the Navigation Form at Startup
Part VII: The Part of Tens
Chapter 24: Ten Common Problems
That’s Just Not Normal
You Type 73.725, but It Changes to 74
The Words They Are A-Changing
Was There and Now It’s Gone
You Run a Query, but the Results Aren’t What You Expect
The Dreaded Parameter Dialog Box
The Slowest Database in Town
Your Database File Is as Big as a Whale
You Get a Mess When Importing Your Spreadsheet
We’re Sorry; Your Database File Is Corrupt
Chapter 25: Ten Uncommon Tips
Document Everything as Though One Day You’ll be Questioned by the FBI
Keep Your Fields as Small as Possible
Use Number Fields for Real Numbers
Validate Your Data
Use Understandable Names to Keep Things Simple
Delete with Great Caution
Backup, Backup, Backup
Think, Think, and Think Again
Get Organized and Stay Organized
There’s No Shame in Asking for Help
Appendix A: Getting Help
Asking Access for Help
Online Help
Who’s Our Next Caller?
About the Authors
Cheat Sheet
Advertisement Page
Connect with Dummies
End User License Agreement
Guide
Cover
Table of Contents
Begin Reading
Pages
ii
1
2
3
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
247
248
249
250
251
252
253
254
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
281
282
283
284
285
286
287
288
289
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
441
443
444
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset