Index D

[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]

d (custom display format) placeholder 
da Vinci QBE tool  2nd  3rd 
da Vinci toolset  2nd  3rd  4th  [See project designer; john update entries]
    SQL Server views
        creating 
        versus stored procedures/in-line functions  2nd 
    SQL Server views, creating  2nd 
    SQL translation  2nd 
DAO
    Compatibility Library 
    objects  [See also specific objects]
        versus ADO objects  2nd  3rd  4th 
DAO.Recordset object  [See also Recordset object]
    ADODB.Recordset compatibility 
    corresponding database object type 
DAP  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th 
    AutoSum  2nd  3rd  4th 
    bound OWCs, adding 
        Charts  2nd  3rd  4th  5th 
        PivotTables  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        Spreadsheet controls  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    combining report and form features  2nd  3rd  4th 
    connecting to back-end databases  2nd  3rd  4th  5th 
    converting to Access 2003  2nd 
    creating
        columnar DAP  2nd  3rd  4th 
        grouped pages  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        PivotTable pages  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        single-level pages  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        SQL Server 2000 data sources  2nd  3rd 
        tabular pages  2nd  3rd 
        with Page Wizard  2nd  3rd  4th  5th  6th  7th  8th 
    deploying
        for Internet Access  2nd  3rd  4th 
        for intranet Access  2nd  3rd  4th 
        for network access  2nd  3rd  4th  5th 
    Design view 
    DHTML  2nd 
        DOM HTML and  2nd  3rd  4th 
        supporting technologies  2nd  3rd 
    filtering records  2nd  3rd  4th 
    group-level property values, setting  2nd  3rd 
    HTML code
        displaying with Script Editor  2nd  3rd  4th  5th 
    input masks  2nd 
    labels 
        aligning text 
        alignment, setting 
        as hyperlinks  2nd 
        as record navigation controls  2nd 
        color, changing 
        editing  2nd 
        font attributes, setting 
        moving  2nd 
        moving to captions  2nd  3rd  4th  5th 
        record navigation control, changing  2nd  3rd 
    layout, modifying  2nd  3rd  4th  5th  6th  7th  8th  9th 
        record navigation controls  2nd  3rd 
        replacing navigation buttons with text labels  2nd  3rd 
    moving controls  2nd 
    Office Web Components (OWC)  2nd 
    opening
        in Internet Explorer  2nd  3rd 
        in Page view 
        troubleshooting 
    Page Design view  2nd 
        Field List buttons  2nd 
        Page Toolbox  2nd  3rd 
        toolbar  2nd  3rd 
    Page view  2nd  3rd 
    Review Products sample page  2nd  3rd  4th  5th  6th 
    Save As DAP operations
        Form/Report to Data Access Page Wizard  2nd 
        forms  2nd  3rd 
        limitations of  2nd  3rd 
        object property values, extracting  2nd 
        queries  2nd  3rd  4th  5th 
        reports  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        tables  2nd  3rd  4th  5th 
    saving forms as  2nd  3rd  4th  5th  6th 
    saving objects to  2nd 
    section siblings  2nd  3rd 
    sizing controls  2nd 
    sorting records  2nd  3rd  4th 
    substituting for MDI forms  2nd  3rd 
    text boxes
        replacing with bound span controls  2nd  3rd  4th 
    theme style sheets  2nd  3rd  4th 
    troubleshooting  2nd 
    updates, enabling  2nd 
    usage instructions, adding 
    Web browsers, detecting 
data
    displaying
        with queries  2nd  3rd  4th  5th  6th  7th 
data access pages  [See DAP]
    opening
        New File page 
