1318
Index
embedded versus linked, 307
tiling, 308
Pivot Table command, 253
pivot tables, 464
PivotChart command, 253
PivotChart view, 292
PivotTable events, 464
PivotTable view, 291
PivotTableChange event, 464
placeholders, 62
plagiarism, user interface, 1095
plus sign (+), addition operator
calculating fields, 173
concatenating strings, 173, 179
description, 173
in select queries, 188
Pop Up property, 310, 704
populating unbound forms, 782–783
population variance, calculating, 657
pound sign (#)
Date comparisons, 152
hyperlink indicator, 65–66
optional digit indicator, 67
placeholder, 62
wildcard character, 181
pound signs (#####), in numeric fields, 1088
precedence
Boolean operations, 187
comparison operations, 186
mathematical operations, 185–186
Prefix Characters property, 362
prefixes, naming conventions, 40, 432
Preserve Source Image Format option, 1084,
1088–1089
previewing reports, 249, 335–340
primary keys. See also foreign keys.
adding records to tables, 119
benefits of, 117
choosing, 115–116
composite, 118
composite, setting, 77
constraints, 1175
creating, 115, 119
definition, 20–21, 105
deriving, 116
designating, 118–119
duplicate, 621
entity integrity, 76
importance of, 115pencil icon, 223
perceived speed. See also absolute speed; optimizing
applications.
definition, 867
forms, hiding versus closing, 868
hourglass cursor, 868
morphing forms or reports, 868
progress meter, 869–872
splash screens, 867–868
Percent format, 61
percent sign (%), formatting percentages, 62
performance. See also optimizing applications.
implicit variables versus explicit, 430
large collections, effects of, 408
network applications, 752
period (.)
date delimiter, 625
decimal points, 62, 67
in With keyword, 895
table and field name separator, 174
permissions, SharePoint, 1121
personal information, removing on save, 1088
pessimistic locking, 766, 769–772
phone numbers
data types, 50
formatting, 66–68
Picture Alignment property, 308
Picture property, 307, 702
Picture Property Storage Format option,
1084, 1088–1089
Picture Size Mode property, 307
Picture Tiling property, 308
Picture Type property, 307
pictures
copying, 296–297
form background, 697–699
graphical objects, data-entry forms, 22
graphical objects, tracking, 950
image control, 695
inserting in forms, 296–297
inserting in Word, 807
OLE Object data type, 49–50, 54, 58
resizing, 297
specifying storage format, 1088–1089
pictures, on forms
aligning, 308
as background, 307
display mode, specifying, 30752_475348-bindex.indd 131852_475348-bindex.indd 1318 4/1/10 2:02 PM4/1/10 2:02 PM