U

UFI (Unsafe for Initialization), 56, 57

Unassigned Objects group (Access), 795, 799, 801, 804, 805

Uncomment Block button, 1124

underlying values

calculations performed with, 465

displayed vs., 355–356

troubleshooting incorrect calculations with, 356

underscore (_), 871, 872

undoing

Access Undo command, 769, 770

actions in lists, 363

Excel entries, 361–363

pasted data in Excel, 416

unhiding workbooks, 389–390

unified mode for messaging, 662

Uniform Resource Locators. See URLs (Uniform Resource Locators)

units of measure, 976

unlocking cells, 373–374

unqualified structured references, 425

Unrelated Objects group (Access), 799, 803

Unsafe for Initialization (UFI), 56, 57

untrusted databases, 777–778

updates

applications, 53

checking for, 839, 1198

privacy options allowing, 59

synchronizing Groove files and folders, 174–175

upgrading Office, 1192

Upload Document page, 730

UPPER function, 466

URLs (Uniform Resource Locators)

contained in Hyperlink data type, 953

finding for CRL, 713–714

phishing schemes activated by, 72

Use Account On Another Computer dialog box, 143

Use Contextual Spelling check box (PowerPoint Options dialog box), 559

Use Rehearsed Timings check box, 614

user accounts

changing account managing IRM files, 69

running Outlook from different, 669

user interface, 21–43.

See also Microsoft Office Button;

Navigation Pane;

Ribbon;

and specific interface components

Access

customizing, 826–827

display order for categories, 803

features of, 763–764, 766–767

single- vs. multiple-document, 825–828

contextual tabs, 7, 25, 36–37

Datasheet view features, 941

dialog boxes, 41

File menu replaced in, 8, 34, 35

finding Office menu, 8–9

galleries, 9–10, 25, 39–41, 532, 533

Groove

exploring, 148–150

Launchbar, 85, 135–138

Workspace Explorer features, 140, 143, 145, 148–150

Instant Search feature (Office), 633

Live Preview, 9–10, 25

Meeting Assistant, 635

Microsoft Office Button, 23, 24, 34–35

Microsoft Office OneNote, 92

Mini toolbar, 38–39, 549, 554

Navigation Pane

in Access, 766, 787–789

in Outlook, 631–632

new features tour, 22–28

Notebooks navigation pane, 92, 95–96

Office 2003 vs. 2007, 27

OneNote, 91

online Help, 23, 41–43

Outlook

Calendar changes, 634–636

changes in, 629–633

color categories in, 637–638

message form, 630–631

PowerPoint, 526–527

Quick Access Toolbar

in Access, 766, 769–776

customizing, 32–33

illustrated, 24

navigating from Ribbon to, 33

reasons for changing, 21

Ribbon, 6–9, 28–31

Access use of, 766, 783–787

customizing, 1175–1182

ScreenTips

about, 26

function, 455–456

Hyperlink data type, 953, 954

revealing comment information in, 319

Search Bar, 821–824

status bar, 26

tabs, 7, 24

To-Do Bar, 14, 632

UserForms

automating, 1138–1140

blank, 1134

designing, 1134–1138

properties available for, 1135

setting up tab order for, 1137–1138

toggling between code and, 1139

users

adding and changing, 378

cell-editing permissions for, 375–378

formatting principles used by, 37

granting worksheet permissions to, 377

setting up Outlook profiles for, 663

skills needed to use Open XML Formats, 1144