data consumers  2nd  3rd 
Data Control Language (DCL) 
data cubes 
Data data type 
Data Definition Language (DDL) 
data dictionaries  2nd  3rd  4th  5th  6th 
data entry  2nd  3rd 
    batch processing 
    data integrity.  [See data integrity]
    expressions for validating  2nd 
    heads-down data entry  2nd  3rd  4th  5th  6th 
        john add pgs 
    keyboard operations  2nd  3rd  4th 
        Clipboard operations  2nd  3rd  4th 
        editing mode  2nd  3rd 
        field entries  2nd 
        select mode  2nd  3rd 
        setting options  2nd  3rd  4th 
        text box entries  2nd 
    transaction processing  2nd  3rd 
    validation rules  2nd  3rd  4th  5th 
        BeforeUpdate event handler  2nd 
        error messages  2nd 
        expressions  2nd  3rd 
        field-level  2nd  3rd  4th  5th 
        table-level  2nd  3rd  4th 
        testing  2nd  3rd  4th  5th 
data entry view, InfoPath  2nd  3rd 
    editing section, adding  2nd  3rd 
    removing  2nd  3rd 
data entry;validation rules 
data events  2nd 
    BeforeUpdate  2nd 
    OnCurrent  2nd  3rd  4th  5th  6th  7th  8th 
data integrity  2nd 
    entity integrity  2nd 
    referential integrity  2nd  3rd  4th 
        enforcing  2nd  3rd  4th 
        violating  2nd  3rd 
    transactions  2nd  3rd 
data intregrity
    validation rules  2nd  3rd 
Data Link Properties dialog box  2nd 
Data Manipulation Language
    (DML) 
data organization 
Data Outline button (Page
    Design toolbar) 
Data Outline windows
    Page Design view  2nd 
Data page
    Properties dialog box  2nd 
data presentation 
data providers 
    DataSource object  [See DataSource object]
    in Universal Data Access architecture  2nd 
    Recordset methods and 
    viewing 
Data Query Language (DQL) 
data redundancy  2nd  3rd  4th  5th  6th 
Data Security Language 
data services  2nd 
    RDS (Remote Data Services) 
Data Source Setup Wizard  2nd  3rd  4th  5th  6th  7th  8th  9th 
Data Source task pane
    (InfoPath) 
data sources
    creating
        for forms  2nd  3rd 
        for graphs  2nd  3rd  4th  5th 
        for InfoPath form templates 
    in InfoPath templates
        changing primaries  2nd  3rd  4th 
        changing secondaries  2nd  3rd 
        creating secondaries  2nd  3rd  4th 
    troubleshooting  2nd 
Data Type property
    Table Design window  2nd 
data types  [See also specific data types]
    coerced data types 
    concatenating  2nd  3rd  4th 
    field data types  2nd  3rd  4th  5th  [See also specific fields]
        changing  2nd  3rd  4th 
        converting to Jet data types  2nd  3rd 
        default values  2nd  3rd 
        display formats  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        field sizes, selecting  2nd  3rd  4th  5th 
        input masks  2nd  3rd  4th 
    object libraries  2nd 
    specifying in parameter queries  2nd  3rd  4th 
    SQL Server data types  2nd  3rd 
    type-declaration characters  2nd 
    user-defined data types
        variables and  2nd 
    VBA data types  2nd  3rd 
        corresponding database objects  2nd 
data-centric collaboration  2nd  3rd 
data-entry
    form-based  2nd  3rd  4th  5th  6th  7th  8th  9th 
data-type conversion functions  2nd  3rd  4th  5th  6th 
DataAccessPage object
    corresponding database object type 
databanks 
database diagrams  2nd  3rd  4th 
Database Diagrams page, Database window 
Database Documenter
    data dictionaries, creating  2nd  3rd  4th  5th 
Database object
    corresponding database object type 
Database objects 
database objects
    pointing to 
    properties
        as variables  2nd  3rd  4th 
        With...End With structure  2nd 
    VBA data types  2nd 
Database Splitter  2nd  3rd  4th  5th 
Database Splitter command 
Database to Compact From dialog box 
Database Utilities (Tools menu)  2nd  3rd 
    Back Up Database  2nd 
        john add pgs 
    Backup SQL Database  2nd 
    Compact and Repair Database  2nd  3rd 
    Convert Database  2nd 
    Copy Database 
    Copy Database File  2nd 
    Linked Table Manager  2nd  3rd 
    Make ADE File 
    Make MDE File  2nd  3rd 
    Restore SQL Database  2nd  3rd  4th 
    Transfer Database  2nd  3rd 
