1285
Index
Check for Truncated Number Fields check box,
1084, 1088
Compact on Close check box, 1084, 1087
compacting the database on closing, 1087
Convert All Picture Data option, 1084,
1088–1089
Current Database tab, 1084
Display Form drop-down list, 1084, 1085
Display Status Bar check box, 1084, 1086
Document Window options, 1084, 1086–1087
Enable Design Changes check box, 1084, 1088
Enable Layout View check box, 1084, 1088
forms, selecting, 1085
layout view, enabling, 1088
overlapping windows, specifying, 1086–1087
personal information, removing on save, 1088
Picture Property Storage Format option, 1084, 1088–
1089
pictures, specifying storage format, 1088–1089
Preserve Source Image Format option, 1084,
1088–1089
Remove Personal Information check box, 1084, 1088
status bar, displaying, 1086
tabbed documents, specifying, 1086–1087
table changes, enabling, 1088
title bar text, specifying, 1085
truncated numeric fields, checking for, 1088
Use Access Special Keys check box, 1084, 1087
Use Windows-Themed Controls on Forms check box,
1084, 1088
Windows themes, enabling, 1088
Current Database tab, 1084
Current event, 458–459
current record pointer, 495
cursor
changing to hourglass, 1054–1055
type, specifying, 496–497
CursorType parameter, 510–512
CursorType property, 496–497
custom field formats, incompatibilities, 1179
Custom option, 34
Custom Ribbon ID property, 311
Customize the Ribbon window, 1020–1021
customizing the ribbon, limitations, 1016
customizing the ribbon defaults
commands, 1020–1022
Customize the Ribbon window, 1020–1021
groups, 1020–1022
importing/exporting customizations, 1022an SQL Server data source, 1204
table relationships, 119–125
unbound forms for network applications, 781
creating databases. See also designing databases.
default name, 30
naming databases, 29–30
new database screen, 29
tblCustomers database, 55
templates, 26–27
creating tables. See also designing tables.
Create ribbon tab, 42
Datasheet view, 42–43
Fields ribbon tab, 43
Table button, 42
Table Design button, 42, 43–45
creating VBA elements
event procedures, 397–399, 437–441
functions, 441–442
modules, 391–392
procedures, 395, 397–399, 436
subroutines, 437–441
cross-platform compatibility, 941
cross-products of tables. See Cartesian products.
crosstab queries, 133, 666–670
Crosstab Query Wizard, 667–670
cross-table products. See Cartesian products.
CSV (comma-separated values)
importing text files, 618–623
linking to, 596–597
Currency data type
automatic validation, 224–225
converting to Number, 58
converting to Text, 58
default value, 59
description, 53
entering, 226
group headers, 363
purpose, 48
storage size, 49
VBA, 428
currency fields, formatting, 61
Currency format, 61
Current Database options
accelerator keys, enabling, 1087
application icon, specifying, 1085
Application Icon field, 1084, 1085
Application options, 1084, 1085–1089
Application Title field, 1084, 108552_475348-bindex.indd 128552_475348-bindex.indd 1285 4/1/10 2:01 PM4/1/10 2:01 PM