I

I Want The Combo Box To Look Up The Values In A Table Or Query option (Combo Box Wizard), 602

I-bar, 802–803

icons

action query, 490

asterisk, 390

Blank Database, 148

delete query, 490

filter, 408

font name, 649

linked data source, 260

linked SharePoint Services table indicator, 1193

make-table queries, 490

mouse pointer

crosshairs, 581, 643

double arrow, 580, 581

hourglass, 897

rectangular, 352, 353

pencil, 390, 1229

viewing filter, 408

@@IDENTITY system variable, 1531, 1533, 1534, 1535

If…Then…Else statement, 1021–1022

IF/ELSE statements, 1531, 1532

Ignore Duplicate Key check box (Properties dialog box), 1473, 1474

IIS (Internet Information Services), 1159

images

embedding photographs in reports, 744–745

loading into custom Ribbon controls, 1299–1300

missing graphic on Web page, 1150

Immediate window (VBE), 952–956

executing Visual Basic commands in, 952–953

illustrated, 945, 955

using breakpoints in, 954–956

IMP operator, A55, A56

Import Objects dialog box, 269, 272

Import Specification dialog box, 291

Import Spreadsheet Wizard, 277–279, 280

Import Text Wizard, 287–290, 291

Import XML dialog box, 1255

importing.

See also collecting data via e-mail

Access objects, 271–273

dBASE files, 260–264

linking vs., 259–260

modifying imported tables, 292

objects with macro action, A116, A117

Paradox files, 265–266

reasons for, 253

SharePoint list to Access, 1186–1191

spreadsheets, 273–282

fixing errors in imported data, 280–282

preparing for import, 274–275

SQL tables, 266–270

text files, 282–291

XML files, 1254–1260

.xsd files, 1255

ImportXML command, 1256

IN clause

Access’ addition of, A34

overview, A46-A47

IN operator, 169, 360–361

IN predicate, A47-A48

indenting Visual Basic coding, 948–949

indexes

about, 99

adding project, 1471–1475

creating unique, 1473

defined, 188

ignoring duplicate key for unique, 1474

limitations of, 201

multiple-field, 190–191, 1219

selecting imported spreadsheet fields for, 278

single-field, 188–189

Indexes window, 190

Indexes/Keys tab (Properties dialog box), 1472, 1473, 1475

infinity symbol, 185

InfoPath forms, 327–337

allowing multiple rows per reply, 314–315

choosing to use, 307–308, 328–329

collecting new or updated data, 329–330

compatibility with Internet Explorer, 1342

data collection steps with, 327–328

deleting records in, 340

filling out, 337–341

HTMLformsvs., 327

managing and resending data messages, 343–345

multiple records within, 314

processing replies

manually, 341–343

methods for, 331–332

selecting source and table for e-mail address, 332–334

sending messages, 336–337, 340–341

specifying data to collect, 330–331

warning messages for, 335–336

writing message for, 334–335

information, A10

inheritance, 354

In-Line Function tab (Properties window), 1518

in-line functions, 1513–1519

available properties for, 1517–1519

building, 1514–1516

constructing to create updatable recordsets, 1514

declaring parameter to filter, 1515, 1516

defined, 1493

input parameters to control data returned with, 1561–1565

reasons for using, 1513

server filters with forms bound to, 1558

testing, 1516–1517

INNER JOIN statement, A42

inner joins, 414–421

defined, 414

editing fields on one side of, 419

selecting tables for, 415

input for application tasks, All

Input Mask property, 1063

Input Mask settings, 661

Input Mask Wizard, 171–174

input masks

limitations of, 174

list of characters for, 170–171

missing characters in, 174

placeholder characters for, 171, 172

storing formatting characters with data, 173

time values prevented with, 361

unable to set defined default value in date/time field, 1063

input parameters

server filters vs., 1572

setting for forms, 1561–1565

using in project reports, 1572–1577

using separate queries with filters vs., 1563

Input Parameters property, 1574–1575

Insert ActiveX Control dialog box, 727–728

Insert Hyperlink dialog box, 400, 547

Insert SQL button, 1530

INSERT statement (append query), A73-A75

Insert Subdatasheet dialog box, 389

inserting

control labels, 581

fields, 220–222

files in attachment fields, 546

hyperlinks, 398–400

Install Now button, 1346

Installation Options tab (Microsoft Office dialog box), 1344, 1348

installing software, 1341–1360

converting from previous release of Access, 1358–1360

hardware requirements for, 1341

Microsoft Office system, 1342–1349

entering information on User Information tab, 1345–1346

options for first-time installations, 1342–1347, 1348

setting default location on File Location tab, 1345

starting setup program, 1342

SQL Server 2005 Express Edition, 1349–1358

upgrading previous Office version, 1347–1349

instances, 5,

International Organization for Standardization (ISO), 1128, 1236

Internet Explorer

browser’s rendering of tags, 1131

color names in, A93-A99

display of complex Web page, 1134

downloading SharePoint database with, 1224

simple Web page in, 1130

version compatible with Office, 1342

viewing HTML behind Web page, 1128

Internet Information Services (IIS), 1159

Internet Protocol (IP), 1137

Internet SMTP/POP3 service, 1341

intervals

settings for DateDiff function, 365–366

using values in DatePart function, 365

IP (Internet Protocol), 1137

IPX/SPX protocol, 1138

IRibbonUI methods, 1298

IS NOT NULL operator, 168, 169

IsNothing function, 1056

IsNull function, 930–931

ISO (International Organization for Standardization), 1128, 1236

Issue List form, 24

Issues list (SharePoint Services), 1230, 1233

Issues Sample database

categories listed for, 49

customizing categories for, 54–55

opening, 46

selecting, 23

Issues template, 152, 153