Database window 
    Database Diagrams page 
    for ADP  2nd  3rd  4th 
    Forms page 
    Pages page  2nd 
    Queries page  2nd 
    Reports page 
    tables  2nd  3rd  4th  5th  6th  7th  8th  9th 
    Tables page 
Database window button
    Table Datasheet toolbar 
Database window toolbar 
Database Wizard
    creating applications  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
databases
    back-end databases
        DAP, connecting  2nd  3rd  4th  5th 
    backups 
    compacting  2nd  3rd  4th  5th 
    connections
        minimizing 
        Recordset object and  2nd  3rd 
        remote SQL Server databases  2nd  3rd 
        troubleshooting 
    converting
        compile errors  2nd 
        secured Access 9x files  2nd  3rd  4th 
        to Access 2002 format  2nd 
        to Access 97 format  2nd 
        unsecured Access 9x files  2nd  3rd  4th  5th  6th  7th  8th 
    copying
        john add pgs 
    corrupted  2nd 
    creating  2nd  3rd  4th 
    default location 
    designing  2nd  3rd 
    distributed databases 
    forms.  [See forms]
    hierarchical databases  2nd  3rd 
    history of  2nd  3rd  4th  5th  6th  7th  8th  9th 
    modules.  [See modules]
    naming 
        default file name 
    network databases  2nd 
    Oakmont sample database  2nd  3rd 
    opening 
        New File page 
        Northwind Traders sample database  2nd  3rd 
    partitioning  2nd  3rd  4th  5th 
    relational databases  2nd 
    relational.  [See relational databases]
    reports.  [See reports]
    startup properties, specifying  2nd 
    tables.  [See tables]
    transactions  2nd  3rd 
    transferring to servers 
    troubleshooting
        conversion compile errors  2nd 
        invalid database locked messages  2nd 
        remote connections 
    upgrading  2nd  3rd 
        DAO versus ADO  2nd 
        data access pages, converting to Access 2003  2nd 
        MSDE to SQL Server  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th 
        secured Access 9x files  2nd  3rd  4th 
        unsecured Access 9x files  2nd  3rd  4th  5th  6th  7th  8th 
        VBA code, optimizing  2nd 
Databases tab (Templates dialog box)  2nd 
DataMember property
    Recordset object 
Datasheet Formatting dialog box  2nd 
Datasheet Formatting toolbar  2nd  3rd 
Datasheet view 
    browse updating 
    creating tables in  2nd 
    Datasheet Formatting toolbar  2nd  3rd 
    default options  2nd  3rd  4th 
    rearranging fields  2nd 
    Table Datasheet toolbar  2nd  3rd  4th 
    versus keypunch data entry  2nd  3rd 
Datasheet View toolbar
    SQL Server views 
DataSource property
    Recordset object 
DataSourceControl class
    ServerFilter property  2nd  3rd 
date and time functions  2nd  3rd  4th  5th 
Date function 
Date smart tag 
date/time fields 
    converting between other data types  2nd 
        functions  2nd  3rd  4th 
    display format, selecting  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    grouping report data by  2nd 
    input masks  2nd  3rd  4th 
date/time literals 
DateAdd function 
DateDiff function 
DatePart function 
DateSerial function 
DateValue function 
Day function 
db1.mdb file 
dBASE
    linking/importing files  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        converting field data types  2nd  3rd 
        images, adding  2nd  3rd  4th  5th 
        missing memo files 
    ODBC drivers  2nd 
DCL (Data Control Language) 
DDL (Data Definition Language) 
    ANSI-92
        creating tables  2nd  3rd  4th 
Debug object
    printing to Immediate window  2nd  3rd  4th  5th 
