Index A

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

A (input mask) placeholder 
a (input mask) placeholder 
A11oltp.mbd application  2nd  3rd 
About Microsoft Access command
    (Help menu) 
AbsolutePage property
    Recordset object  2nd 
AbsolutePosition property
    Recordset object 
Access
    default settings  2nd  3rd 
        edit/find options  2nd  3rd 
        general options  2nd  3rd  4th  5th  6th 
        keyboard options  2nd  3rd  4th  5th 
        spelling options  2nd 
        view options  2nd 
    functions of  2nd  3rd  4th 
    operating modes  2nd 
Access 2000
    file compatibility  2nd  3rd 
    file structure 
Access 2002
    converting databases to  2nd 
        compile errors  2nd 
    file compatibility  2nd  3rd 
    file structure 
Access 2003
    .NET Framework and  2nd  3rd 
    date formats  2nd 
    features overview  2nd 
        ADP changes  2nd  3rd  4th 
        direct database backups  2nd 
        Help system  2nd  3rd  4th 
        InfoPath forms  2nd  3rd  4th  5th 
        macro security  2nd  3rd  4th 
        Office Web Components (OWC)  2nd 
        smart tags  2nd  3rd  4th 
        task panes  2nd  3rd  4th 
        Web services support  2nd  3rd  4th  5th 
        Windows SharePoint Services  2nd  3rd 
        XML data export/import operations  2nd 
    file compatibility  2nd  3rd 
    programmability enhancements  2nd  3rd  4th  5th 
Access 97
    converting databases to  2nd 
    file compatibility  2nd  3rd 
    file structure 
    macros 
access denied messages
    (Web services)  2nd 
    live Web reports 
Access modules  2nd  3rd  4th  5th  [See also modules]
    function names  2nd 
    john check pgs 
    references  2nd  3rd 
Access Project Security Manager (APSM) 
AccessKey values
    in table-based pages  2nd  3rd  4th 
acCmdApplyFilterSort argument 
acDialog argument 
acEdit argument 
acNormal argument 
action queries  2nd  [See also specific queries]3rd  4th 
    alternatives to
        browse-mode updating  2nd 
        form-based updating  2nd 
        SQL statements  2nd  3rd 
        stored procedures  2nd 
    make-table
        adding parameters  2nd  3rd  4th 
        creating  2nd  3rd 
    parameters, specifying  2nd  3rd  4th 
    syntax  2nd  3rd  4th  5th 
    upsizing  2nd 
    versus update queries  2nd 
Activate Product command (Help menu) 
Active Data Projects  [See ADP (Active Data Projects)]
Active Server Pages
    exporting tables to  2nd  3rd  4th  5th  6th 
ActiveCommand property
    Recordset object 
ActiveConnection property
    Command object 
    Recordset object 
ActiveX controls
    PivotCharts.  [See PivotCharts]
    PivotTables.  [See PivotTables]
ActiveX Data Object Extensions  [See ADOX]
ActualSize property
    Field object 
Acwzlib.mde file 
Acwzmain.mde file 
Acwztool.mde file 
ad hoc T-SQL statements
    versus pre-compiled query objects  2nd 
    WHERE clause contraints  2nd 
adAddNew constant 
adAffectAll constant 
adAffectAllChapters constant 
adAffectCurrent constant 
adAffectGroup constant 
adApproxPosition constant 
adBinary constant 
adBookmark constant 
adBookmarkCurrent constant 
adBookmarkFirst constant 
adBookmarkLast constant 
adBoolean constant 
adChar constant 
adCmdFile constant 
adCmdStoredProc constant 
adCmdTable constant 
adCmdTableDirect constant 
adCmdText constant 
adCmdUnknown constant 
adCurrency constant 
Add Subdatasheet dialog box 
Add to Page button
    Field List toolbar 
add-in data files 
Add-In Manager 
add-ins  2nd 
adDate constant 
adDecimal constant 
adDelete constant 
AddItem method  2nd  3rd 
addition (+) operator 
AddMenu method
    DoCmd object 
