S

sales, Business Contact Manager for organizing, 479

sans serif fonts, 522

saving

Access data, 246, 247

Access field property changes, 250

Access layout changes, 272

Excel files, 135

Excel workbooks, 137

Word documents, 27-29

SBS Alert Test 1 message, 554-57

ScreenTips, 6

Search Folders, Outlook, 486, 552

security

linking to Internet calendar, 610

saving calendar information as Web page, 608

setting e-mail message, 521

selectors, 273

select query, 314, 358

Send A Calendar Via E-mail, 604-06

sensitivity setting, e-mail messages, 520

Sent Items folder, Outlook, 486

sequence of formatting changes, 267

shading backgrounds, in PowerPoint, 436-39

SharePoint Server 2007, Office, 388

Show Work Week option, Outlook 2007, 596-98

signatures, adding e-mail, 528-32

creating, 529-31

deleting, 532

inserting into all messages, 531

overview of, 528

signatures, digital, 65

size

Access fields, 338-40

PowerPoint fonts, 416-21

PowerPoint text, 405-08, 416-21

Word columns, 106

Word fonts, 70, 72

slide layout, PowerPoint 2007, 423-39

background shading and texture, 436-39

color schemes, switching, 431-34

colors not included in schemes, 434-36

layout of slides, changing, 424-27

order of slides, rearranging, 427-29

slide adjustments key points, 439

slide adjustments overview, 423-24

themes, changing fonts and effects of, 434

themes for slides, applying, 429-31

slide libraries, for PowerPoint presentations, 388

slide shows, PowerPoint 2007, 441-63.

See also presentations (PowerPoint 2007)

customizing for audience, 442-45

electronic pen for drawing on slides, 459-62

key points, 463

manually and automatic options for delivering, 445

options for moving through, 458-60

overview of, 441-42

pausing/resuming, 446

with PowerPoint 2007, 441

preparing for travel, 455-58

rehearsing, 445-49

reusing existing slides, 385-87

self-running, 449

showing, 458-62

showing/hiding specific slides, 443

slide timing, 446-47

speaker notes and handouts, 450-54

starting from Normal or Slide Sorter views, 458

using two monitors, 462-63

Slide Show view, PowerPoint 2007, 462

Slide Sorter view, PowerPoint 2007, 428

slide text, PowerPoint 2007, 391-421

appearance of text, 416-21

correcting text while typing, 405-08

editing text, 397-99

entering text, 392-97

find and replace function, 413-16

key points, 421

slide text overview, 391-92

spelling checker, 409-13

text boxes, 399-404

Small caps check box, Word 2007, 75

SmartArt

creating diagram within e-mail message, 514-19

defined, 514

Smart Tags, PowerPoint text entry, 408

Sort & Filter group, Access 2007, 303

sorting, Access 2007

Advanced Filter/Sort command, 310

color categories, 556

comparing filters, sorts, and queries, 316

exercise sorting by field(s), 300-301

how Access sorts, 299

Inbox messages, 545-47

information in forms, 301

information in tables, 107

overview of, 297

table information, 298-301

source files, Excel 2007, 125

spacing characters, Word 2007, 73-74

spacing paragraphs, Word 2007, 80

spacing text, PowerPoint 2007, 416-21

speaker notes, PowerPoint 2007, 450-54

Spelling and Grammar feature, Word documents, 56-61

spelling checking

in Excel, 168-72

in PowerPoint, 409-13

in Word, 56-61

SQL (Structured Query Language), 315

Stacked layout, 263, 266, 270

starting Word 2007, 8

Startup wizard, Outlook 2007

information required, 469

troubleshooting, 473-74

statistics, Word documents, 61

status bar, Word 2007, 6-7

StDev, aggregate functions, 329

Stencil, Word format, 72

Structured Query Language (SQL), 315

Style Inspector Pane, Word 2007, 77

styles

applying to Excel tables,, 218-21

customizing tables, 117

defining in Excel, 212-16

of forms, 284

selecting calendar printing, 600-604

using Quick Styles, 522-23

subforms

adding to forms, 285-92

creating simultaneously with forms, 292-94

defined, 261

Subject box

composing and sending e-mail message, 506

sending e-mail attachments, 511

subpoints, 392-96, 398

subtract (-), arithmetic operator, 306

Sum, aggregate functions, 329-30

SUMIFS function, 192-94

switchboards, 258

Sync Issues, Outlook, 486