Access Help button
PivotChart toolbar, 172
PivotTable toolbar, 166
Access Menu Wizard, 210
Access Merge subfolder, 384
Access Page Setup dialog box, 190
Access toolbar, adding Visual Basic Editor button to, 365
Access 2000
AutoCorrect feature, 302
data, exporting, 434–437
discussed, 251–252
toolbars, adding Visual Basic Editor button to, 365
Word data, importing, 413–417
accessing
Expression Builder, 68
References dialog box, 255
Toolbox, 79
acCmdSizeToFitForm command, 55
acDetail constant, 199
acGroupLevel1Footer constant, 199
acGroupLevel1Header constant, 199
acGroupLevel2Footer constant, 199
acGroupLevel2Header constant, 199
acHeader constant, 199
acPageFooter constant, 199
acPageHeader constant, 199
action queries
append, 136–139
delete, 146–147
make-table, 145
update, 139–143
ActiveInspector property, 484
ActiveX
ActiveX Control command (Insert menu), 112
DateTimePicker control, 117
MonthView control, 118
Add New button (Add-In Manager dialog box), 45
Add Reference dialog box, 258
Add-In Manager dialog box
Add New button, 45
Change Menu Picture option, 206
Create Main Menu option, 206
discussed, 44
Refresh Lookup Tables option, 206
add-ins
Design Schemes, 44–45
error messages, 53
LNC Rename, 51–52
Menu Manager
basUtilities module, 226
installing, 205–206
menus, creating, 302
references, 206–208
running, 208–212
Outlook Automation, 483
Rename Database Objects, 295–296
Rename Form Controls, 295–296
Addins command (Tools menu), 44, 205
addresses
address books, reports, 190
address data, concatenating and splitting, 335
add-to comboboxes, 90–93
Advanced tab (Options dialog box), 252
AfterUpdate event procedure, forms, 72
aggregate functions, totals queries, 127–128
alignment, forms
labels, 47
left alignment, 48
AllowAdditions property, 232
AllowZeroLength property, 340
alphabetical sorting, 208
ALTER TABLE statement, 150
Another Database option (Append dialog box), 333
Append Data to Existing Table option (Paste Table As dialog box), 352
Append dialog box, 138, 333
append queries, 136–139, 338
applications
data, gathering, 4–5
editing, 247–248
application-specific changes, client-requested changes, 261–265
Apply Picture button (Menu Sidebar Picture Picker dialog box), 208
appointments
AppointmentItem object, 428
Appointments option (Import Exchange/Outlook Wizard), 434
contacts, adding, 447–449
appOutlook variable, 256
arguments
methods and, 368
values, setting, 370
ascending sort order, 122, 165, 172
asterisk (*), 141
attachments
faxes, sending, 532–536
mail messages, 434
AutoCalc button
PivotChart toolbar, 172
PivotTable toolbar, 165
AutoCorrect feature, Access 2000, 302
AutoFilter button
PivotChart toolbar, 172
PivotTable toolbar, 165
automatic reception, sending faxes, 548
automation
Automation code
Excel, 498
Outlook, 425–426
Word documents, 364
automation commands
discussed, 371
Excel, 503
Outlook, 430
Automation sessions, initiating, 371
problems, avoiding, 420–424
autonumber data type, 16
autonumber tags, 292
AutoReport selection (Report Wizard), 176–177
Avg function, 127