1306
Index
phone numbers, 66–68
Social Security numbers, 66–68
insert mode versus overtyping, 690
Insert Page method, 701
Insert Rows button, 46
inserting
data in Word, 806
pictures in Word, 807
records, 46
records in databases, 88
insertion anomalies, 103
insertion point, moving, 231
installation tools, 906
installing CD-ROM files, 1267–1270
Integer data type, VBA, 428
Integer size numeric fields, 52
integrity of data. See referential integrity.
Intellisense, 395–397
interactive filter dialog boxes, 892–894
Interval property, 363
Is Not Null operator, 188, 206–208
Is Null operator, 185, 188, 206–208
Item property, 407J
join issues, 1177
join tables. See also specific types.
Cartesian products, creating, 169–170
default, 165
definition, 111
description, 165
equi-joins, 122–125, 165–166
left outer, 166
orphaned records, 166
outer, 122–125, 166–167
right outer, 166–167
self-joins, 167–169
join tables, query joins
ad hoc, 161–162
auto-join line, 161
Cartesian products, 161, 164
creating, 160–161
deleting, 164
equi-joins, 160
outer, 163
type, specifying, 162–163
Join Type button, 122
justifying data in datasheets, 220–221importing ribbon customizations, 1022
In operator, 184–185, 188, 203–204
inadequate disk space, 920
Increase Horizontal command, 277
Increase Vertical command, 277
indenting code, 411
indenting lines of code, 418
Indexed property, 60, 72–73
indexed tables, 117
indexing
data types, 50
fields, 72–73
Memo fields, 73
OLE Object fields, 73
indexing tables
drawbacks, 83
effect on performance, 81
entry order, 79
IgnoreNulls property, 82
ignoring null values, 82
importance of, 80–81
indexes as primary keys, 82
naming the index, 81
natural order, 79
overview, 78–79
physical order, 79
Primary property, 82
properties, setting, 82–83
simple indexes, 79
table scans, 80–81
Unique property, 82
uniqueness, specifying, 82
when to index, 83–84
infinity symbol (∞), table joins, 159, 161
information flow, 912–915
.ini files
integer values, getting, 964
string values, getting, 963–964, 965
writing to, 965–966
INNER JOIN...ON expression, 480–484
inner joins. See equi-joins.
Input Mask property, 59, 66–68
Input Mask Wizard, 67–68
input masks
creating, 67–68
on Date/Time data, 225
formatting with, 67
Input Mask property, 66–68
Input Mask Wizard, 67–6852_475348-bindex.indd 130652_475348-bindex.indd 1306 4/1/10 2:02 PM4/1/10 2:02 PM