AddNew method
    Recordset object 
AddOrders.adp sample project  2nd  3rd  4th  5th 
adDouble constant 
Address Information Systems (AIS) files 
adEditDelete constant 
adEditInProgress constant 
adEditNone constant  2nd 
adFieldDefaultStream constant 
adFilterAffectedRecords constant 
adFilterConflictingRecords constant 
adFilterFetchedRecords constant 
adFilterNone constant 
adFilterPendingRecords constant 
adFind constant 
adFldCacheDeferred constant 
adFldFixed constant 
adFldIsChapter constant 
adFldIsCollection constant 
adFldIsNullable constant 
adFldIsRowURL constant 
adFldKeyColumn constant 
adFldLong constant 
adFldMayBeNull constant 
adFldMayDefer constant 
adFldNegativeScale constant 
adFldRowID constant 
adFldRowVersion constant 
adFldUnknownUpdatable constant 
adFldUpdatable constant 
adHoldRecords constant 
adIndex constant 
adInteger constant 
adLockBatchOptimistic constant 
adLockOptimistic constant 
adLockPessimistic constant 
adLockReadOnly constant 
adLockUnspecified constant 
adLongVarBinary constant 
adLongVarChar constant 
adModeRead constant 
adModeReadWrite constant 
adModeRecursive constant 
adModeShareDenyNone constant 
adModeShareDenyRead constant 
adModeShareDenyWrite constant 
adModeShareExclusive constant 
adModeUnknown constant 
adModeWrite constant 
adMovePrevious constant 
adNotify constant 
adNumeric constant 
ADO
    AddOrders.adp sample project  2nd  3rd  4th  5th 
    backward compatibility 
    COM interoperability wrapper 
    objects  [See also specific objects]
        constants  2nd  3rd 
        displaying with Object Browser  2nd  3rd  4th 
        online VBA help  2nd 
        spaces in names 
        versus DAO objects  2nd  3rd  4th 
    OLE DB interfaces, mapping  2nd  3rd  4th 
    programming advantages  2nd  3rd 
    references  2nd 
    upgrading  2nd 
ADO.NET 
ADODB.Command object  2nd 
    methods  2nd  3rd 
    Parameter objects  2nd  3rd  4th  5th  6th  7th 
    Parameters collection  2nd 
    passing
        parameter values to stored procedures  2nd  3rd  4th  5th 
    properties  2nd  3rd  4th  5th 
ADODB.Connection object 
    events  2nd  3rd 
    methods  2nd  3rd  4th  5th  6th 
    properties  2nd  3rd  4th  5th  6th 
        IsolationLevel  2nd  3rd  4th  5th 
        Mode  2nd  3rd  4th 
        Provider  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        State  2nd  3rd  4th 
    transaction isolation levels  2nd 
ADODB.Recordset object
    binding controls to  2nd  3rd 
    binding forms to  2nd  3rd 
    connecting to databases  2nd  3rd 
    corresponding database object type 
    creating  2nd  3rd 
    DAO.Recordset compatibility 
    events  2nd 
    methods  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
    properties  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
    Value property 
ADODB.Stream object  2nd  3rd  4th  5th 
    creating  2nd  3rd  4th 
    FOR XML AUTO queries  2nd  3rd 
adOpenForwardOnly constant 
adOpenKeyset constant 
adOpenStatic constant 
ADOX
    ALTER TABLE DDL command 
    Catalog object 
    help 
    in Universal Data
        Access architecture 
    VBA access to 
ADOX (ActiveX Data Object
    Extensions) 
