1336
Index
title-bar, forms
captioning, 306
specifying text for, 303
title-bar text
getting, 960
setting, 961–962
specifying, 1085
Toolbar property, 311
toolbars. See Quick Access Toolbar; the ribbon.
ToolTips. See SuperTips.
Top property, 683
TOP SQL predicate, 480
Top Values property, 651
top(n) queries, 133
top(n) records, 644–646
total queries, 133
Total row options, 654
totaling values. See aggregate functions.
tracing execution path, 549
tracking
DAO object model transactions, 501
graphical objects, 950
macros, 552
tracking macros, 552
transaction tracking, 501
transactional requirements, SharePoint, 1143
transactions, network applications, 755–756
transparent borders on reports, 360
trapping custom events, 1003–1004
triggers
server database engines, 1188
SQL Server, 1221
troubleshooting. See also debugging; error handling; testing.
See also bugs
See also Compatibility Checker
See also debugging
See also error handling
See also testing
action queries, 676
CD-ROM, 1269–1270
hardware errors, 920
inadequate disk space, 920
memory errors, 920
usage logs, 920–923
virtual memory, 920
troubleshooting, applications
hardware errors, 920
inadequate disk space, 920Text data type
converting from AutoNumber, 58
converting from Date/Time, 58
description, 51
group headers, 362
purpose, 48
storage size, 49
Text data type, converting to
Currency, 58
Date/Time, 58
Number, 58
Yes/No, 58
Text fields
formatting, 64
line breaks, inserting, 231
query selection criteria, 150–151
size, specifying, 51
text files, importing
CSV (comma-separated values), 618–623
duplicate primary keys, 621
field separators, 620
fixed-width files, 621–623
text files, linking to, 587, 604–606
text formatting
in controls, 314
in datasheets, 220–221
Text Formatting group
Access 2010 ribbon, 36
Datasheet ribbon, 220–221
Form ribbon, 293
text tables, linking to, 583
text-box data-entry fields, 22
themes
new features, 1261
selecting for reports, 331–333
Windows themes, enabling, 1088
thousands separator, specifying, 62
3NF (third normal form), 102
three-tiered architecture, 1193–1194
tiers, architectural, 1193
tiling pictures on forms, 308
time data type. See Date/Time data type.
Time Delimiter option, 625
Time event, 688–690
Timer event, 457, 464
TimerInterval event, 464
timing events, 45252_475348-bindex.indd 133652_475348-bindex.indd 1336 4/1/10 2:02 PM4/1/10 2:02 PM