Datasheet

402
Index
editing in forms, 289
filtering, 296–297
navigating in forms, 290
overview, 267
searching in forms for, 291
sorting, 294–295
reference operators, 181
relative cell references, 185
reports
creating, 304–307
customizing, 307
overview, 267
printing, 307
research tools (Word), 123
Ribbon, 6, 8–9
rows (Excel)
adding, 155
deleting, 161
freezing, 157
resizing, 156
sorting data in, 171
rows (PowerPoint), 235
S
screen clippings (OneNote), 382–383
scroll bars, 7
search options (Word), 115
sections (OneNote)
creating, 387
deleting, 391
grouping, 392–393
renaming, 390
settings
print, 21
sharing, 55
shading, adding to text, 93
shapes, reshaping, 45
Share Workbook feature (Excel), 175
shortcut, creating icons for, 5
simple queries, 300–303
size (text), 71, 145, 227, 357
slide shows (PowerPoint)
rehearsing, 258–259
running, 260–261
setting up, 255
Slide Sorter view (PowerPoint), 219
slides (PowerPoint). See also PowerPoint
adding
animation effects, 250–251
charts to, 236–237
clip art to, 239
clips to, 240–241
pictures to, 238–239
tables to, 234–235
text, 224
text boxes to, 233
video clips to, 240–241
aligning text, 232
applying themes, 230
changing
font size and color, 226–229
layouts of, 221
creating
custom animations, 252–253
speaker notes, 256–257
defining slide transitions, 248–249
deleting, 245
changing
slide layout, 221
views, 218–219
creating
custom layouts, 222–223
photo album presentations, 212–213
presentations with templates, 214–215
editing slide text, 225
inserting slides, 220
presentations
creating
blank, 216–217
with templates, 214–215
packaging on CDs, 262–263
photo albums, 212–213
saving
as templates, 217
as videos, 263
primary key, 287
printer margin settings, 81
publication objects, 366–367
Publisher
adding
borders, 362
building block objects, 370–371
pictures to publications, 354–355
text, 352
text boxes, 353
applying text effects, 360
AutoFit feature, 365
changing
font size and color, 356–359
text alignment, 361
controlling text wraps, 363
creating
building block objects, 372–373
publications, 346–349
editing backgrounds, 368–369
linking text boxes, 364–365
moving publication objects, 366
resizing publication objects, 367
Zoom feature, 350–351
zooming, 350–351
Q
queries (Access)
filtering, 303
overview, 267
simple, 300–303
sorting, 303
Quick Access toolbar, 6, 10–11
Quick Borders feature (Excel), 148
Quick Columns feature (Word), 94
Quick Parts feature (Word), 64–65
Quick Styles feature (Word), 86–87
Quick Table feature (Word), 97
R
ranges, naming, 158–159
records. See also tables
adding
to forms, 288–289
to tables, 286–287
deleting
from forms, 293
from tables, 292
34_571941-bindex.indd 40234_571941-bindex.indd 402 4/9/10 7:47 PM4/9/10 7:47 PM