O

Object Browser

finding constants in, 1099

getting help in, 1127

searching for terms in, 1089

viewing properties in, 1090

Object Designers category (Access), 833, 893–894

object models

document variables in Word, 1096–1097

looking up, 1088–1089

member arguments for, 1097–1098

Object Type category (Access), 790, 792, 803

object variables, 1093

object-oriented programming

creating forms with, 969–972

event sequencing, 971

methods, queries, and properties in, 970

objects

dragging and dropping into custom groups, 808

editing and formatting from shortcut menus, 38

finding missing properties or methods with Range, 1102–1103

jumping to in Access Navigation Pane, 788

looking up object models in Object Browser, 1088–1089

object-oriented systems’ view of, 970

opening in Access single- or multiple-document interface, 825–828

searching for database, 820–824

selecting in VBA, 1130

shortcuts

hiding and renaming, 811–814

revealing hidden Access, 814–817

sorting in Access Navigation Pane, 818–820

VBA

about, 1087–1088

collection objects and, 1101–1102

Objects folder, 1084

ODD function, 465

odds, calculating, 464

% Of custom calculation, 507

% Of Row custom calculation, 507

% Of Total custom calculation, 507

Office. See Microsoft Office

Office menu, 8–9

Office Online, 17–19

Offline Server Document banner, 755

offline work in Groove, 180

offset, 478

OLE Object data type

about, 858, 860

unavailable in Group, Sort, And Total pane, 1025

OLE objects, 889

one-dimensional arrays, 434–435

OneNote, 91–130.

See also notebooks

about, 16, 91

assigning and configuring passwords in, 124–126

building tables in, 117–118

collaborating with, 89, 91

drawing in, 116–117

file formats used for sound and video in, 111

finding information in, 119–120

notebooks

adding hyperlink to pages, 114

creating, 93–94

embedding file references in, 108

gathering information from Web for, 112–114

inserting image in, 115–116

inserting screen clippings in, 113

organizing, 92–100

section organization, 96–98

sharing, 120–124

types of, 92

Notebooks navigation pane, 92, 95–96

pages templates, 99

printing files to, 105–106

tagging types of notes, 103–105

taking notes on mobile devices, 115

user interface for, 92

using with Outlook, 108–109

viewing privacy options in, 59

working with notes, 100–103

working in window, 94–96

writing tools in, 116

OneNote icon, 114

one-to-many relationships, 886

online Help

Access, 761

connection status label in window, 42

function reference in, 453–454

getting, 19, 761

information on user interface changes, 23

Office Online and, 17–19

using, 41–43

online templates for Access, 763, 764, 843–844, 845

Open dialog box, 765

Open XML Formats

about, 10–11, 1143

binding data to Content Controls, 1182–1189

about, 1182–1183

binding custom XML file, 1186–1188

components of bound Content Control, 1183

converting control types from plain to rich text, 1189

creating custom XML files, 1184–1186

building .docx file without Word, 1156–1163

compiling and opening new documents, 1161

Content_Types file, 1160

finding errors in syntax, 1163

folder structure, 1157

main document file, 1157–1159

.rels file, 1160–1161

customizing Ribbon, 1175–1182

about, 1175–1176

adding group to built-in tab, 1180–1182

adding tab, 1176–1180

components of, 1176

control IDs, 1180

editing and managing documents, 1164–1175

document measurements and style definitions in, 1164–1165

editing custom styles, 1170–1171

formatting text, 1167–1170

picture editing, 1171–1172

removing comments from ZIP package, 1173–1175

replacing image file with different file type, 1173

text editing, 1165–1167

file structure for, 1150–1152

key document parts for, 1153–1156

key terms for, 1147

readingXML, 1145–1146

saving code and document when using, 1084

skills required to work with, 1144

ways to access ZIP packages in, 1149–1150

working with, 1190

XML basics and, 1144–1148

opening

Access first time, 761–762

Access Options dialog box, 829

Custom Animation task pane, 573

database in Access, 764–767

dependent workbooks, 440–441

documents displaying tracked changes, 60

File New Database dialog box, 896

file and saving as earlier format version, 11

Form window in Layout view, 973–974

Groove tools in own window, 153

Group, Sort, And Total pane, 1023

multiple windows in workbook, 385–389

Navigation Options dialog box, 797–798

new .docx documents in Word, 1161

presentation in earlier PowerPoint version, 529

presentations requiring passwords, 593

tables in Design view, 888

