1293
Index
indexed tables, 117
natural, 118–119
null values, 113
single, 118
surrogate, 118–119
designing databases, referential integrity
application-specific, 126–127
cascading deletes, 123–125
cascading updates, 123–125
definition, 112
enforcing, 119–125
entity integrity, 115
ignoring, 123
null values in primary keys, 113
orphaned records, 114
overview, 112–113
primary keys matching foreign keys, 114
table conflicts, resolving, 124
designing databases, table relationships. See also join tables.
connecting data, 105–107. See also primary keys.
creating, 119–125
deleting, 126
equi-joins, 122–125
flat-file databases, 104–105
join tables, 111
join type, specifying, 122–125
many-to-many, 110–111
one-to-many, 108–110
one-to-one, 107–108
outer joins, 122–125
parent/child, 108–110
viewing, 125–126
designing dialog boxes
always on top, 704
borders, 704
Cancel buttons, 706
closing the form, 707
for collecting information, 703–707
control menu, removing, 706
default buttons, 706
deleting pages, 701
filtering criteria, 700
inserting pages, 701
modality, 704
property settings, 704
designing dialog boxes, tab control
labels on tabs, 702
overview, 700–703
pictures on tabs, 702DEP (Data Execution Prevent) mode, 937
dependency, 98
deploying applications. See distributing applications;
SharePoint deployment.
Description property, 651, 1073
descriptive names, naming conventions, 40
deselecting controls, 272
Design tab, 45–47, 314
Design view, 37, 292
designing databases, five-step method. See also databases.
data design, 16–18
foreign keys, 20–21, 114. See also primary keys.
form design, 22
linking tables, 20–22
needs analysis, 14
normalization, 20, 22
numeric field calculations, 18
overall design, 13–14
overview, 13. See also specific steps.
primary keys, 20–21. See also foreign keys.
report design, 14–16
table design, 19–22
unique identifiers, 20–21
designing databases, normalizing data
1NF (first normal form), 95–97
2NF (second normal form), 97–102
3NF (third normal form), 102
calculated data, removing, 102–104
decomposition, 99
deletion anomalies, 103
denormalization, 102–104
dependency, 98
flat-file approach, 95–97
insertion anomalies, 103
overview, 94–95
redundant or repetitive data, 95–97
splitting into tables, 97–102
update anomalies, 99, 103
designing databases, overview, 92–94
designing databases, primary keys
adding records to tables, 119
benefits of, 117
choosing, 115–116
composite, 118
creating, 115, 119
definition, 105
deriving, 116
designating, 118–119
importance of, 11552_475348-bindex.indd 129352_475348-bindex.indd 1293 4/1/10 2:01 PM4/1/10 2:01 PM