S

S/MIME (Multipurpose Internet Mail Extensions)

encryption requiring mail clients capable of, 719

message-signing options with, 697–698

messaging with, 658

requesting secure receipts for outgoing messages, 699, 700

selecting options for cryptographic messages, 701

Safe for Initialization (SFI), 56, 57

safe mode startup, 663–665

 Sample Macros.dotm practice file, 1129, 1140

Save As dialog box, 528, 851

Save button (Quick Access Toolbar), 851

Save category (PowerPoint Options dialog box), 526

Save command (Access), 769, 770

SaveAs method, 1097

saving

code and document when using Open XML Format, 1084

database files, 844–845, 846

database templates, 896–897

document themes, 536–537

documents

with comments, 322–323

marked-up, 334

with tracked changes displayed, 60

earlier file format versions in XML, 11

files with .zip extension, 1150

macros and sharing, 1128

messages in search folders, 675

PowerPoint

files in XML, 527–528, 543

presentations in different versions, 529, 600

templates, 581, 583–585

unable to make fast saves, 593

Word page setup templates, 213–214

workbooks

closing defaults window last, 388

in Excel 2007 format, 428

as hidden, 392

linked, 439–440

and their characteristics, 383

workspaces

Groove, 204

in window, 381

scanners, 566, 622

scheduling

Calendar for, 634–636

Outlook’s capabilities for, 644–646

schemas

customUI.xsd, 1147

defined, 1147

scientific notation, 355–356

Scope drop-down list (New Name dialog box), 411, 412

screen capture, 604

screen clippings, 113

screen resolution and Ribbon display, 30

ScreenTips

about, 26

function, 455–456

Hyperlink data type, 953, 954

revealing comment information in, 319

scrolling datasheets, 942

SDI (single-document interface)

Access, 825–828

using multiple workbooks with, 380

Search Bar, 820–824

search folders, 675–678

changing criteria of, 677

creating, 677–678

customizing, 676–677

defined, 675

illustrated, 676

managing e-mail in, 684

using, 675–676

SEARCH function, 469

searching.

See also finding

Groove note pages, 162

maximizing search for types of objects, 824

OneNote audio and video files, 119

password-protected sections of notebooks, 126

queries, 961–968

query data on single field, 961–962

sections

breaks

changing page layout and inserting, 218

creating, 216–218

document

applying borders to, 223, 288–289, 290

creating different headers/footers for, 227

deleting headers and footers in, 229

notebook

about, 92

deleting, 97

locked, 125, 126

moving, 97

opening and moving between, 94

organizing, 96–98

password-protecting, 124–126, 128

using outlines to divide document into, 238

Secure/Multipurpose Internet Mail Extensions. See S/MIME (Multipurpose Internet Mail Extensions)

security.

See also digital signatures;

privacy;

Trust Center

Access’ content, 776–782

ActiveX control security settings, 56–57

alerts in Message Bar, 49

avoiding phishing schemes, 71–73

digital signature validation, 50–51, 711–714

disabling untrusted databases, 777–778

external content, 47, 51, 605, 686–689

blocking, 51, 605, 686–689

managing connections to, 47

Groove, 135

homographs, 609

macro and add-in options for, 54–55

Outlook

attachment and virus protection, 660

creating security profiles, 700–702

encrypting messages, 662, 714–719

features of, 685

global security options, 699–700

IRM protection in, 720–724

macro security, 661

protecting against Web beacons, 659–660

passwords

document, 69–71

notebook section, 124–126

workbook, 70, 378

PowerPoint

protecting final presentations, 612–613

restricting permissions to files, 590–592

Trust Center options in, 527

privacy options, 58–60

trusted locations

about, 606, 779–780

adding, 52

allowing remote or network path for, 607

creating PowerPoint, 606–608

defined, 51

modifying, 53, 608

removing, 53, 607–608

running documents from, 51

trusted publishers of macros, 48–49

updates for, 53

workbooks

encrypting, 391–392

passwords, 70, 378

working, 374–375, 390–391

worksheet protection, 372–379

security labels

configuring, 701

