1279
Index
defining objects, 972–973, 978–980
for forms, displaying, 311
methods, 976–978
naming, 974–975
overview, 973–974
properties, 975–976
Class_Initialize event procedure, 997–998
Class_Terminate event procedure, 998–999
ClearMacroError action, 562
Click event, 455, 460
client-centric network applications, 754–756
client/server architecture
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
Clipboard group
Access 2010 ribbon, 36
copying tables, 86–88
Datasheet ribbon, 220
Form ribbon, 292
Form view, 292
Close button, displaying on forms, 307
Close Button property, 307
Close event, 457, 461caret (^), exponentiation operator, 175
Cartesian products, creating, 169–170
cascading
deletes, 123–125
updates, 123–125
case conversion
date/time fields, 64
with input masks, 67
text and memo fields, 64
Case Else clause, 404
case sensitivity
Access, 48
alias references, 947
SQL keywords, 476
VBA variable names, 423
XML for the ribbon, 1035
CD-ROM
accessing files, 1268
contents, 1268–1269
eBook version of Access 2010 Bible, 1269
example files, 1268–1269
installing, 1268
support for, 1270
system requirements, 1267–1268
troubleshooting, 1269–1270
cell gridlines
hiding/showing, 220, 239, 293
modifying appearance of, 240
snapping to the grid, 276–277
centering
forms, 307
report titles, 736
Change event, 460
changing. See editing; modifying; updating.
check boxes. See also controls; specific check boxes.
on the ribbon, 1039–1040
tallying true responses, 688
toggling values, 231
Check for Truncated Number Fields check box, 1084,
1088
checking table links, 606–607
CheckLInks function, 606–607
child/parent table relationships, 108–110
class events, 997–999
class interfaces, managing, 983–985
class modules. See also events; OOP (object-oriented
programming); Product class.
adding to databases, 974–975
bulletproofing property procedures, 980–98152_475348-bindex.indd 127952_475348-bindex.indd 1279 4/1/10 2:01 PM4/1/10 2:01 PM