| Introduction |
|
1 | (6) |
|
|
|
1 | (1) |
|
Conventions Used in This Book |
|
|
1 | (1) |
|
What You Don't Have to Read |
|
|
2 | (1) |
|
|
|
3 | (1) |
|
How This Book Is Organized |
|
|
3 | (2) |
|
Part I: Which Came First, the Data or the Base? |
|
|
3 | (1) |
|
Part II: Truly Tempting Tables |
|
|
4 | (1) |
|
Part III: Finding the Ultimate Answer to Almost Everything |
|
|
4 | (1) |
|
Part IV: Turning Your Table into a Book |
|
|
4 | (1) |
|
Part V: Wizards, Forms, and Other Mystical Stuff |
|
|
4 | (1) |
|
Part VI: The Part of Tens |
|
|
5 | (1) |
|
|
|
5 | (1) |
|
|
|
6 | (1) |
| Part I: Which Came First, the Data or the Base |
|
7 | (34) |
|
Chapter 1: The 37-Minute Overview |
|
|
9 | (14) |
|
In the Beginning, There Was Access 2003 |
|
|
9 | (3) |
|
Opening an Existing Database |
|
|
12 | (2) |
|
Touring the Database Window |
|
|
14 | (1) |
|
Finding Information Amongst the Grass Clippings |
|
|
15 | (2) |
|
|
|
17 | (1) |
|
|
|
18 | (2) |
|
|
|
20 | (1) |
|
|
|
21 | (1) |
|
|
|
22 | (1) |
|
Chapter 2: Finding Your Way Around like a Native |
|
|
23 | (12) |
|
Making Sense of the Sights |
|
|
24 | (2) |
|
Windows Shopping for Fun and Understanding |
|
|
26 | (5) |
|
|
|
26 | (2) |
|
|
|
28 | (1) |
|
|
|
29 | (1) |
|
|
|
30 | (1) |
|
Belly Up to the Toolbar, Folks! |
|
|
31 | (1) |
|
|
|
32 | (1) |
|
Playing with the Other Mouse Button |
|
|
32 | (3) |
|
Chapter 3: Calling the Online St. Bernard and Other Forms of Help |
|
|
35 | (6) |
|
Finding Help Here, There, and Waaaay Over There |
|
|
36 | (1) |
|
Asking Questions of the Software |
|
|
36 | (2) |
|
Your Internet Connection Knows More Than You May Think |
|
|
38 | (1) |
|
|
|
39 | (2) |
| Part II: Truly Tempting Tables |
|
41 | (86) |
|
Chapter 4: Designing and Building a Home for Your Data |
|
|
43 | (24) |
|
Database Terms to Know and Tolerate |
|
|
44 | (2) |
|
|
|
44 | (1) |
|
Fields (the rooms for your stuff) |
|
|
45 | (1) |
|
Records (the rooms in one house) |
|
|
45 | (1) |
|
Table (the houses of a neighborhood) |
|
|
46 | (1) |
|
Database (a community of neighborhoods) |
|
|
46 | (1) |
|
Frolicking through the Fields |
|
|
46 | (4) |
|
Flat Files versus Relational Databases: Let the Contest Begin! |
|
|
50 | (3) |
|
Flat files: Simple answers for simple needs |
|
|
51 | (1) |
|
Relational databases: Complex solutions to bigger problems |
|
|
51 | (1) |
|
Figuring out what all this means |
|
|
52 | (1) |
|
Great Tables Start with Great Designs |
|
|
53 | (2) |
|
|
|
55 | (4) |
|
Creating Tables at the Wave of a Wand |
|
|
59 | (4) |
|
Building Tables by Hand, Just like in the Old Days |
|
|
63 | (4) |
|
Chapter 5: Relationships, Keys, and Indexes (and Why You Really Do Care) |
|
|
67 | (10) |
|
The Joy (and Necessity) of a Primary Key |
|
|
68 | (1) |
|
Divulging the Secrets of a Good Relationship |
|
|
69 | (2) |
|
Linking Your Tables with the Relationship Builder Thingy |
|
|
71 | (3) |
|
Indexing Your Way to Fame, Fortune, and Significantly Faster Queries |
|
|
74 | (3) |
|
Chapter 6: New Data, Old Data, and Data in Need of Repair |
|
|
77 | (10) |
|
Dragging Your Table into the Digital Workshop |
|
|
78 | (3) |
|
Adding Something to the Mix |
|
|
81 | (2) |
|
Changing What's Already in a Record |
|
|
83 | (1) |
|
Kicking Out Unwanted Records |
|
|
84 | (1) |
|
Recovering from a Baaaad Edit |
|
|
85 | (2) |
|
Chapter 7: Making Your Table Think with Formats, Masks, and Validations |
|
|
87 | (16) |
|
Finding the Place to Make a Change |
|
|
88 | (1) |
|
To Format, Perchance to Better See |
|
|
89 | (5) |
|
|
|
90 | (1) |
|
Number and currency fields |
|
|
91 | (1) |
|
|
|
92 | (1) |
|
|
|
93 | (1) |
|
What Is That Masked Data? |
|
|
94 | (6) |
|
Using the Input Mask Wizard |
|
|
95 | (2) |
|
|
|
97 | (3) |
|
Validations: The Digital Breathalyzer Test |
|
|
100 | (3) |
|
Chapter 8: Making Your Datasheets Dance |
|
|
103 | (14) |
|
Wandering Here, There, and Everywhere |
|
|
103 | (2) |
|
Seeing More or Less of Your Data |
|
|
105 | (9) |
|
Changing the column width |
|
|
106 | (1) |
|
|
|
107 | (1) |
|
|
|
108 | (2) |
|
|
|
110 | (2) |
|
|
|
112 | (2) |
|
Fonting around with Your Table |
|
|
114 | (1) |
|
Giving Your Data the 3-D Look |
|
|
114 | (3) |
|
Chapter 9: Table Remodeling Tips for the Do-It-Yourselfer |
|
|
117 | (10) |
|
This Chapter Can Be Hazardous to Your Table's Design |
|
|
118 | (1) |
|
Putting a New Field Next to the Piano |
|
|
118 | (3) |
|
Saying Good-bye to a Field (And All Its Data) |
|
|
121 | (1) |
|
A Field by Any Other Name Still Holds the Same Stuff |
|
|
122 | (7) |
|
Changing a field name in design view |
|
|
123 | (1) |
|
Changing a field name in datasheet view |
|
|
124 | (3) |
| Part III: Finding the Ultimate Answer to Almost Everything |
|
127 | (82) |
|
Chapter 10: Quick Searches: Find, Filter, and Sort |
|
|
129 | (14) |
|
Finding Stuff in Your Tables |
|
|
130 | (3) |
|
Finding first things first (and next things after that) |
|
|
130 | (1) |
|
Tuning a search for speed and accuracy |
|
|
131 | (2) |
|
Sorting Out Life on the Planet |
|
|
133 | (1) |
|
Filtering Records with Something in Common |
|
|
134 | (3) |
|
|
|
135 | (1) |
|
|
|
136 | (1) |
|
|
|
137 | (3) |
|
Removing your mistakes (or when good criteria go bad) |
|
|
140 | (1) |
|
Filter by excluding selection |
|
|
141 | (2) |
|
Chapter 11: Pose a Simple Query, Get 10,000 Answers |
|
|
143 | (8) |
|
Database Interrogation for Fun and Profit |
|
|
144 | (1) |
|
On Your Way with a Simple Query - Advanced Filter/Sort |
|
|
144 | (6) |
|
Peering into the filter window |
|
|
146 | (1) |
|
Building a simple query - er, filter |
|
|
147 | (3) |
|
Plagued by Tough Questions? Try an Industrial Strength Query! |
|
|
150 | (1) |
|
Build a Better Query and the Answers Beat a Path to Your Monitor |
|
|
150 | (4) |
|
Toto, Can the Wizard Help? |
|
|
154 | |
|
Chapter 12: Searching a Slew of Tables |
|
|
151 | (16) |
|
Some General Thoughts about Multiple-Table Queries |
|
|
157 | (2) |
|
Calling on the Query Wizard |
|
|
159 | (2) |
|
Rolling Up Your Sleeves and Building the Query by Hand |
|
|
161 | (6) |
|
Chapter 13: Lions AND Tigers OR Bears? Oh My! |
|
|
167 | (8) |
|
|
|
167 | (1) |
|
Finding Things between Kansas AND Oz |
|
|
168 | (2) |
|
Multiple ANDS: AND Then What Happened? |
|
|
170 | (1) |
|
Are You a Good Witch OR a Bad Witch? |
|
|
170 | (2) |
|
|
|
172 | (3) |
|
Chapter 14: Teaching Queries to Think and Count |
|
|
175 | (12) |
|
Super-Powering Queries with the Total Row |
|
|
176 | (2) |
|
Adding the Magical Total Row to Your Queries |
|
|
178 | (1) |
|
Putting the Total Row to Work |
|
|
179 | (4) |
|
Organizing things with Group By |
|
|
179 | (1) |
|
|
|
180 | (1) |
|
|
|
181 | (1) |
|
Narrowing the results with Where |
|
|
182 | (1) |
|
Choose the Right Field for the Summary Instruction |
|
|
183 | (4) |
|
Chapter 15: Calculating Your Way to Fame and Fortune |
|
|
187 | (12) |
|
|
|
188 | (3) |
|
Bigger, Better (and More Complicated) Calculations |
|
|
191 | (4) |
|
Add another calculation - go ahead, add two! |
|
|
191 | (1) |
|
Using one expression to solve a different question |
|
|
191 | (2) |
|
Making Access ask nicely for help |
|
|
193 | (1) |
|
|
|
194 | (1) |
|
Expression Builder (Somewhat) to the Rescue |
|
|
195 | (4) |
|
Chapter 16: Automated Editing for Big Changes |
|
|
199 | (10) |
|
First, This Word from Our Paranoid Sponsor |
|
|
199 | (1) |
|
Quick and Easy Fixes: Replacing Your Mistakes |
|
|
200 | (2) |
|
Different Queries for Different Jobs |
|
|
202 | (1) |
|
You're Outta Here: The Delete Query |
|
|
203 | (2) |
|
|
|
205 | (4) |
| Part IV: Turning Your Table into a Book |
|
209 | (64) |
|
Chapter 17: AutoReport: Like the Model-T, It's Clunky but It Runs |
|
|
211 | (12) |
|
AutoReport Basics for High-Speed Information |
|
|
212 | (1) |
|
Putting the Wheels of Informational Progress in Motion |
|
|
213 | (1) |
|
Previewing Your Informational Masterpiece |
|
|
214 | (3) |
|
Zooming around your report |
|
|
215 | (1) |
|
Calling on the pop-up menu |
|
|
216 | (1) |
|
Truth Is Beauty, So Make Your Reports Look Great |
|
|
217 | (6) |
|
|
|
218 | (1) |
|
|
|
219 | (1) |
|
|
|
220 | (3) |
|
Chapter 18: Wizardly Help with Labels, Charts, and Multilevel Reports |
|
|
223 | (16) |
|
|
|
223 | (5) |
|
Using the Chart Wizard in Your Report |
|
|
228 | (3) |
|
Creating More Advanced Reports |
|
|
231 | (8) |
|
Starting the wizard and choosing some fields |
|
|
231 | (2) |
|
|
|
233 | (1) |
|
|
|
234 | (1) |
|
|
|
235 | (4) |
|
Chapter 19: It's Amazing What a Little Formatting Can Do |
|
|
239 | (18) |
|
Taking Your Report to the Design View Tune-Up Shop |
|
|
240 | (1) |
|
Striking Up the Bands (and the Markers, Too) |
|
|
241 | (2) |
|
Formatting This, That, These, and Those |
|
|
243 | (8) |
|
|
|
244 | (2) |
|
|
|
246 | (2) |
|
|
|
248 | (2) |
|
|
|
250 | (1) |
|
Taking a Peek at Your Report |
|
|
251 | (1) |
|
AutoFormatting Your Way to a Beautiful Report |
|
|
252 | (1) |
|
|
|
253 | (1) |
|
|
|
254 | (1) |
|
|
|
255 | (1) |
|
Sprucing Up the Place with a Few Pictures |
|
|
256 | (1) |
|
Passing Your Reports around the (Microsoft) Office |
|
|
256 | (1) |
|
Chapter 20: Headers and Footers for Groups, Pages, and Even (Egad) Entire Reports |
|
|
257 | (16) |
|
|
|
258 | (7) |
|
|
|
261 | (3) |
|
Changing a section's size |
|
|
264 | (1) |
|
|
|
265 | (4) |
|
Playing with the properties |
|
|
265 | (1) |
|
Directing the report and page headings |
|
|
266 | (2) |
|
Adjusting individual sections |
|
|
268 | (1) |
|
Taking it one item at a time |
|
|
269 | (1) |
|
Filling in Those Sections |
|
|
269 | (6) |
|
|
|
270 | (1) |
|
|
|
271 | (2) |
| Part V: Wizards, Farms, and Other Mystical Stuff |
|
273 | (52) |
|
Chapter 21: Spinning Your Data onto the Web |
|
|
275 | (10) |
|
Access and the Internet: A Match Made in Redmond |
|
|
275 | (1) |
|
Building Hyperlinks in Your Table |
|
|
276 | (4) |
|
Adding a hyperlink field to your table |
|
|
277 | (1) |
|
Typing and using hyperlinks |
|
|
277 | (3) |
|
Pushing Your Data onto the Web |
|
|
280 | (4) |
|
Advanced Topics for Your Copious Nerd Time |
|
|
284 | (1) |
|
Chapter 22: Making Forms that Look Cool and Work Great |
|
|
285 | (14) |
|
Tax Forms and Data Forms Are Different Animals |
|
|
285 | (2) |
|
Creating a Form at the Wave of a Wand |
|
|
287 | (3) |
|
Giving the Form Just the Right Look |
|
|
290 | (2) |
|
Mass Production at Its Best: Forms from the Auto Factory |
|
|
292 | (1) |
|
Ultimate Beauty through Cosmetic Surgery |
|
|
293 | (6) |
|
Taking a form into Design view |
|
|
294 | (1) |
|
|
|
294 | (1) |
|
|
|
295 | (1) |
|
Changing the field tab order |
|
|
296 | (3) |
|
Chapter 23: If Love Is Universal, Why Can't I Export to It? |
|
|
299 | (2) |
|
Importing Only the Best Information for Your Databases |
|
|
300 | (4) |
|
|
|
300 | (2) |
|
Importing or linking your files |
|
|
302 | (2) |
|
Sending Your Data on a Long, One-Way Trip |
|
|
304 | |
|
Chapter 24: The Analyzer: Your Data's Dr. Freud, Dr. Watson, and Dr. Jekyll |
|
|
301 | (14) |
|
It Slices, It Dices, It Builds Relational Databases! |
|
|
307 | (3) |
|
Documentation: What to Give the Nerd in Your Life |
|
|
310 | (2) |
|
Performance: Toward a Better Database |
|
|
312 | (3) |
|
Chapter 25: Talking to Your Computer |
|
|
315 | (10) |
|
What Is Speech Recognition (and What Can I Do with It)? |
|
|
316 | (1) |
|
Installing Speech Recognition |
|
|
316 | (1) |
|
Sending Access to Voice Training School |
|
|
317 | (2) |
|
|
|
319 | (5) |
|
"Access, take a letter please" |
|
|
320 | (1) |
|
Correcting dictation errors |
|
|
321 | (1) |
|
|
|
322 | (2) |
|
Improving Speech Recognition |
|
|
324 | (1) |
| Part VI: The Part of Tens |
|
325 | (18) |
|
Chapter 26: Ten Timesaving Keyboard Shortcuts |
|
|
321 | (10) |
|
Select an Entire Field: F2 |
|
|
327 | (1) |
|
Insert the Current Date: Ctrl+; (Semicolon) |
|
|
328 | (1) |
|
Insert the Current Time: Ctrl+: (Colon) |
|
|
328 | (1) |
|
Insert the Same Field Value as in the Last Record: Ctrl+' (Apostrophe) |
|
|
328 | (1) |
|
Insert a Line Break: Ctrl+Enter |
|
|
328 | (1) |
|
Add a Record: Ctrl++ (Plus Sign) |
|
|
329 | (1) |
|
Delete the Current Record: Ctrl+- (Minus Sign) |
|
|
329 | (1) |
|
Save the Record: Shift+Enter |
|
|
329 | (1) |
|
Undo Your Last Changes: Ctrl+Z |
|
|
329 | (1) |
|
Open the Selected Object in Design View: Ctrl+Enter |
|
|
330 | (1) |
|
Chapter 27: Ten Common Crises and How to Survive Them |
|
|
331 | (6) |
|
You Type 73.725, but It Changes to 74 |
|
|
332 | (1) |
|
You Run a Query but the Results Look Screwy |
|
|
332 | (1) |
|
And When You Looked Again, the Record Was Gone |
|
|
333 | (1) |
|
The Validation That Never Was |
|
|
334 | (1) |
|
The Sometimes-There, Sometimes-Gone Menus |
|
|
334 | (1) |
|
You Can't Link to a dBASE Table |
|
|
335 | (1) |
|
You Can't Update a Linked dBASE or Paradox Table |
|
|
335 | (1) |
|
You Get a Key Violation While Importing a Table |
|
|
335 | (1) |
|
Try as You May, the Program Won't Start |
|
|
336 | (1) |
|
The Wizard Won't Come Out of His Keep |
|
|
336 | (1) |
|
Chapter 28: Ten Tips from Database Nerds |
|
|
337 | (6) |
|
Document As if Your Life Depends on It |
|
|
337 | (1) |
|
Don't Make Your Fields Too Big |
|
|
338 | (1) |
|
Use Number Fields for Real Numbers |
|
|
339 | (1) |
|
|
|
339 | (1) |
|
|
|
339 | (1) |
|
Take Great Care When Deleting Keep Backups |
|
|
340 | (1) |
|
Think First and Then Think Again |
|
|
340 | (1) |
|
Get Organized and Keep It Simple |
|
|
340 | (1) |
|
Know When to Ask for Help |
|
|
341 | (2) |
| Index |
|
343 | |