ADP  2nd  3rd  4th  5th  6th  7th  8th  9th 
    backups  2nd 
    benefits  2nd  3rd 
    combo box forms, converting  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
    Database window  2nd  3rd  4th 
    live Web reports
        exporting  2nd 
    local Jet databases and 
    new features  2nd  3rd  4th 
    NorthwindCS.adp project
        installing  2nd 
    NorthwindCS.adp sample project 
    project designer  2nd  3rd  4th  5th  [See project designer]
        adding tables  2nd  3rd  4th  5th  6th 
        Design view  2nd  3rd 
        john consider updating  2nd  3rd  4th 
        parenthesis pairs 
        Properties dialog box (tables)  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        Table Design view  2nd  3rd  4th  5th  6th  7th 
    Recordsets
        disconnected Recordsets  2nd 
    requirements 
    restores  2nd  3rd  4th 
    securing as .ade files  2nd  3rd 
    SQL Server 7.0 support  2nd 
    tranferring databases to servers 
    upsizing J apps  2nd  3rd  4th  5th  6th  7th 
        back-end security  2nd  3rd  4th  5th  6th 
        conforming columns to ANSI SQL  2nd  3rd  4th  5th  6th  7th 
        correcting errors  2nd  3rd  4th  5th 
        crosstab queries, emulating  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th 
        DAP error messages  2nd 
        data types  2nd 
        filter references  2nd  3rd  4th 
        Jet SQL statements  2nd  3rd  4th  5th 
        John fix 
        macro security level 
        object values  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        planned migrations 
        report snapshot files  2nd 
        second passes  2nd  3rd 
        SQL reserved words  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        testing projects  2nd 
        Upsizing Wizard  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th 
        VBA functions, converting  2nd  3rd  4th 
        wizard limitations  2nd  3rd  4th  5th 
    uses  2nd 
adParamInput constant 
adParamInputOutput constant 
adParamLong constant 
adParamNullable constant 
adParamOutput constant 
adParamReturnValue constant 
adParamSigned constant 
adParamUnknown constant 
adPosBOF constant 
adPosEOF constant 
adPosUnknown constant 
adRecCanceled constant 
AdRecCantRelease constant 
adRecConcurrencyViolation constant 
adRecDBDeleted constant 
adRecDeleted constant 
adRecIntegrityViolation constant 
adRecInvalid constant 
adRecMaxChangesExceeded constant 
adRecModified constant 
adRecMultipleChanges constant 
adRecNew constant 
adRecObjectOpen constant 
adRecOK constant 
adRecOutOfMemory constant 
adRecPendingChanges constant 
adRecPermissionDenied constant 
adRecSchemaViolation constant 
adRecUnmodified constant 
adResync constant 
adSeek constant 
adSeekAfter constant 
adSeekAfterEQ constant 
adSeekBefore constant 
adSeekBeforeEQ constant 
adSeekFirstEQ constant 
adSeekLastEQ constant 
adSingle constant 
adSmallInt constant 
adStateClosed constant 
adStateConnecting constant 
adStateExecuting constant 
adStateFetching constant 
adStateOpen constant 
adTinyInt constant 
adUpdate constant 
adUpdateBatch constant  2nd 
adUseClient constant 
adUseServer constant 
adVarBinary constant 
adVarChar constant 
adXactBrowse constant 
adXactChaos constant 
adXactCursorStability constant 
adXactIsolated constant 
adXactReadCommitted constant 
adXactReadUncommitted constant 
adXactSerializable constant 
adXactUnspecified constant 
aggregate functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
    troubleshooting 
aggregate queries  [See summary queries]2nd  [See summary queries]
AIDC
    (automated identification and data capture) 
AIS (Address Information Systems) files 
aliasing  2nd  3rd  4th 
aligning
    form controls  2nd  3rd  4th  5th 
    report controls  2nd  3rd  4th 
ALL qualifier
    SELECT statement 
Allow Nulls property
    Table Design window 
Allow Zero Length property
    Table Design window 
Alpha Web service  2nd  3rd  4th  5th  6th 
Alt+Backspace combination 
Alt+Backspace key combination 
Alt+F4 key combination 
AM/PM (custom display format) placeholder 
American National Standards
    Institute (ANSI) 
anchoring Toolbox  2nd 
And operator  2nd  3rd 
AND operator (T-SQL) 
ANSI (American National
    Standards Institute) 
