1289
Index
databases, splitting for network applications
benefits of, 759–761
Database Splitter wizard, 762–764
definition, 753
placing objects, 761–762
DataChange event, 464
data-entry forms. See forms, data entry.
DataSetChange event, 464
Datasheet button, 262
Datasheet command, 253
Datasheet Formatting dialog box, 240
Datasheet ribbon
Align Center command, 220
Align Left command, 220
Align Right command, 220
Alternate Fill/Back Color command, 220
Clipboard group, 220
Copy command, 220
Cut command, 220
Find group, 220
Gridlines command, 220
Home tab, 219–221
Paste Append command, 220
Paste command, 220
Paste Special command, 220
Records group, 220
Size to Fit Form button, 220
Sort & Filter group, 220, 242–246
Switch Windows button, 220
Text Formatting group, 220–221
Views group, 219
Window group, 220
Datasheet view
deleting records, 234–235
description, 42–43
enabling, 306
illustration, 42
new features, 1259–1261
switching to, 291, 300
Datasheet window
overview, 217
padlock icon, 223
pencil icon, 223
record pointers, 223
Datasheet window, navigating. See also Navigation Pane.
within a datasheet, 218
finding specific values, 228–229
keystrokes for, 218
Navigation buttons, 218–219database objects. See also specific objects.
data-entry forms, 11–12
datasheets, 10
display forms, 11–12
macros, 10
modules, 10
queries, 10–11
reports, 12
Database Splitter wizard, 762–764
dataBased Intelligence, Inc., 631
databases
See also fields
See also records
See also tables
See also Upsizing Wizard
compacting, 874–875, 1087
compiling, 874–875
computerized versus manual filing systems, 4–5
default file format, 845–846
definition, 4–5
file types, 5
flat file, 95–97, 104–105. See also spreadsheets.
naming conventions, 8, 29–30
opening exclusively, 756–758
RDBMS (relational database management system), 5
recompiling automatically, 877
recreating, 874–875
specifications, 1247
versus spreadsheets, 92–94
uncompiled, detecting, 877–878
databases, dBase
browsing to, 631–632
data type conversions, 632
importing from multi-user environments, 631–632
linking to, 587
databases, optimizing
average size, 872
compacting, 874–875
compiling, 874–875
corrupted forms, 874
decompile option, 876
growth rate, 873
memory leaks, 874
minimizing changes, 879
pre-release steps, 877
rebooting, 874
recompiling automatically, 877
recreating, 874–875
uncompiled databases, detecting, 877–87852_475348-bindex.indd 128952_475348-bindex.indd 1289 4/1/10 2:01 PM4/1/10 2:01 PM