1272
Index
forms, 859–861
With function, 864
IIF function versus If...Then...Else, 864
list boxes, 861
marking records with bookmarks, 866
memory, 856
modules, 862–866
network performance, 866–867
overview, 854–855
queries, 858–859
reports, 859–861
Requery method versus Requery action, 864
resolving references, OLE automation, 864
routines, 863–866
swap files, 856
table indexes, 856–858
tuning the system, 856
unused variables, removing, 866
.accdb files
format description, 844–846
security, 752
.accdb files, SharePoint deployment
copying the file, 1145
eliminating the file, 1156–1173
.accde files
application demos, 847
converting to normal database files, 847
creating, 847–848
distributing, 846–848
restrictions, 847
.accdr files, 1093
accelerator keys, enabling, 1087
Access 2010 Bible, eBook on the CD-ROM, 1269
Access Data Projects (ADPs). See ADPs (Access Data
Projects).
access errors, 837–838
Access Options dialog box, 650
Access ribbon. See the ribbon.
Access Services
overview, 1140–1141. See also SharePoint.
SharePoint deployment, 1157
Action Catalog, 557–562
action queries
creating, 671–675
data-type errors, 676
definition, 133
key violations, 676@ (at sign), required character indicator, 64
\ (backslash), literal text indicator, 60, 67
^ (caret), exponentiation operator, 175
$ (dollar sign), formatting currency fields, 62
= (equal sign), Date comparison operator, 152
! (exclamation point), Not operator, 195–198
>= (greater-than, equal), greater-than-or-equal-to
operator, 177
<= (less-than, equal), less-than-or-equal-to operator, 177
% (percent sign), formatting percentages, 62
+ (plus sign), addition operator
calculating fields, 173
concatenating strings, 173, 179
description, 173
in select queries, 188
##### (pound signs), in numeric fields, 1088
‘...’ (single quotes), criteria string indicator, 194
_ (underscore), continuation character, 389, 418–419
∞ (infinity symbol), table joins, 159, 161
0 (zero)
placeholder, 62
required digit indicator, 67
1NF (first normal form), 95–97
2NF (second normal form), 97–102
3NF (third normal form), 102
9 , optional digit indicator, 67A
a, optional letter or digit indicator, 67
A, required letter or digit indicator, 67
absolute speed. See also optimizing applications; perceived
speed.
changing variables, 864
closing unused applications, 856
combo boxes, 861
compacting databases, 855–856
comparing variables, 864
control variables, 864–865
data types, 862–863
dead code, removing, 866
definition, 854
defragmenting hard drives, 856
For Each function, 864
field variables, 865
finding data in code, 865–866
FindNext method, 865–866
FindRecord method, 865–86652_475348-bindex.indd 127252_475348-bindex.indd 1272 4/1/10 2:01 PM4/1/10 2:01 PM