ANSI SQL  2nd 
    aggregate functions 
    As alias name construct
        john alias name sb italic 
    conforming computed columns  2nd  3rd  4th  5th  6th  7th 
    GROUP BY query 
    joins, creating  2nd 
    keywords 
    punctuation  2nd  3rd  4th  5th  6th 
    reserved words  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
    SQL Server Compatible Syntax  2nd 
    updates  2nd 
ANSI-92 DDL
    creating tables  2nd  3rd  4th 
Append dialog box  2nd 
Append method
    Parameters collection 
append queries  2nd  3rd  4th  5th 
    syntax  2nd 
append stored procedures  2nd  3rd  4th  5th  6th 
Append Values stored procedure 
AppendChunk method
    Field object  2nd 
    Parameter object 
appending
    records  2nd 
        append stored procedures  2nd  3rd  4th  5th  6th 
        identity fields  2nd  3rd 
        primary keys, troubleshooting  2nd 
        using action queries  2nd  3rd  4th 
        with forms  2nd  3rd  4th  5th  6th 
Applicable Filter dialog box  2nd 
Application object
    members, viewing 
    method  2nd 
applications
    Contact Management 
        forms  2nd  3rd  4th  5th  6th 
        Main Switchboard  2nd  3rd  4th  5th 
        modules  2nd  3rd 
        reports  2nd  3rd 
        tables  2nd  3rd  4th  5th  6th  7th  8th  9th 
    creating
        from template files  2nd  3rd  4th  5th  6th  7th  8th  9th 
    design approach  2nd  3rd 
    mini-server applications 
    multiuser  [See multiuser applications]
    navigation
        Switchboard Manager  2nd  3rd  4th 
    runtime applications 
        error-handling code  2nd 
Apply Filter button  2nd  3rd  4th  5th 
Apply/Remove Filter/Sort button
    Table Datasheet toolbar 
ApplyFilter method
    DoCmd object 
Apptix On-Depand 
APSM (Access Project Security Manager) 
arguments  2nd 
    DoCmd methods  2nd 
arithmetic operators  2nd  3rd 
arrays  2nd  3rd 
    declaring  2nd 
    duration 
    dynamic arrays  2nd 
    multidimensional arrays  2nd 
    scope 
arrow keys  2nd  3rd  4th  5th 
    modifying behavior of  2nd  3rd  4th 
As Integer keywords 
Asc function 
ASCII files 
    exporting table data as  2nd  3rd 
    importing  2nd  3rd  4th  5th  6th  7th  8th  9th 
ASP  [See Active Server Pages]
ASP.NET
    Web services  2nd  3rd  4th 
assignment operators 
attribute-centric XML documents  2nd  3rd 
attributes
    XML attributes 
        defining  2nd 
Attributes property
    Connection object 
    Field object  2nd  3rd  4th 
    Parameter object  2nd 
Auto Correct Options smart tag 
AutoCalc (PivotTables)  2nd 
Autocompletion screen tips
    and functions  2nd 
AutoCorrect smart tag
    form errors 
AutoCorrect smart tags  2nd 
AutoDialer form, Utility.mda library  2nd 
AutoFilter (Spreadsheet
    OWC control)  2nd  3rd  4th 
AutoForm(colon) PivotChart
    john sb colon/space  2nd  3rd  4th  5th 
AutoFormat
    forms  2nd  3rd  4th  5th 
AutoFormat toolbar button
    john sb just AutoFormat 
    reports  2nd 
AutoLookup  2nd 
automated identification and data capture
    (AIDC) 
AutoNumber fields 
    relationships 
    replication IDs  2nd 
    troubleshooting  2nd 
AutoNumber identity fields 
AutoPage feature (DAP)  2nd  3rd  4th 
    modifying DAP design  2nd  3rd  4th  5th  6th  7th 
AutoSum (DAP)  2nd  3rd  4th 
AutoSum button (Page Design toolbar) 
Avg function 
axis labels
    font size, changing  2nd  3rd 
    reversing