Index_A

A

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