Trust Center, 45–47, 778–779

worksheet when sheet tabs invisible, 369

ZIP packages, 1150

operators

arithmetic expression, 921

Boolean, 868

defined, 393

“equal” comparison assumed in Access, 868

logical, 444

precedence for arithmetic, 923

rules of precedence in formulas, 393–394

using VBA, 1113–1114

option buttons

creating control for, 980

using, 1015–1016

Options dialog box.

See also specific application Options dialog box

about, 9

configuring OneNote passwords in, 126

modifying Visual Basic Editor with, 1085

opening from Microsoft Office Button, 34–35

Resources category in, 1197–1198

Send to OneNote page in, 107

OR logical function, 473

OR logical operator, 912, 913–916

OR (Oregon) state abbreviation, 912, 913–916

orientation

document page, 211

modifying printed slide, 626

report page, 1043–1044

text within text box, 268, 269

Orientation property, 881

.ost file format, 652

Out Of Office Assistant, 636–637

outer joins, 885

outline controls, 498

Outline Form for PivotTables, 496

Outline Tools group, 235–236

Outline view

adding headings in, 246

applying outline levels in, 246–247

displaying document in Print Layout and, 247–248

Document Map vs., 252–253

heading outlines don’t show up in, 239

promoting and demoting headings, 238, 247

viewing

comments in, 318

documents in, 239–241

outlines

controlling levels displayed, 243–244

creating, 242–243

displaying first text line in, 244–245

displaying in Outline and Print Layout views, 247–248

Document Map vs., 252–253

editing, 248–251

headings don’t show up in Outline view, 239

moving topics, 249–251

outlining text with WordArt, 552

printing, 251, 625

reasons to use, 237–239

removing page breaks in, 251

showing or removing formatting, 245–246

Tab key for inserting tabs vs. demoting headings, 242

techniques for, 236–237

tools for, 241

Outlining tab

about, 235–236

expanding or collapsing items from, 244

Outlook, 629–758.

See also e-mail

adding reminders to received messages, 679

alerts

adding, 744–746

configuring rules based on, 747–749

editing and deleting, 746–747

managing, 743–749

blocking external content, 686–689

changing shortcut properties for, 666, 667–669

collaborating with, 639–640

color categories in, 637–638

contacts

copying from SharePoint site to, 738–739

copying to SharePoint site, 740–741

flagging messages and, 678–683

linking to SharePoint Services, 736–738

managing, 646–647

marking for follow-up, 681–683

data storage and folders in, 649–650

digital certificates

digital signatures and, 661–662, 689–697

faster digital signature method, 703

installed from backup, 696

reading digitally signed messages, 704–705

encrypting messages, 662, 714–719

encryption certificates, 715–716

finding data storage files, 652–653

grouping messages in folder, 683

HTML message handling in, 685–689

illustrated, 644

increasing logon time with roaming profile, 653

Instant Search feature of, 633

IRM protection in, 720–724

Junk E-Mail Filter in, 73

mailbox management in, 684

managed folders, 637

Message tab in, 29

messaging

accessing Hotmail accounts with, 642, 657

extensible e-mail support, 643

integrating with Exchange Server, 641

protocols for, 654–659

unified mode of, 662

with, 641–644

Navigation Pane in, 631–632

new features

about, 14–15

Calendar changes, 634–636

changes in e-mail, 636–637

user interface changes, 629–633

Notes folder for, 649

OneNote with, 108–109

personal folders in, 650–651

Ribbon in, 630–631

roaming profile with, 652, 653

RUNAS command to start, 669–670

scheduling in, 644–646

search folders in, 675–678

security

attachment and virus, 660

features of, 685

global security options, 699–700

macro, 661

protecting against Web beacons, 659–660

security profiles, 700–702

security labels, 662

SharePoint files

downloading to, 751–752

editing in, 754–755

linking shared calendar, 742–743

opening in, 752–754

removing folders and, 756–757

SharePoint library connections with, 750–751

sharing

business cards, 640

calendars, 15, 635, 640, 742–743

storage files, 653–654

startup

automatic, 665

changing shortcut properties, 667–669

changing user context with RUNAS command, 669–670

choosing view on startup, 671–673

command-line switches, 670–671

creating desktop shortcut to, 665–666

creating shortcuts to new items, 673–674

normal, 663

Quick Launch bar, 666

safe mode, 663–665

task management in, 647–648

To-Do Bar in, 14, 632

tracking events in journal, 648–649

working offline in, 651–653