See also specific methods
closing, 486
LockEdits parameter, 706
overview, 485
Recordset Type property
of forms, 289
of queries, 590
recordsets
asterisk in, 149
benefits of not saving, 128
changing sort order, 139??“141
defined, 124, 128, 1179
displaying, 134??“135
overview, 128
printing, 144
rules for updating queries, 150
Rectangle controls, 246. See also controls
referential integrity
in Access Auto Auctions database, 107
application-specific rules, 121??“122
Cascade Delete Related Records option, 120
Cascade Update Related Fields option, 120
defined, 106, 107
for deleting records, 435
enforcing, 116, 118??“120
first rule (no null values in primary keys), 108
general relational model rules, 108??“109
join lines showing, 146
need for, 106, 107, 108, 109
for one-to-many relationships, 103
overview, 106??“109
in partial replicas, 1034
rules enforced by Jet database engine, 106, 108
second rule (foreign keys matched by primary keys),
108??“109
unmatched parent records allowed, 109
using SQL Server triggers for, avoiding, 1248
RegCloseKey API function, 985
RegCreateKeyEx API function, 980??“982
RegDeleteKey API function, 985??“986
RegFlushKey API function, 984
Registry, API functions for, 980??“986
RegQueryValueEx API function, 984??“985
RegSetValueExA API function, 982??“984
relational (comparison) operators
for Date/Time fields in queries, 143
descending index with, 840
equal (=), 165
greater than (>), 166
greater than or equal to (>=), 166??“167
less than (<), 166
less than or equal to (<=), 166
list of, 165
not equal (<>), 166, 179
Null return for, 165
numeric value returned for, 165
order of operators important for, 166, 167
with Partial Replica Wizard, 1027??“1028
precedence, 174
in queries, 176??“177, 179
relational database management system (RDBMS), 4
relational databases, 7
relationships.
Pages:
2402
2403
2404
2405
2406
2407
2408
2409
2410
2411
2412
2413
2414
2415
2416
2417
2418
2419
2420
2421
2422
2423
2424
2425
2426