1275
Index
application programming interface. See Windows API.
application servers, versus Web servers, 1190–1192
Application Title field, 1084, 1085
applications
See also bulletproofing applications
See also distributing applications
See also network applications
See also optimizing applications
See also user interface
See also VBA
client/server architecture, 1186–1187
delivering to users, 905–907
ease of starting, 907–909
error handling, 822–823. See also debugging;
troubleshooting.
starting in runtime environment, 1093
testing, 524–525
ApplyFilter event, 458–459, 699–700
architecture, client/server
Access, as database repository, 1195–1196
Access, as Internet database, 1197
Access’s role in, 1189–1190
applications, 1186–1187
back office, 1187–1192
clustered indexes, 1189
connection pooling, 1191–1192
databases, 1187–1189
defining characteristics, 1195
identity fields, 1189
load balancing, 1191–1192
multi-tiered, 1192–1194
parallel processing, 1190
partition pruning, 1190
partitioning, 1190
versus splitting a database, 1193
stored procedures, 1188. See also class modules; data
macros.
system layout, 1184–1186
temporary tables, 1189
three-tiered, 1193–1194
tiers, 1193
triggers, 1188. See also class modules; data macros.
two-tiered, 1193
user-defined functions, 1188. See also class modules;
data macros.
views, 1189
Web servers, 1190–1192
argument prefixes, DLLs, 944
ArgumentList parameter, 947–949Allow Datasheet View property, 306
Allow Default Shortcut Menus check box, 1091
Allow Deletions property, 310
Allow Edits property, 310
Allow Filters property, 310
Allow From View property, 306
Allow Full Menus check box, 1091
Allow Layout View property, 306
Allow PivotTable View property, 306
AllowBypassKey property, 925
AllowZeroLength property, 60, 70–71
alphabetical report headings, 712–714
alphanumeric data type. See Memo data type; Text data type.
alternate displays, 34
Alternate Fill/Back Color command, 220
always on top
dialog boxes, 704
forms, 310
Always Use Event Procedures option, 391
ampersand (&)
any character or digit required, 67
concatenation operator, 173, 178–179, 188, 422
continuation character, 419
optional character indicator, 64
in select queries, 188
am/pm:, lowercase 12-hour format, 64
AMPM:, uppercase 12-hour format, 64
And operator
across fields in a query, 208–212
Boolean logic, 180
with Or operator, 211–212
results of, 182
in select queries, 188
specifying a range, 204–205
angle brackets (< >)
not-equal operator, 176, 188, 198–199
in select queries, 188
animation, forms, 688–690
anomalies, 99, 103
anonymous site access, SharePoint, 1141
a/p:, lowercase 12-hour format, 64
A/P:, uppercase 12-hour format, 64
API function prototype. See Declare statement.
Append Data to Existing Table button, 87
Append Query action queries, 671, 674
application icon, specifying, 1085
Application Icon field, 1084, 1085
Application options, 1084, 1085–1089
application parts, 126252_475348-bindex.indd 127552_475348-bindex.indd 1275 4/1/10 2:01 PM4/1/10 2:01 PM