1274
Index
Group By fields, criteria for, 662
Group By option, 655, 661–662
highest/lowest field values, finding, 657
Last option, 657
Max option, 657
Min option, 657
non-aggregate total fields, criteria for, 663–664
population variance, calculating, 657
QBE pane, hiding/showing Total row, 654
Query Criteria option, 655
standard deviation, calculating, 657
StDev option, 657
Sum option, 657
summary of, 656. See also specific functions.
Total row options, 654
totaling all records, 657–658
totaling field values, 657
totaling groups of records, 659–662
Var option, 657
Where options, 656
Aggregate option, 655
aggregate total fields, criteria for, 663
Aggregate Total fields, criteria for, 663
alerts, SharePoint, 1138
aliases (field names)
referencing, 649
specifying, 144–145
Align Center command
Datasheet ribbon, 220
Form ribbon, 293
Align Left command
Datasheet ribbon, 220
Form ribbon, 293
Align Right command
Datasheet ribbon, 220
Form ribbon, 293
aligning
control labels, 736
controls, 275–277, 314
data in datasheets, 220–221, 241
displays, 60
pictures on forms, 308
report control labels, 736
snapping to the grid, 276–277
text, 60, 220, 293
All Access Objects option, 36
All Records option, 766
ALL SQL predicate, 478
Allow Additions property, 310ADO object model, Recordset object (continued)
current record pointer, 495
cursor type, specifying, 496–497
CursorType parameter, 510–512
CursorType property, 496–497
Edit method, 512
EOF (end-of-file indicator), 497–498
MoveNext method, 497–498
MovePrevious method, 497–498
navigating recordsets, 495
Open method, 510–512
opening a table, 510
overview, 494–495
RecordCount property, 498–499
RecordsetNavigation procedure, 495
Source parameter, 510–512
Update method, 512
adOpenDynamic cursor, 497
adOpenForwardOnly cursor, 497
adOpenKeyset cursor, 497
adOpenStatic cursor, 497
.adp file type, 5
ADP objects, versus Access objects, 1233–1235
ADPs (Access Data Projects), 1223. See also
Upsizing Wizard.
AfterDelConfirm event, 458–459
AfterEventUpdate event procedure, 509–513
AfterFinalRender event, 464
AfterInsert event, 458–459
AfterLayout event, 464
AfterRender event, 464
AfterUpdate event, 458–459, 460
aggregate functions
datasheets, 247–248
Excel spreadsheets, 247–248
aggregate functions, in queries
Aggregate option, 655
aggregate total fields, criteria for, 663
Aggregate Total fields, criteria for, 663
averaging field values, 657
Avg option, 657
Count option, 657, 658
counting field values, 657
crosstab queries, 666–670
definition, 655
Expression option, 655, 656
expressions for totals, 664–666
First option, 657
first/last field values, finding, 65752_475348-bindex.indd 127452_475348-bindex.indd 1274 4/1/10 2:01 PM4/1/10 2:01 PM