using in Outlook, 662

security profiles, 700–702

Security Properties dialog box, 698

Security Warnings, Access, 767, 777

Select A Folder For dialog box, 170, 172

Select Arguments dialog box, 459–460

Select Case structures for error trapping, 1126

select queries, 903

Select User dialog box, 724

Select Users Or Groups dialog box, 377

Select Users To Import dialog box, 740, 741

selecting

all worksheets, 363

Excel data, 344–352

cell precedents and dependents, 351

Find & Select commands for, 347

navigating multiple selections, 350

noncontiguous selections, 345–347

searching cells for differences, 351–352

selecting with mouse, 344

zooming to select areas, 345

functions, 459

multiple form fields, 989–990

multiple slides, 615

query fields in recordsets, 907–909

text boxes for copying, 272

selection criteria

dates and times in, 912–913

keywords as, 912

specifying for query field, 911–912

Selection And Visibility pane, 564–565

Selfcert.exe, 55

self-signed certificates, 55

Send Invitation dialog box, 171

Send Message dialog box, 137–138, 182

send for review feature (PowerPoint), 601–602

sending encrypted messages, 718

separators

comma as arguments, 424

comma as thousands, 871

date and time input mask, 871

Quick Access Toolbar, 775

SQL name, 929

servers.

See also Microsoft Exchange Server

Forms, 16

Groove, 16, 131

keeping POP3 messages on, 655

Office SharePoint, 14

Project, 17, 22

SQL, 859

Windows Server 2003, 657, 720

Service Pack 1, 66

Service Sign-Up dialog box, 721

Set Hyperlink ScreenTip dialog box, 956

Set Up Show dialog box, 621

setting up slide shows, 611–626

copyright symbols for intellectual property, 612

creating basic custom shows, 614–615

developing hyperlinked custom shows, 616–617

keeping viewers’ attention, 611

photo albums, 621–624

printing presentation materials, 624–626

rehearsing show before delivery, 613–614

running custom shows, 617

securing document when complete, 612–613

transitions in shows, 617–619

using Presenter view, 619–621

Settings And Options dialog box, 202, 203

Setup Diagnostic test, 1199

SFI (Safe for Initialization), 56, 57

shading

applying

borders independent from, 299

to tables and paragraphs, 298–300

focusing attention with, 276

guidelines for using, 300

Shading tab (Borders And Shading dialog box), 279

shadow text in PowerPoint, 547

shapes

adding or moving SmartArt, 572–573

applying picture effects on, 564

AutoShapes

changing, 269

controlling text in, 268

formatting, 267–270

inserting text into, 264–266

resizing automatically to show content, 269–270

spell and grammar checking in, 266

filling SmartArt, 570–571

tracking changes for inline, 329

shared notebooks

assigning password to sections of, 124–126, 128

creating, 89

location for files, 121

sending links to, 124

sharing

during Live Session, 127–130

existing notebooks, 122, 127

notes via e-mail, 130

storing on SharePoint Services site, 127

using on multiple computers, 120–122

working with, 123–124

shared workspaces

about, 80

Groove, 85–88

about, 78, 85–86

adding tools to, 87, 150–151

creating, 86–87, 167–170

downloading files in, 172–176

inviting others to join, 87–88, 171

Launchbar, 85, 135–138

managing files, 86

member roles, 88, 135, 140–141, 146–147

role permissions in, 88, 147, 176

Windows SharePoint Services, 79–84

about, 78, 80

accessing content, 81–82

adding content, 83

editing or adding Web Parts, 84

libraries, 80–81

managing site settings and permissions, 84

not visible in SharePoint, 82

viewing libraries or lists, 82

SharePoint Designer, 59

SharePoint libraries

about, 80–81

accessing content in, 81–82

connecting with Outlook, 750–751

downloading files from, 751–752

SharePoint Services. See Windows SharePoint Services

sharing.

See also shared notebooks;

shared workspaces

audio and video recordings, 111

business cards, 640

calendars, 15, 635, 640

contacts, 735–741

documents, 725, 729–735

Live Sharing Sessions, 89, 127–130

