1325
Index
renaming
fields, 41, 57, 647–649
linked tables, 597
ribbon groups, 1020–1022
tables, 86
replacing ribbons, 1045–1046
Replication ID size numeric fields, 52
Report Design window, 337–338
report errors, 1175–1176
Report Footer section, 341–342, 345
Report Header section, 341–342, 343
report modules, 390
Report Wizard
alternate formats, 337
color schemes, 331–335
group data, defining, 326–327
group intervals, 327
grouping levels, selecting, 325–326
layout, adjusting, 330–331
layout, selecting, 329
multiple-page display, 336–337
new reports, 324–325
previewing the report, 335–340
Print Preview window, 335–337
printing the report, 338–340
report design, opening, 329–330
Report Design window, 337–338
saving the report, 340
sort order, selecting, 327–328
summary options, selecting, 328–329
themes, selecting, 331–333
reports. See also printing.
absolute speed, 859–861
adding data, 737–738
columnar, 321–322
control totals, 344–345
controls, naming, 749
controls, naming conventions, 285–286
converting from forms, 316
creating, 12
designing, 14–16
displaying in a combo box, 739–740
displaying selected data, 134
empty, avoiding, 728
versus forms, 322
hiding forms, 741
hiding/showing controls, 463
mailing-label, 322–323
memo data, 51redundant or repetitive data, 95–97
ReferenceFromFile function, 853–854
referential integrity
application-specific, 126–127
cascading deletes, 123–125
cascading updates, 123–125
definition, 112
enforcing, 119–125, 1162–1163
entity integrity, 115
ignoring, 123
null values in primary keys, 113
orphaned records, 114
overview, 112–113
primary keys matching foreign keys, 114
SQL Server conversions, 1231
table conflicts, resolving, 124
Refresh Interval option, 767
relational database management system (RDBMS), 5
relational databases, 5. See also databases.
relational operators. See comparison operators.
relationship errors, 1174–1175
relationships
for linked tables, setting, 598
SharePoint deployment issues, 1160–1164
relationships, between tables
connecting data, 105–107
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
Remove Personal Information check box,
1084, 1088
Remove Sort command, 243
RemoveAllTempVar action, 1065–1068
RemoveTempVar action, 1065–1068
removing. See also deleting.
fields from queries, 144
personal information on save, 1088
the ribbon, 1046
submacros, 1065–106852_475348-bindex.indd 132552_475348-bindex.indd 1325 4/1/10 2:02 PM4/1/10 2:02 PM