I

iCalendar protocol, 659

icons

asterisk, 946

changing Outlook, 668

creating Outlook desktop, 665–666

Digitally Sign Message, 703

installation information conveyed with, 1195

OneNote, 114

outline symbols, 240

outline tool, 241

pencil, 946, 949

shortcut arrow, 797

split bar, 367, 368

idMso values, 1180

if…End If structures, 1111–1112

IF function

avoiding error values in formulas with, 475

creating conditional formulas with Conditional Sum wizard, 446–449

nested, 473

streamlining use of, 472

images.

See also graphics;

pictures

applying borders to selected, 289

inserting in notebook, 115–116

replacing with different file type, 1173

IMAP (Internet Message Access Protocol), 654–655

Immediate window

running code from, 1121

uses for, 1129–1131

Import/Export Digital ID dialog box, 693–694

importing

contacts to SharePoint site, 740–741

custom line to Horizontal Line gallery, 294

digital certificates, 697, 719

modules, 1127–1128

multimedia formats into PowerPoint, 605

In comparison operator for queries, 916–917

IN operator, 869

Inbox view (Outlook), 671, 672

indenting

code in VBA macros, 1112–1113

lines in SmartArt text pane, 555

INDEX function, 449–451, 481–483

Indexed property setting, 888–889

indexes

about table, 888

Access single-field, 888–889

database limitations for, 901

multiple-field, 890–891

INDIRECT function, 483

InfoBar (Outlook), 723, 724

InfoPath, 16, 22

information functions, 474–476

about, 474

COUNTBLANK, 474

IS, 475–476

TYPE and ERROR.TYPE, 474

Information Rights Management (IRM) service. See IRM (Information Rights Management) service

input boxes in VBA, 1117

input forms. See forms

Input Mask Wizard, 871–872

input masks

definition characters for, 870–871

missing characters in, 874

preventing input with incorrect, 874

selecting built-in, 872

setting up, 870–874

storing formatting characters with data, 872–873

Insert Calculated Field dialog box, 509, 510

Insert Calculated Item dialog box, 510, 511

Insert Chart dialog box, 579

Insert File dialog box, 265

Insert Function button, 353, 458

Insert Function dialog box, 406, 454, 459

Insert Hyperlink dialog box, 617, 956

Insert Subdatasheet dialog box, 945

Insert tab

Key Tips for Word’s, 31

placing PowerPoint text on slide, 545, 546

PowerPoint formatting options on, 532

WordArt text effects on, 551

inserting

Access tables and objects in presentation, 603–604

ActiveX controls, 982

blank lines with Border button, 289

breaks

column, 217

line, 420, 1133

page, 216

section, 218

in text wrapping, 217, 218

cell references in functions, 461

charts in PowerPoint file, 580

comments, 313–314

controls in manually-created reports, 1033–1034

Excel spreadsheet in presentations, 538

footers, 1028–1029

functions, 406, 458–461

headers in forms, 975

horizontal lines in document, 292–294

hyperlinks, 954–956, 981

image in notebook, 115–116

pictures

before or behind text, 564–565

in presentations, 561–562

as watermark, 260

screen clippings in notebook, 113

separator on Quick Access Toolbar, 775

spreadsheet in presentations, 538

tabs with Tab key, 242

text, into AutoShapes, 264–266

worksheets, 363–364

insertion point for active cell, 352

Installation Options tab, 1194–1195

installing

information conveyed with icons, 1195

Microsoft Office, 1191–1195

public key, 717

Windows Rights Management Services Client, 66–67

instant messaging, 182–184

Instant Search feature (Office), 633

INT function, 465–466

integer values for VBA, 1116

IntelliMouse, 371

international domain names, 637

Internet e-mail messaging, 641

Internet Explorer

backing up certificates with Certificate Export Wizard, 694–696

Certificates dialog box for, 708

errors preventing opening of ZIP packages in, 1162

installing digital certificate from backup copy, 696, 697

opening .rels file in, 1155

Rights Management Add-On, 720

sending Web page to notebook from, 112–114

working with XML files in, 1148

Internet Message Access Protocol (IMAP), 654–655

intersection operator, 419

intervals

options for manually setting group, 1027–1028

setting Report Wizard grouping, 1041–1042

intrinsic constants, 1099–1101

invalid digital certificates, 705

inviting participants to live sessions, 129

IRM (Information Rights Management) service, 65–69

about, 65, 590, 592, 720

availability of, 590

changing user account to manage, 69

limitations of, 66

obtaining certificate from Microsoft Passport, 721–722

restricting permissions

for Outlook, 721–723

PowerPoint content, 590–592

steps for, 67–69

viewing messages protected with, 723–724

working with multiple Passport accounts, 724

IS function, 475–476

IS NOT NULL operator, 869

ISERR function, 475

Issue Tracking tool, 158–160, 194, 195

 IssuesSample.accdb file, 765–766

Item drop-down menu, 732, 733