macros, 1127–1128

picture libraries, 726

storage files in Outlook, 653–654

sheets folder, 1156

shortcut arrow icon, 797

shortcut menus

alert, 186

using, 27, 38

worksheet, 363, 364

Shortcut tab (Properties page for Outlook), 667–669

shortcuts.

See also keyboard shortcuts

object

hiding and renaming, 811–814

revealing hidden Access, 814–817

Outlook

changing properties for, 667–669

comments for, 668

creating for new items, 673–674

creating Outlook icon on desktop, 665–666

modifying Target property for, 668, 674

repositioning Access Navigation Pane, 820

specifying switches in Office, 668, 674

Show Hidden Objects check box (Navigation Options dialog box), 814–817

Show Presenter View check box (Set Up Show dialog box), 621

Show Search Bar check box (Navigation Options dia- log box), 821

Show Table dialog box

defining query and table relationships, 885

illustrated, 906

opens in Relationships window first time, 883–884

showing. See displaying

Signature button, 704

Signature dialog box, 711, 712, 713

signing messages. See digital signatures

single-document interface (SDI), 380, 825–828

single quotation mark ("), 358, 359

single-axis PivotTables, 487

single-cell array formulas, 437

Site Actions menu, 84

Size gallery (Word), 212

sizing

comment balloons, 317

PowerPoint fonts, 547

presentation pictures, 565–566

Sketchpad tool, 163–165

Slide Library

adding slide from, 586

checking slides for changes, 585–586

collaborating with, 585

improvements in, 13–14

publishing slides to, 542–543

slide masters

adding to presentations, 534–535

custom slide layouts vs., 540

Slide Show view (PowerPoint), 533

Slide Sorter view (PowerPoint), 533

Slide Update dialog box, 585

slideLayouts folder, 1157

slideMasters folder, 1157

slides.

See also presentations;

Slide Library

adding from Slide Library, 586

checking for changes in, 585–586

clip art in PowerPoint, 566–567

comments

cutting/pasting into Notes pane, 588

dragging and placing, 589

compatibility issues for, 600

custom layouts for, 540–541

finding and replacing text in, 548–549

inserting headers and footers on, 556–558

printing, 625

publishing to Slide Library, 542–543

resizing

images on, 566

and reorienting printed, 626

selecting multiple sequential or nonsequential, 615

setting up shows, 611–626

creating basic show, 614–615

developing hyperlinked custom shows, 616–617

keeping viewers’ attention, 611

photo albums, 621–624

printing materials for show, 624–626

rehearsals, 613–614

running custom shows, 617

securing document when complete, 612–613

transitions in shows, 617–619

using copyright symbols, 612

using Presenter view, 619–621

templates for, 583–585

text box in, 545–548

tracking changes to, 586

transitions between, 617–619

turning on/off titles and footers, 541

writing on, 556

smart tags in Excel, 362

SmartArt, 567–573

about, 548, 567–568

adding or moving shape, 572–573

animating, 578

compatibility with PowerPoint versions, 600

creating graphic for, 568–569

filling shape with picture, 570–571

layout choices for, 568

picture placeholders in, 571–572

PowerPoint lists with, 553–556

styles with, 570

unable to find text pane for graphic, 569

working with, 14

SMTP/POP3 protocol, 654

Sort Ascending button (Datasheet view), 941, 958–959

Sort By submenu (Access), 818

Sort (Channel) dialog box, 502

Sort Descending button (Datasheet view), 941, 957, 958, 959

sorting

Access data in Datasheet view, 957–961

data for reports, 1023–1031

Lookup properties and, 937

messages by group, 683

multiple reverse order, 959

options for reports in Layout view, 1054–1058

query output data, 934–936

saving and reusing criteria for, 968

specifying criteria in Group, Sort, And Total pane for report, 1031

specifying sort order in queries, 936

sound

troubleshooting presentation, 573, 574

using in presentations, 573–574

spaces

adding between lines in VBA message boxes, 1133

avoiding in SQL names, 859, 918, 920

Conditional Sum Wizard’s processing of, 449

omitting in Object Browser, 1089

space character as intersection operator, 424

spammers, 686

special characters

entering from Symbol dialog box, 359

entering symbols, 359–360

excluded from field names, 859

using in Excel, 354–355

special item specifiers, 421, 424

spell checking

PowerPoint, 558–559

text boxes and shapes, 266

Split button, 367

Split Form command, 1001

splitting

document window, 247, 248

worksheet window, 367–368

spoofed Web sites

alerts for potentially, 72–73

enabling detection of, 60

spreadsheets. See workbooks

SQL Server, 859

SQL (Structured Query Language)

name separators in, 929

spaces in names in, 859, 918, 920

stacked control layouts, 1059, 1061

Standard Colors section (color palette), 283

standard workspaces, 139, 167

Start menu, 663

startFromScratch command, 1177, 1178, 1185

Startup folder, changing Outlook startup from short- cut in, 666

startup options for Outlook, 663–674

automatic startup, 665

changing shortcut properties, 667–669

changing user context with RUNAS command, 669–670

choosing view on startup, 671–673

creating shortcuts to new Outlook items, 673–674

desktop shortcut as, 665–666

normal startup, 663

Quick Launch bar startups, 666

safe mode startup, 663–665

startup command-line switches, 670–671

Startup Prompt dialog box, 442

startup switches, 670–671

statements

coding efficiently, 1095

declaring multiple VBA variables in one, 1094

grouping VBA, 1103–1104

specifying arguments in VBA, 1098

VBA, 1082

states

OR as abbreviation for, 912, 913–915

sorting data by province or, 959

status bar

about, 26

Office 2003 vs. 2007, 27

Store Random Number To Improve Combine Accuracy feature, 1146

strings

constants and, 352

zero-length, 866

Structure check box (Protect Structure And Windows dialog box), 391

Structured Query Language. See SQL (Structured Query Language)

structured references, 420–423

about, 420–421

filling and copying, 426–427

Formula AutoComplete with, 425

list of special item specifiers, 424

natural-language formulas vs., 422

qualified and unqualified, 425

reference operators with, 424

syntax of, 423–424

styles

adding to SmartArt graphic, 570

picking Form Wizard form, 1004, 1005

Report Wizard’s built-in, 1044

unable to edit gallery default, 41

styles.xml file, 1170–1171

Sub statements, 1080, 1086–1087

Subdatasheet Expanded property, 878, 880

Subdatasheet Height property, 878, 880

Subdatasheet menu, 944

Subdatasheet Name property, 878, 880

subdatasheet selector (Datasheet view), 941

subdatasheets, 943–946

applying filters to, 963

copying and pasting data in, 950–952

deleting rows, 952

effect on table performance, 879

expanding information on, 941, 943–946

pencil and asterisk record indicators on, 946

replacing data in, 950

selecting and changing data in, 949

shortcuts for entering records, 947

subfolders, 171

subforms

about, 970

embedding in another form, 979

illustrated, 971

submenus

Sort By, 818

View By, 818–819

subroutines in macros, 1080, 1086–1087

subscriptions. See alerts

SUBSTITUTE function, 470

subtotals for PivotTable, 499–501

Success dialog box, 749

Sum button, 405–406, 461

SUM functions

conditional formulas using, 446–449

reference changes in formula with inserted rows, 401, 462

using, 461

using Sum button, 405–406, 461

SUMIF function, 472

SUMPRODUCT function, 462

surveys, SharePoint, 726

switchboard forms, 970.

See also forms

switches

specifying in Office shortcuts, 668, 674

startup command-line, 670–671

Symbol button, 359

Symbol dialog box, 359, 612

symbols, outline, 240

Synchronization Tasks task pane, 168, 171

synchronizing

Groove shared folders, 168–169, 173–175

OneNote and Outlook tasks, 108–109

Outlook folders, 651–652

Synchronous Scrolling button, 385

syntax

errors in XML, 1148, 1163

formula reference, 401

function, 456–457

RUNAS command, 669–670

structured reference, 423–424

testing for VBA in Immediate window, 1131