Datasheet
357
Q
queries, saving filters as, 238–239
Quick Access toolbar, 4–5, 114–115
Quick Steps, 268–269
R
records
adding using data forms, 128–129
attaching fields to, 234–235
copying, 229
deleting, 129
editing using data forms, 128–129
filtering, 131
sorting, 130
reports, 244–245, 256–257
Research pane (Word), 56
restricted access, 37
Review tab, 49
Ribbon, 5–11, 19
RSS feeds (Really Simple Syndication), 294–295
rules (e-mail), 282–285
S
screen capture, 328–329
Screenshot, 328–329
Selection and Visibility pane, 339
self-running presentations, 175
SharePoint, 189, 217
signatures (e-mail), 272–273
SkyDrive, 186–187
slide masters, 194–195
slides
animating, 210–211
creating custom layouts, 192–193
reusing, 164–165
writing on during presentations, 176–177
SmartArt graphics, 204–205
SmartTag icon, 69
Solver feature (Excel), 124–125
Sort dialog box, 130
sound, adding to presentations, 207
Sparklines, 150–151
speaker notes, 178
startup folders, 100–101
summary statistics, 240
T
tab order (Access), 253
table of contents (TOC), 86–87
tables, database, 126–127
tasks
automating with macros, 14–15, 248–249
delegating, 311
templates
Access, 216–217
Publisher, 314–315
text. See also data
automatically fitting, 319
centering across columns, 155
changing orientation in cells, 153
filler, 76
finding and replacing, 53
joining from separate cells, 113
translating, 48–49
wrapping, 152, 350–351
text boxes, 317
text files, 316
themes, 136–137, 196–201, 252
TOC (table of contents), 86–87
Track Changes feature (Word), 72–75
transition effects, 167
trendlines, 148–149
Tufte, Edward (inventor), 151
U
Ungroup command, 342–343
V
validation rules (Access), 232–233
video (PowerPoint), 182–183, 206, 208–209
View tab (Ribbon), 19
W
Watch window, 106–107
watermarks, 348–349
Web pages, saving Office files as, 27
what-if scenarios, 120–121
Windows Paint, 347
Windows Rights Management feature, 39
Word (Microsoft)
adding cross-references, 94–95
adding filler text, 76
adding header/footer building blocks, 44–45
adding line numbers to documents, 96–97
AutoCorrect, 62–63
AutoText, 60–61
bookmarks, 56–57
borders, 70–71
changing default font, 16
charts, 78–79
comparing documents, 74–75
converting documents to presentations, 158–159
creating bibliographies, 82–83
creating blog posts, 50–51
Drop Caps, 64–65
exporting reports from Access to, 244–245
generating indexes, 90–93
generating table of contents (TOC), 86–87
inserting cover pages, 88–89
inserting footnotes and endnotes, 84–85
inserting horizontal lines, 68
looking up synonyms/definitions, 54–55
Navigation pane, 58–59
nonbreaking spaces, 77
resuming numbering in lists, 69
searching documents, 52–53
setting default line spacing, 66–67
sharing building blocks, 46–47
Track Changes, 72–73
translating text, 48–49
WordArt objects, 346–347
workbooks, 100–101, 108, 136–137
17_577752-bindex.indd 35717_577752-bindex.indd 357 5/17/10 1:11 PM5/17/10 1:11 PM