|
|
|
1 | (4) |
|
|
|
1 | (1) |
|
|
|
2 | (1) |
|
|
|
2 | (1) |
|
|
|
3 | (1) |
|
|
|
3 | (2) |
| Part I: Getting Started with Access 2016 |
|
5 | (72) |
|
Chapter 1 Access 2016 Basic Training |
|
|
7 | (20) |
|
What Is Access Good For, Anyway? |
|
|
8 | (9) |
|
|
|
8 | (1) |
|
|
|
9 | (1) |
|
Creating databases with multiple tables |
|
|
9 | (3) |
|
Databases with user forms |
|
|
12 | (2) |
|
Databases that require special reporting |
|
|
14 | (3) |
|
What's New in Access 2016? |
|
|
17 | (1) |
|
Reach out with SharePoint |
|
|
18 | (1) |
|
How Access Works and How You Work with It |
|
|
19 | (6) |
|
|
|
19 | (2) |
|
Selecting a starting point |
|
|
21 | (4) |
|
|
|
25 | (2) |
|
Chapter 2 Navigating the Access Workspace |
|
|
27 | (22) |
|
|
|
29 | (2) |
|
Working with Onscreen Tools in Access |
|
|
31 | (6) |
|
|
|
32 | (2) |
|
|
|
34 | (1) |
|
The File tab and Quick Access tools |
|
|
35 | (1) |
|
Accessing panes, panels, and context-sensitive tools |
|
|
36 | (1) |
|
Customizing the Access Workspace |
|
|
37 | (8) |
|
Repositioning the Quick Access Toolbar |
|
|
37 | (1) |
|
Adding buttons to the Quick Access Toolbar |
|
|
38 | (3) |
|
Removing buttons from the Quick Access Toolbar |
|
|
41 | (1) |
|
|
|
42 | (1) |
|
|
|
43 | (2) |
|
|
|
45 | (1) |
|
Navigating Access with the Alt Key |
|
|
46 | (3) |
|
Chapter 3 Database Basics |
|
|
49 | (18) |
|
|
|
49 | (3) |
|
Data, no matter how you pronounce it |
|
|
50 | (1) |
|
Fields of dreams (or data) |
|
|
50 | (1) |
|
|
|
51 | (1) |
|
|
|
51 | (1) |
|
|
|
52 | (1) |
|
|
|
52 | (5) |
|
Choosing Between Flat and Relational Databases |
|
|
57 | (2) |
|
|
|
57 | (1) |
|
Tables that mix and mingle |
|
|
57 | (2) |
|
|
|
59 | (4) |
|
Adding and Removing Tables |
|
|
63 | (4) |
|
|
|
63 | (2) |
|
Oops, I didn't mean to do that |
|
|
65 | (2) |
|
Chapter 4 Sounds Like a Plan |
|
|
67 | (10) |
|
Planning Your Database Tables |
|
|
67 | (6) |
|
|
|
67 | (1) |
|
|
|
68 | (2) |
|
Grouping fields into tables |
|
|
70 | (1) |
|
|
|
71 | (2) |
|
Building Tables in Design View |
|
|
73 | (6) |
|
|
|
73 | (2) |
|
|
|
75 | (2) |
| Part II: Getting It Alt on the Table |
|
77 | (60) |
|
|
|
79 | (18) |
|
The Primary Key to Success |
|
|
79 | (4) |
|
The lowdown on primary keys |
|
|
80 | (1) |
|
|
|
81 | (2) |
|
|
|
83 | (2) |
|
|
|
83 | (1) |
|
|
|
83 | (2) |
|
Building Table Relationships |
|
|
85 | (6) |
|
|
|
86 | (1) |
|
|
|
86 | (5) |
|
Indexing for Faster Queries |
|
|
91 | (6) |
|
|
|
92 | (2) |
|
Adding and removing indexes |
|
|
94 | (3) |
|
Chapter 6 Remodeling Your Data |
|
|
97 | (16) |
|
Opening a Table for Editing |
|
|
98 | (3) |
|
Inserting Records and Fields |
|
|
101 | (6) |
|
|
|
101 | (1) |
|
|
|
102 | (4) |
|
|
|
106 | (1) |
|
|
|
107 | (1) |
|
|
|
108 | (4) |
|
|
|
108 | (2) |
|
|
|
110 | (2) |
|
Turn Uh-Oh! into Yee-Hah! |
|
|
112 | (1) |
|
Chapter 7 Types, Masks, and Triggers |
|
|
113 | (24) |
|
|
|
113 | (3) |
|
|
|
116 | (8) |
|
|
|
117 | (2) |
|
Number and currency fields |
|
|
119 | (3) |
|
|
|
122 | (1) |
|
|
|
123 | (1) |
|
Gaining Control of Data Entry |
|
|
124 | (10) |
|
You really need to put a mask on those fields |
|
|
124 | (7) |
|
To require or not to require |
|
|
131 | (1) |
|
Making your data toe the line with validation |
|
|
132 | (2) |
|
Give Your Fingers a Mini Vacation by Default |
|
|
134 | (3) |
| Part III: Data Management Mania |
|
137 | (66) |
|
Chapter 8 A Form for All Reasons |
|
|
139 | (18) |
|
|
|
139 | (8) |
|
Keeping it simple: Form tools |
|
|
141 | (2) |
|
Granting most wishes: The Form Wizard |
|
|
143 | (4) |
|
|
|
147 | (7) |
|
|
|
147 | (1) |
|
|
|
147 | (2) |
|
|
|
149 | (5) |
|
Managing Data in Form View |
|
|
154 | (3) |
|
Navigating and finding records |
|
|
154 | (1) |
|
Saving, clearing, and deleting |
|
|
155 | (2) |
|
Chapter 9 Importing and Exporting Data |
|
|
157 | (14) |
|
Retrieving Data from Other Sources |
|
|
158 | (8) |
|
|
|
158 | (3) |
|
|
|
161 | (5) |
|
|
|
166 | (5) |
|
|
|
166 | (1) |
|
Exporting table or query data |
|
|
166 | (3) |
|
Exporting a Report to PDF |
|
|
169 | (2) |
|
Chapter 10 Automatic Data Editing |
|
|
171 | (12) |
|
|
|
171 | (3) |
|
Creating Consistent Corrections |
|
|
174 | (2) |
|
Using Queries to Automate the Editing Process |
|
|
176 | (7) |
|
Looking for duplicate records |
|
|
177 | (1) |
|
Running the Find Duplicates Query Wizard |
|
|
178 | (5) |
|
Chapter 11 Access and the Web |
|
|
183 | (20) |
|
How Access Works with the Web |
|
|
183 | (1) |
|
|
|
184 | (1) |
|
Connect Office 365 to Access 2016 |
|
|
185 | (1) |
|
|
|
186 | (11) |
|
Adding new tables to your web app |
|
|
189 | (1) |
|
Uploading an existing table to your web app |
|
|
190 | (1) |
|
|
|
191 | (1) |
|
|
|
192 | (2) |
|
|
|
194 | (1) |
|
|
|
195 | (1) |
|
|
|
196 | (1) |
|
Linking to a web app from an Access desktop database |
|
|
196 | (1) |
|
Click! Using Hyperlinks in Your Desktop Access Database |
|
|
197 | (8) |
|
Adding a Hyperlink field to your desktop database table |
|
|
198 | (1) |
|
Fine-tuning your hyperlinks |
|
|
199 | (2) |
|
|
|
201 | (2) |
| Part IV: The Power of Questions |
|
203 | (88) |
|
Chapter 12 Finding, Filtering, and Sorting Your Data - Fast |
|
|
205 | (16) |
|
|
|
206 | (5) |
|
|
|
206 | (2) |
|
Shifting Find into high gear |
|
|
208 | (3) |
|
Sorting from A to Z or Z to A |
|
|
211 | (1) |
|
Sorting by a single field |
|
|
211 | (1) |
|
Sorting on more than one field |
|
|
211 | (1) |
|
Fast and Furious Filtering |
|
|
212 | (9) |
|
Filtering by a field's content |
|
|
213 | (1) |
|
|
|
214 | (2) |
|
|
|
216 | (3) |
|
|
|
219 | (1) |
|
Filter by excluding selection |
|
|
219 | (2) |
|
Chapter 13 I Was Just Asking ... for Answers |
|
|
221 | (26) |
|
Simple (Yet Potent) Filter and Sort Tools |
|
|
222 | (9) |
|
|
|
223 | (2) |
|
Fact-finding with fun, fast filtering |
|
|
225 | (1) |
|
Here's the "advanced" part |
|
|
225 | (6) |
|
|
|
231 | (8) |
|
Solid relationships are the key to getting it all (from your tables) |
|
|
232 | (1) |
|
|
|
233 | (6) |
|
Getting Your Feet Wet with Ad Hoc Queries |
|
|
239 | (8) |
|
Adding the finishing touches |
|
|
242 | (3) |
|
|
|
245 | (1) |
|
|
|
245 | (2) |
|
Chapter 14 I Want These AND Those OR Them |
|
|
247 | (8) |
|
Working with AND and/or OR |
|
|
248 | (5) |
|
|
|
249 | (1) |
|
Using multiple levels of AND |
|
|
250 | (2) |
|
Establishing criteria with OR |
|
|
252 | (1) |
|
Combining AND with OR and OR with AND |
|
|
253 | (2) |
|
Chapter 15 Number Crunching with the Total Row |
|
|
255 | (12) |
|
Say Hello to the Total Row |
|
|
255 | (2) |
|
Adding the Total Row to Your Queries |
|
|
257 | (1) |
|
Working Out the Total Row |
|
|
258 | (6) |
|
Putting it together with Group By |
|
|
258 | (2) |
|
Well, that certainly sums it up |
|
|
260 | (1) |
|
|
|
261 | (2) |
|
Narrowing the results with Where |
|
|
263 | (1) |
|
Creating Your Own Top-Ten List |
|
|
264 | (1) |
|
Choosing the Right Field for the Summary Instruction |
|
|
265 | (2) |
|
Chapter 16 Express Yourself with Formulas |
|
|
267 | (14) |
|
|
|
268 | (2) |
|
|
|
270 | (6) |
|
|
|
270 | (1) |
|
Using one calculation in another |
|
|
271 | (1) |
|
Using parameter queries to ask for help |
|
|
272 | (2) |
|
"Adding" words with text formulas |
|
|
274 | (2) |
|
Hooray for Expression Builder |
|
|
276 | (5) |
|
Chapter 17 Take Charge with Action Queries |
|
|
281 | (10) |
|
|
|
282 | (4) |
|
|
|
286 | (3) |
|
|
|
289 | (2) |
| Part V: Simple and Snazzy Reporting |
|
291 | (78) |
|
Chapter 18 Fast and Furious Automatic Reporting |
|
|
293 | (22) |
|
Quick and Not-SO-Dirty Automatic Reporting |
|
|
294 | (11) |
|
Creating a quick, one-table report |
|
|
294 | (4) |
|
Starting the Report Wizard |
|
|
298 | (7) |
|
|
|
305 | (4) |
|
Zooming in and out and all around |
|
|
306 | (1) |
|
|
|
307 | (2) |
|
Beauty Is Only Skin (Report) Deep |
|
|
309 | (6) |
|
|
|
309 | (1) |
|
|
|
310 | (2) |
|
|
|
312 | (3) |
|
Chapter 19 Professionally Designed Reports Made Easy |
|
|
315 | (26) |
|
|
|
316 | (2) |
|
|
|
318 | (4) |
|
|
|
318 | (2) |
|
|
|
320 | (2) |
|
|
|
322 | (13) |
|
|
|
323 | (2) |
|
Relocation, relocation, relocation |
|
|
325 | (2) |
|
One size does not fit all |
|
|
327 | (2) |
|
|
|
329 | (1) |
|
|
|
330 | (3) |
|
|
|
333 | (2) |
|
|
|
335 | (1) |
|
Getting a Themes Makeover |
|
|
336 | (1) |
|
Adding More Design Elements |
|
|
337 | (4) |
|
|
|
338 | (1) |
|
|
|
339 | (1) |
|
|
|
339 | (2) |
|
Chapter 20 Headers and Footers and Groups, Oh My! |
|
|
341 | (20) |
|
A Place for Everything and Everything in Its Place |
|
|
342 | (8) |
|
|
|
342 | (2) |
|
|
|
344 | (3) |
|
|
|
347 | (3) |
|
|
|
350 | (1) |
|
|
|
350 | (11) |
|
Controlling report and page headings |
|
|
353 | (2) |
|
Adjusting individual sections |
|
|
355 | (1) |
|
|
|
356 | (5) |
|
Chapter 21 Magical Mass Mailings |
|
|
361 | (8) |
|
Massive Mailings with the Label Wizard |
|
|
361 | (8) |
| Part VI: More Power to You |
|
369 | (22) |
|
|
|
371 | (10) |
|
From Flat File to Relational Tables with Table Analyzer |
|
|
371 | (5) |
|
Record Database Object Information with the Database Documenter |
|
|
376 | (3) |
|
Improve Database Performance without Steroids |
|
|
379 | (2) |
|
Chapter 23 Steer Users in the Right Direction with Navigation Forms |
|
|
381 | (10) |
|
The Comings and Goings of a Navigation Form |
|
|
381 | (3) |
|
Am I in the Right Place? Testing Navigation Forms |
|
|
384 | (2) |
|
Maintaining the Navigation Form |
|
|
386 | (1) |
|
Edit a Navigation form item |
|
|
386 | (1) |
|
Delete a Navigation Form tab item |
|
|
386 | (1) |
|
Move a Navigation form item |
|
|
387 | (1) |
|
Displaying the Navigation Form at Startup |
|
|
387 | (4) |
| Part VII: The Part of Tens |
|
391 | (18) |
|
Chapter 24 Ten Common Problems |
|
|
393 | (10) |
|
|
|
393 | (1) |
|
You Type 73.725, but It Changes to 74 |
|
|
394 | (1) |
|
The Words They Are A-Changing |
|
|
395 | (1) |
|
Was There and Now It's Gone |
|
|
396 | (1) |
|
|
|
396 | (1) |
|
Search for the missing record |
|
|
396 | (1) |
|
|
|
397 | (1) |
|
You Run a Query, but the Results Aren't What You Expect |
|
|
397 | (1) |
|
The Dreaded Parameter Dialog Box |
|
|
398 | (1) |
|
The Slowest Database in Town |
|
|
399 | (1) |
|
Your Database File Is as Big as a Whale |
|
|
400 | (1) |
|
You Get a Mess When Importing Your Spreadsheet |
|
|
401 | (1) |
|
We're Sorry; Your Database File Is Corrupt |
|
|
402 | (1) |
|
Chapter 25 Ten Uncommon Tips |
|
|
403 | (6) |
|
Document Everything as Though One Day You'll be Questioned by the FBI |
|
|
404 | (1) |
|
Keep Your Fields as Small as Possible |
|
|
405 | (1) |
|
Use Number Fields for Real Numbers |
|
|
406 | (1) |
|
|
|
406 | (1) |
|
Use Understandable Names to Keep Things Simple |
|
|
406 | (1) |
|
Delete with Great Caution |
|
|
407 | (1) |
|
|
|
407 | (1) |
|
Think, Think, and Think Again |
|
|
407 | (1) |
|
Get Organized and Stay Organized |
|
|
408 | (1) |
|
There's No Shame in Asking for Help |
|
|
408 | (1) |
| Appendix A: Getting Help |
|
409 | (8) |
|
|
|
410 | (2) |
|
|
|
410 | (1) |
|
Asking the right questions |
|
|
410 | (2) |
|
|
|
412 | (2) |
|
|
|
413 | (1) |
|
Search engines and other sites |
|
|
413 | (1) |
|
|
|
414 | (3) |
|
|
|
414 | (1) |
|
|
|
415 | (2) |
| Index |
|
417 | |
Daugiau apie elektronines knygas