1335
Index
Tables option, 36
tabs (ribbon), customizing, 1016, 1020–1022, 1025–1026
TabStop property, 22
tabular forms, 260–261
tabular reports, 320
Tag property, 311, 782
tagging forms, 311
tags, naming conventions, 432
tblCustomers database, 55, 73–76
technical support for CD-ROM, 1270
telephone numbers, data types, 51
templates
creating databases, 26–27
SharePoint, 1131–1134
temporary files path, getting, 953–954
temporary tables, 1189
temporary variables. See also macros; variables.
enhancing macros, 1065–1066
mcrHelloWorldEnhanced macro, 1065
mcrReportMenuEnhanced macro, 1067–1068
RemoveAllTempVar action, 1065–1068
RemoveTempVar action, 1065–1068
removing, 1065–1068
SetTempVar action, 1065–1068
setting, 1065–1068
simplifying macros, 1066–1068
uses for, 1065
in VBA, 1068–1069
testing
See also bugs
See also Compatibility Checker
See also debugging
See also error handling
See also troubleshooting
VBA procedures in Immediate window, 399–401
testing applications
before distribution, 1092–1093
overview, 524–525
text boxes, on reports
adding, 352–359
control properties, 359–360
deleting, 354–355
moving, 354–355
resizing, 354, 360–361
text controls, expressions in, 353
Text criteria, 193–195
text data
entering, 225
numbers, sorting, 51join 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
table rows. See records.
TableDef object, 502–503
tables. See also creating tables; designing tables; updating
tables.
adding records, 88
adding records to, 119
changes, enabling, 1088
conflicts, resolving, 124
copying, 86–88
copying to another database, 87
copying within a database, 86–87
definition, 6
deleting, 86
design, printing, 84–85
enhanced export options, 1146–1156
examples, 6, 7
exporting to SharePoint, 1123–1127
field issues, 1179
indexed, 117
moving to SharePoint, 1127–1131
name issues, 1179
new features, 1258–1259
overview, 6–7
properties, specifying, 46–47
Property Sheet, 46–47
relationships, SharePoint deployment, 1174
renaming, 86
saving, 85
separating from applications, 1099–1100
SharePoint deployment, 1146–1156
specifications, 1247–1248
specifying to SQL, 480–484. See also FROM keyword.
splitting data into, 97–102
SQL Server, 1215–1217
temporary, 1189
tables, linking
foreign keys, 20–21
keys, 20–21
overview, 19–22
primary keys, 20–21
tables, multiple, 8. See also normalization.
Tables and Related Views option, 34–3552_475348-bindex.indd 133552_475348-bindex.indd 1335 4/1/10 2:02 PM4/1/10 2:02 PM