Microsoft Access 2010 Bible

(Rick Simeone) #1

1294


Index


deleting pages, 701
filtering criteria, 700
inserting pages, 701
modality, 704
property settings, 704
digital certificates, 935–936
digital signatures, 935
Dim keyword, 421, 425–426
dimensions. See resizing.
Dirty event, 458–459, 460
disabled fields, editing, 232
Disconnect event, 464
Display Form drop-down list, 1084, 1085
display forms. See forms, data display.
Display Navigation Pane check box, 1089
Display Status Bar check box, 1084, 1086
Display Text property, 66
displaying
fields in queries, 145–147
recordsets, 140–141
selected data, 134
displaying data. See datasheets; forms; reports.
displaying fields
field display width, modifying, 237
rearranging fields, 235–236
resizing field width, 237
displaying records
display width, modifying, 238
height, modifying, 238
hiding/showing records, 237
DISTINCT SQL predicate, 478–479
DISTINCTROW SQL predicate, 479–480
distributed installation, network applications, 753
distributing applications. See also SharePoint deployment.
in compiled state, 851–854
Name Autocorrect options, 1084, 1091–1092
table/field names, automatic correction, 1091–1092
testing requirements, 1092–1093
distributing applications, 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, 1085
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

designing dialog boxes, tab control (continued)
selected tabs, identifying, 702
tab size, setting, 702
tabs, as command buttons, 702
designing forms
animation, 688–690
automatic closing, 691
background pictures, 697–699
bound to SQL statements, 690
combo boxes, 691–693
common objects, 22
control tip help, 697
ControlSource versus RowSource, 691–693
date/time, adding, 694
for faster refresh, 690
filtering options, 699–700
form events, 699–700
format painter, 696–697
image control, 695
inserting versus overtyping user input, 690
list boxes, 691–693
logos, adding, 695
morphing controls, 695–696
open state, determining, 693
page numbers, adding, 694
Tab key behavior, 22
tallying true check box responses, 688
toggling properties, 690–691
designing tables. See also creating tables.
example, 44–45
process overview, 41
Table Design button, 42, 43–45
Table Design window, 44–45
Dest Connect Str property, 653
Destination DB property, 653
Destination Table property, 653
Detail section, 341–342, 344, 370–371
development process, 900
dialog boxes. See also specific dialog boxes.
interactive filters, 892–894
linking to forms, 894
dialog boxes, designing
always on top, 704
borders, 704
Cancel buttons, 706
closing the form, 707
for collecting information, 703–707
control menu, removing, 706
default buttons, 706

52_475348-bindex.indd 129452_475348-bindex.indd 1294 4/1/10 2:01 PM4/1/10 2:01 PM

Free download pdf