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