debugging VBA code
    Immediate window  2nd  3rd  4th  5th  6th 
        printing to  2nd  3rd  4th  5th 
    runtime errors  2nd  3rd  4th  5th 
Decimal data type
    fractional values 
Decimal Places property
    Table Design window 
Decimal Places property, Table Design window 
decision-support applications  2nd  3rd  4th  5th  6th  7th 
    combo boxes
        adding to forms  2nd  3rd  4th  5th  6th 
        converting to ADP  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        designing queries  2nd 
        editing  2nd  3rd 
        SELECT queries, creating  2nd  3rd  4th  5th  6th  7th 
        selecting all items  2nd  3rd  4th  5th  6th  7th 
    forms
        adding query combo boxes  2nd  3rd  4th  5th  6th 
        creating  2nd  3rd  4th 
    list boxes
        drilling down from  2nd  3rd  4th  5th  6th  7th 
        selecting items  2nd  3rd  4th  5th  6th  7th  8th  9th 
    troubleshooting  2nd  3rd 
Declarations section (modules) 
    dynamic arrays 
    form-level variables 
    global variables 
    module-level variables 
    Option Compare... statements  2nd 
    Option Explicit statement  2nd 
    report-level variables 
    symbolic constants 
    user-defined data types 
Declarative Refential
    Integrity (DRI)  2nd 
declarative referential
    integrity (DRI)  2nd 
declaring
    arrays 
    constants 
    variables
        explicit variables  2nd 
        implicit variables  2nd 
        scope  2nd 
        user-defined data types  2nd 
decryption
    troubleshooting 
default
    Datasheet view options  2nd  3rd  4th 
    field values
        expressions for creating  2nd 
    form view  2nd  3rd 
    references, viewing 
    system 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 
    table view 
default parameter values, adding  2nd  3rd 
Default Value property
    Table Design window  2nd  3rd  4th  5th 
default values
    forms  2nd 
Default View property
    Table Properties window 
DefaultDatabase property
    Connection object 
DefinedSize property
    Field object 
Delete key 
Delete method
    Parameters collection 
    Recordset object 
delete queries  2nd  3rd  4th  5th  6th  7th 
    syntax 
Delete Record button
    Table Datasheet toolbar 
DELETE statement
    syntax  2nd 
delete stored procedures  2nd 
DeleteObject method
    DoCmd object 
deleting
    AutoFormats  2nd 
    controls
        report controls  2nd  3rd 
    fields
        Database Wizard  2nd 
    form controls  2nd 
    MSDE  2nd 
    records 
        cascading deletions  2nd  3rd  4th  5th  6th  7th  8th 
        using action queries  2nd  3rd  4th  5th  6th 
    report sections  2nd 
    subdatasheets  2nd 
    tab control pages  2nd 
    tables 
    toolbar buttons  2nd  3rd 
delimiters 
    john same as string identifiers 
Demote button
    Page Design toolbar 
deploying
    DAP
        for Internet access  2nd  3rd  4th 
        for intranet access  2nd  3rd  4th 
        for network access  2nd  3rd  4th  5th 
Description property
    Err object 
    Error object 
    Table Design window  2nd 
    Table Properties window 
deserialization 
design mode 
Design mode button
    VBA editor toolbar 
Design Tasks task pane
    (InfoPath)  2nd 
Design view
    forms  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        Form Design toolbar  2nd  3rd  4th  5th  6th 
        Form Detail bar 
        Form Footer bar  2nd 
        Form Header bar  2nd  3rd 
        Formatting toolbar  2nd  3rd 
        Toolbox  2nd  3rd  4th  5th  6th  7th  8th 
    opening  2nd 
    project designer  2nd  3rd 
    reports  2nd  3rd 
    selecting 
    subforms 
Design View button
    Table Datasheet toolbar 
