Access Data Analysis Cookbook (Cookbooks)

DAO 

    and smart tag DLL 

DAO 3.6 Object Library 

DAO type library 

DAPs  [See Data Access Pages]

data

    binary 

    collecting from user and posting to Access database 

    PowerPoint presentations and 

    sending to Excel 

Data Access Objects (DAO)

    as older technology 

    client/server applications and  2nd 

    coding recommendations 

    consistent settings 

    creating indexed tables using 

    creating TableDef objects 

    listing users  2nd 

    object inventory and 

    obtaining field properties with 

    retrieving information with 

Data Access Pages (DAPs) 

    Access version differences  2nd 

    background 

    changing connection strings for 

    changing default settings 

    features 

    parameters across multiple 

    smart tags and 

    storing connection information 

    updating data on 

data definition language (DDL) queries

    creating tables with 

    object inventory 

    table manipulation with 

Data Link Properties dialog 

data manipulation 

    accelerating multiuser applications 

    collecting information 

    combining data across tables 

    converting raw data 

    creating page-range indicators 

    DoCmd.OutputTo and 

    grouping data for mailing labels 

    importance of synchronization 

    OLE-DB and 

    placing data in controls 

    programmatically exporting data 

    queries and 

    transaction logging and 

    update queries and 

    updates on data access pages 

    using views for 

Data Source Name (DSN)  2nd 

data sources

    Excel worksheet as 

    seek operations and 

    storing connection information 

data types

    setting to OLE object 

    string 

    Text 

    usage recommendations 

    user-defined 

Data View Web Parts 

    conditionally formatting 

    creating master/detail page 

    fields Front Page displays 

    HTML behind 

    placing on web page 

Database Explorer 

Database objects 

Database Splitter Wizard (Access)  2nd 

databases

    adding properties to 

    attaching remote tables 

    backups of selected objects 

    changing global options 

    changing options 

    cleaning out test data 

    creating in FrontPage 

    external  2nd 

    multiple users and sharing 

    opening 

    passing parameters 

    reference data from multiple 

    securing  2nd 

    Seek method and 

    splitting multiuser  2nd 

    synchronized copies of 

    transaction logs 

Databases container 

DataGrid, binding 

DataOnly property (Printer object) 

DataPageSize property (pages) 

dataroot element (XSD) 

DataSet, returning 

Datasheet icon 

DataSource control

    as MSOSDC 

    DAPs and 

    updating DAPs and 

DataSourceControl (Office Web Component) 

DataTransform parameters 

Date function 

Date smart tag 

    allowable actions 

    using with Person smart tag 

date/time values

    as variables 

    converting 

    median value and 

    quotes and 

    search delimiters 

    sorting columns correctly 

DAvg function 

DBEngine object  2nd 

DblClick event 

DCount function 

DDE 

DDEExecute procedure  2nd 

DDEInitiate function 

DDERequest function  2nd 

DDETerminate function 

DDL queries queries) 

Deactivate event  2nd  3rd  4th 

debugging 

    subforms and reports 

    unexpected parameter dialog 

    viewing debug window 

declarations (module)

    animated buttons 

    creating status meters 

    Option Explicit statement and 

default printers

    controlling 

    finding reports not set to 

    selecting runtime printers and 

    UseDefaultPrinter property and 

DefaultEditing property (forms) 

DefaultSize property (Printer object)  2nd 

DefaultValue property (controls)

    carrying data forward 

    Tag property and  2nd 

DefaultValue property (fields)  2nd 

DefaultView property (forms)

    communicating without email 

    continuous forms and  2nd  3rd 

    creating expanding dialogs 

    creating pop-up calendars 

    creating status meters 

DELETE (SQL) statement 

Delete method (Property object) 

delete queries 

DeleteGroup function (Windows shell) 

DeleteItem function (Windows shell) 

DeleteObject method (DoCmd object) 

DeleteSetting function 

delimiters

    apostrophes as 

    CR/LF 

    in string expressions 

    null characters 

    square brackets as 

Description property (objects)  2nd 

design master 

design master replica 

design-view queries 

device names 

DeviceName property (Printer object)  2nd 

dialogs

    adding/canceling connections via 

    creating expanding 

    File Open/Save 

Dir function  2nd 

directories, collecting information 

dirty forms  2nd 

Dirty property (forms)  2nd 

division operators 

DLLs (dynamic link libraries) 

    compiling and registering DLL project 

    creating smart tag DLL with Visual Basic 6.0 

DLookup function  2nd 

DMax function 

DMin function 

Do Until statement 

DoCmd objects

    DeleteObject method 

    DoMenuItem method  2nd 

    OpenReport method  2nd  3rd  4th  5th  6th 

    OutputTo method  2nd 

    PrintOut method 

    RepaintObject method 

    RunCommand statement 

    ShowToolbar macro action 

    TransferSpreadsheet method 

Document objects 

documentation

    for containers  2nd 

    for items 

    for operating system dependencies 

    of properties 

Documents collection 

DoEvents statement

    features of 

    looping and 

    multitasking and 

    profiler and 

domain functions 

DoMenuItem method (DoCmd object)  2nd 

DOS

    cautions copying replicas 

    starting and stopping applications 

DrawStyle property (lines) 

DriverName property (Printer object)  2nd 

drives

    adding/canceling connections 

    retrieving information 

driving forms 

DROP INDEX (SQL) statement 

DROP TABLE (SQL) statement

    for DDL queries 

    object inventory 

    overwriting tables and 

DSN (Data Source Name) 

Duplex property (Printer object)  2nd 

duplicate records

    eliminating with totals query 

    UNION ALL clause and 

dynamic arrays  2nd 

Dynamic Data Exchange (DDE)

    adding items to Startup group 

    communication mechanism 

    filenames and 

    using with Windows shell 

dynamic link libraries (DLLs) 

dynasets  2nd