A

Index

[A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

.accdb file extension 2nd
ACCDE (Access Database Executable) files
     defined 2nd
     distributing databases as
     saving databases as
Access
     closing
     Help button
     integration with other Office programs
    objects [See Access objects]
     portability of skills
     size restrictions, viewing
     specifications, viewing
     starting
     starting, on Windows XP
     versions of, outdated, updating databases from
Access button (Import group)
Access Database Executable (ACCDE) files
     defined 2nd
     distributing databases as
     saving databases as
Access objects
     defined 2nd
     displaying all instances of
     events recognized by
     export formats available for, viewing
     exporting
    importing [See importing]
    forms [See forms, AutoForms]
    macros [See macros]
    modules [See modules]
    queries [See queries, action queries, append queries, crosstab queries, delete queries, make-table queries, select queries, update queries]
    reports [See reports]
    shortcuts, creating with custom groups [See custom groups]
    tables [See tables]
     uses for
    views [See views]
Access Options window
action queries [See also append queries, crosstab queries, delete queries, make-table queries, select queries, update queries, queries]
     converting select queries to
     creating 2nd
     defined 2nd
     types of
actions
     basic
     defined
     for objects, displaying list of
Add Existing Fields button
Add Group button
Add Item button
add-ins for exporting to PDF/XPS files
address books (Outlook), importing from
Advanced Filter Options button 2nd
Advanced Filter/Sort command
aggregate functions 2nd
Align Left button
Align Text Left button
aligning
     form controls 2nd
     report columns
     report text 2nd
Allow Zero Length field property
Analyze Table wizard
analyzing performance 2nd
And operator
append queries 2nd [See also action queries, crosstab queries, delete queries, make-table queries, queries, select queries, update queries]
applications, database
     defined
     macros in
     specialized commands in
    templates for [See templates]
     when appropriate
Apply Filter button
arithmetic operators
     & (concatenate)
     * (multiply)
     + (add)
     - (subtract)
     / (divide)
arrows, button
AutoFormat dialog box
AutoFormat gallery
AutoFormats
     creating
     creating from forms
     form
AutoForms
automated functions [See macros]
AutoNumber data type
     defined
     Long Integer setting for
autonumber fields
Avg function