designing
    forms  2nd  3rd  4th  5th  6th  7th 
        Access Builders  2nd 
        Control Wizards  2nd 
        customizable toolbars  2nd  3rd  4th  5th  6th 
        optimizing form design  2nd  3rd  4th 
    tables  2nd  3rd  4th  5th  6th  7th  8th 
        assigning data entities to fields  2nd  3rd 
        determining data attributes  2nd  3rd 
        fifth normal form  2nd 
        first normal form  2nd  3rd  4th  5th 
        fourth normal form  2nd 
        second normal form  2nd  3rd 
        third normal form  2nd  3rd  4th 
designing applications  2nd  3rd 
desktop RDBMSs  2nd  3rd  4th 
Detail section (forms) 
    background bitmap pictures  2nd  3rd  4th  5th  6th 
    background colors  2nd  3rd 
    properties  2nd 
    sizing  2nd  3rd  4th 
Detect and Repair command (Help menu) 
DHTML  2nd 
    DOM HTML and  2nd  3rd  4th 
    supporting technologies  2nd  3rd 
Diagram button, view designer toolbar 
diagrams, database  2nd  3rd 
Dialect property
    Command object 
digital signatures
    InfoPath forms 
Dim statements
    declaring arrays  2nd  3rd 
    declaring variables  2nd  3rd  4th 
Direction property
    Parameter object  2nd 
directories
    virtual directories
        navigation pages and 
Dirty event 
Disabled Items button (Help menu) 
Disconnect event
    Connection object 
disconnected Recordsets  2nd  3rd  4th  5th  6th  7th 
    cmdBulkUpdate event handler  2nd  3rd 
    cmdOpenXML event handler  2nd 
    cmdUpdate event handler  2nd  3rd 
    example batch update application  2nd  3rd 
    Form_Load event handler  2nd  3rd  4th 
    Form_Unload event handler  2nd 
    OpenConnection subprocedure  2nd  3rd 
    OpenRstFromFile subprocedure  2nd  3rd 
displaying
    data
        with queries  2nd  3rd  4th  5th  6th  7th 
    field data types  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    ScreenTips 
    toolbars  2nd 
DISTINCT keyword  2nd  3rd 
DISTINCT qualifier
    SELECT statement 
DISTINCTROW keyword  2nd  3rd 
DISTINCTROW qualifier
    SELECT statement 
distributed databases 
distributed queries 
Distributed Transaction
    Coordinator (DTC) 
Distributed Transaction Coordinator (DTC) 
division (/) operator 
DLLs (dynamic link libraries)
    references  2nd 
DML (Data Manipulation Language) 
DNS (Domain Name System) 
Do Until...Loop statement  2nd  3rd 
Do While...Loop statement  2nd  3rd 
DocFiles  2nd  3rd  4th 
docfiles 
docked command bars 
docked toolbars 
docking
    Project Explorer window 
docking toolbars  2nd 
DoCmd object  2nd  3rd 
    arguments  2nd 
    methods  2nd  3rd  4th  5th  6th  7th  8th  9th 
document/literal Web
    service messages  2nd  3rd 
DOM HTML  2nd  3rd  4th 
domain integrity.  [See entity integrity]
Domain Name System (DNS) 
dot (.) operator  2nd 
Double data type  2nd 
    relationships  2nd 
downloading
    template files  2nd  3rd  4th 
DQL (Data Query Language) 
DRI (Declarative Refential
    Integrity)  2nd 
DRI (declarative referential
    integrity)  2nd 
drill-down forms  2nd  3rd  4th  5th  6th  7th 
drop-down list boxes  2nd 
    adding
        Combo Box Wizard  2nd  3rd  4th  5th  6th  7th 
    creating
        record-selection boxes  2nd  3rd  4th  5th  6th 
        static-value boxes  2nd  3rd  4th 
    john verify pgs (combo boxes) 
    populating  2nd  3rd  4th  5th  6th 
DTC (Distributed Transaction
    Coordinator)  2nd 
duration of VBA variables  2nd 
dynamic arrays  2nd 
Dynamic HTML  [See DHTML]
dynamic T-SQL
    versus pre-compiled query objects  2nd 
    WHERE clause constraints  2nd