Index C

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

C (input mask) placeholder 
CAB (cabinet) files
    InfoPath .xsn files  2nd  3rd 
cabinet files  [See CAB (cabinet) files]
CacheSize property
    Recordset object 
calculated controls  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
    adding to reports  2nd  3rd  4th  5th 
    providing data for  2nd  3rd  4th 
calculated text boxes, creating  2nd 
calculating table values 
    aggregate functions  2nd  3rd 
    all records  2nd  3rd 
    selected records  2nd  3rd  4th 
Call keyword 
Can't decrypt file error message
    john add quotes 
Can't evaluate expression error message
    john add quotes  2nd  3rd  4th 
Can't have Null value in
    index error message
        js add quotes 
Cancel method
    Command object 
    Recordset object 
CancelBatch method
    Recordset object  2nd  3rd 
CancelEvent method
    DoCmd object 
CancelUpdate method
    Recordset object 
Cannot locate the requested
    Xbase memo file error message 
Caption property, Table Design window 
captions
    adding to grouped pages  2nd  3rd  4th  5th 
carpal tunnel syndrome (CTS) 
Cartesian products 
cascading
    deletions  2nd  3rd 
    updates  2nd  3rd 
cascading deletions  2nd 
    DRI (Declarative Referential Integrity)  2nd 
    testing  2nd  3rd  4th  5th  6th 
Cascading Style Sheets (CSS)  2nd 
    in DAP (Data Access Pages)  2nd  3rd  4th 
cascading updates
    DRI (Declarative Referential Integrity)  2nd 
    testing  2nd  3rd  4th  5th  6th 
CAST function 
Catalog object
    ADOX 
CBool function 
CByte function 
CCC (code-continuation character) 
CCL (Cursor Control Language) 
CCur function 
CDate function 
CDbl function 
Change Order template (InfoPath) 
    default field values, setting  2nd 
    form fields, replacing  2nd  3rd 
    section properties, changing  2nd  3rd 
Change Switchboard Items button
    Main Switchboard 
ChangeOrder.xsn file  2nd  3rd 
Chart Type dialog box  2nd  3rd 
Chart Wizard
    summary queries, creating  2nd  3rd 
    unlinked charts/graphs, creating  2nd  3rd  4th  5th  6th  7th  8th 
charts
    adding
        to DAP  2nd  3rd 
    adding to DAP  2nd  3rd  4th  5th 
    adding to reports  2nd  3rd  4th  5th 
    changing chart type  2nd  3rd  4th 
    linked charts  2nd 
        assigning crosstab queries  2nd 
        designing crosstab queries  2nd  3rd 
        linking to records  2nd  3rd  4th  5th 
    modifying chart design  2nd  3rd  4th  5th 
    PivotChart views  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        adding axis titles 
        altering category presentation  2nd  3rd  4th 
        changing chart type  2nd  3rd 
        filtering category values  2nd 
        togging legends 
    PivotCharts  2nd 
        cloning linked forms/subforms  2nd  3rd 
        creating  2nd  3rd  4th  5th 
        editing subform design  2nd  3rd 
        linking to records  2nd 
        persisting linked properties  2nd  3rd 
        printing  2nd 
        using as subforms  2nd  3rd 
    unlinked charts  2nd 
        creating with Chart Wizard  2nd  3rd  4th  5th  6th  7th  8th 
        query data source, creating  2nd  3rd  4th  5th 
Check Box button (Toolbox) 
check constraints  2nd  3rd 
    in tables saved as pages 
    SQL Server tables  2nd 
Check Constraints page
    Properties dialog box  2nd 
Check for Updates command (Help menu) 
Check SQL Syntax button 
Chr function  2nd  3rd 
CInt function 
Class Module window  [See VBA editor]
class modules  2nd  3rd  4th  5th 
    custom 
    encapsulating VBA code 
    event handlers.  [See event handling]
    Friend members 
    frmBatchUpdate  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
    functions, calling 
    Main Switchboard form  2nd  3rd  4th 
        event-handling code  2nd  3rd  4th 
    subprocedures, calling 
    Web service proxy  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
classes
    deserialization 
    Object Browser  [See Object Browser]
    serialization 
clauses (SQL) 
Clear method
    Err object 
client/server applications  [See also ADP (Access Data Projects)]
client/server apps
    user-level security
        trusted connections 
client/server RDBMSs  2nd  3rd  4th  5th 
client/servers, migrating
    .mde front ends, creating  2nd  3rd 
    benefits of  2nd  3rd  4th 
    exporting tables to other RDBMSs  2nd  3rd 
    front ends with linked tables  2nd 
    John  [See notes]
    manually
        attaching exported tables  2nd  3rd 
        creating ODBC data sources  2nd  3rd  4th  5th 
        exporting to RDBMSs  2nd  3rd 
        john goes with above 
    manually linking tables  2nd  3rd  4th  5th  6th  7th  8th  9th 
    moving upsized databases  2nd  3rd  4th  5th  6th  7th  8th 
    MSDE features  2nd  3rd  4th 
    multiuser apps  2nd  3rd  4th 
        Database Splitter  2nd  3rd  4th  5th 
        securing network shares  2nd  3rd  4th  5th 
        verifying back-end security  2nd  3rd 
    ODBC table connection strings  2nd  3rd  4th  5th  6th  7th  8th  9th 
    password-protecting front ends  2nd  3rd  4th  5th  6th  7th 
    permissions, changing  2nd  3rd  4th 
    single apps  2nd 
        JOHN  [See notes]
        table properties, modifying  2nd  3rd  4th 
        Upsizing Wizard  2nd  3rd  4th  5th  6th  7th 
        verifying process  2nd  3rd  4th 
    strategic migrations  2nd 
    strategies  2nd 
    troubleshooting  2nd  3rd 
    user logins, adding  2nd  3rd  4th  5th  6th 
    user-level security  2nd  3rd  4th  5th  6th  7th  8th  9th 
        back-end databases  2nd 
        Security Wizard  2nd  3rd  4th  5th  6th  7th  8th  9th 
    versus shared files  2nd  3rd 
Clipboard
    data-entry key combinations  2nd  3rd  4th 
Clipboard page 
CLng function 
Clone method
    Recordset object 
Close method
    Connection object 
    DoCmd object 
    Recordset object 
closing
    forms 
    pages 
    queries 
    reports 
clustered indexes 
cmdBulkUpdate event handler  2nd  3rd 
cmdOpenXML event handler  2nd 
cmdUpdate event handler  2nd  3rd 
Codd, Dr. E. F.  2nd  3rd 
code editor, VBA 
    john add VBA editor entries 
code-continuation character
    (CCC) 
coerced data types 
collaboration  2nd  3rd 
Collation property, Table Design window 
collections
    troubleshooting
        missing objects 
colon (input mask) placeholder
    john replace w colon 
colon= operator
    john replace w/colon, no space 
colors
    forms 
        background colors  2nd  3rd  4th  5th 
        custom colors  2nd 
        foreground colors  2nd  3rd 
Column Name property
    Table Design window 
columns
    AccessKey values  2nd  3rd  4th 
    conforming computed columns to ANSI SQL  2nd  3rd  4th  5th  6th  7th 
    navigating
        in tables saved as pages  2nd  3rd  4th 
    query column headers
        fixed column headings  2nd  3rd  4th  5th 
    query column headers, changing names  2nd  3rd  4th  5th  6th 
    thawing frozen columns  2nd 
    width
        in query-based pages  2nd  3rd  4th 
        in table-based pages  2nd  3rd  4th  5th 
    width, changing 
Columns page, Table Design view  2nd  3rd 
COM
    interoperability wrappers 
COM add-ins 
COM objects
    references  2nd 
combinational hashing 
Combo Box button (Toolbox) 
Combo Box Wizard  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 
combo boxes 
    advantages  2nd  3rd 
    creating
        Combo Box Wizard  2nd  3rd  4th  5th  6th  7th 
        record-selection combo boxes  2nd  3rd  4th  5th  6th 
        static-value combo boxes  2nd  3rd  4th 
    in DSAs  2nd  3rd  4th 
        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 
        John sb decision-support applications 
        SELECT queries, creating  2nd  3rd  4th  5th  6th  7th 
        selecting all items  2nd  3rd  4th  5th  6th  7th 
        troubleshooting  2nd  3rd 
    populating  2nd  3rd  4th  5th  6th 
    versus list boxes  2nd 
comma (custom display format) placeholder
    john replace w a comma 
comma (input mask) placeholder
    john replace w comma 
comma-delimited text files 
    exporting table data as  2nd  3rd 
    importing  2nd  3rd  4th  5th  6th  7th 
command bars  2nd  3rd 
    docking 
    floating  2nd 
Command Button button (Toolbox) 
Command Button Wizard  2nd  3rd  4th  5th  6th  7th  8th 
command buttons
    adding to forms  2nd  3rd  4th  5th  6th  7th  8th 
    event-handling subprocedures 
Command object  2nd 
    corresponding database object type 
    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 
Command objects 
CommandBar object  2nd  3rd  4th  5th  6th 
    custom, specifying  2nd 
    property values, obtaining  2nd 
    VBA access to  2nd 
CommandBars collection  2nd  3rd  4th  5th  6th 
commands
    SQL commands 
    SQL commands.  [See statements]
CommandStream property
    Command object 
CommandText property
    Command object 
CommandTimeout property
    Command object 
    Connection object 
CommandType property
    Command object  2nd 
commas (in SQL) 
comments
    in VBA code 
CommitTrans method
    Connection object 
CommitTransComplete event
    Connection object 
Compact and Repair Database command  2nd  3rd  4th 
Compact Database Into dialog box 
compacting databases  2nd  3rd  4th  5th 
CompactRepair method
    Application object 
CompareBookmarks method
    Recordset object 
comparison operators  2nd  3rd  4th 
comparison predicates  [See operators]
Compatibility Library (DAO) 
Compile Error - Sub or Function
    not defined message 
compile errors
    converting databases  2nd 
composite primary keys 
    creating  2nd 
concatenation
    john add entries 
    Variant data type and 
concatenation operators  2nd 
conditional statements  2nd  3rd  4th  5th 
    If...Then...End If  2nd  3rd 
    Select Case...End Select  2nd  3rd 
ConnectComplete event
    Connection object 
Connection object 
    corresponding database object type 
    events  2nd  3rd 
    methods  2nd  3rd  4th  5th  6th 
    properties  2nd  3rd  4th  5th  6th 
        IsolationLevel  2nd  3rd 
        Mode  2nd 
        Provider  2nd  3rd  4th  5th 
        State  2nd 
connections
    minimizing active database connections 
    Recordset object and  2nd  3rd 
    remote SQL Server databases  2nd  3rd  4th 
    troubleshooting 
ConnectionString property 
    Connection object 
ConnectionTimeout property
    Connection object 
Connecton object
    transaction isolation levels  2nd 
Const keyword 
constants  2nd  3rd  4th 
    ADO constants  2nd  3rd 
    data types, specifying 
    declaring 
    intrinsic  2nd 
    statement autocompletion  2nd 
    system-defined 
consumers, Web services 
    creating  2nd 
        adding proxy  2nd  3rd  4th 
        adding required classes  2nd  3rd 
        tracing proxy execution  2nd  3rd  4th  5th 
    InfoPath.  [See InfoPath]
consuming
    Web services 
Contact Management application 
    forms  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th 
    Main Swithboard  2nd  3rd  4th  5th 
    modules  2nd  3rd 
    reports  2nd  3rd 
        previewing/printing  2nd 
    tables  2nd  3rd  4th  5th  6th  7th  8th  9th 
Contact Us command (Help menu) 
context menus  2nd 
Control object
    corresponding database object type 
control structures  2nd  3rd  4th  5th 
    Do Until...Loop  2nd  3rd 
    Do While...Loop  2nd  3rd 
    For...Next  2nd  3rd 
    If...Then...End If  2nd  3rd 
    Select Case...End Select  2nd  3rd 
    While...Wend 
    With...End With  2nd 
Control Wizards 
    Combo Box Wizard  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th 
    Option Group Wizard  2nd  3rd  4th  5th  6th  7th 
Control Wizards button (Toolbox) 
controls
    binding
        to Recordset objects  2nd  3rd 
    bound controls  2nd 
        replacing DAP text boxes with  2nd  3rd  4th 
    calculated controls 
    changing control types  2nd 
    copying  2nd  3rd  4th 
        troubleshooting 
    editing
        DAP controls  2nd  3rd  4th  5th  6th  7th  8th  9th 
    form controls  2nd 
        adding to tab control pages  2nd 
        aligning  2nd  3rd  4th  5th 
        background bitmap pictures  2nd  3rd  4th  5th  6th  7th 
        background colors  2nd  3rd  4th 
        border color  2nd 
        border style  2nd 
        bound controls 
        calculated controls 
        copying  2nd 
        custom colors  2nd  3rd 
        deleting  2nd 
        error correction  2nd  3rd 
        foreground color  2nd  3rd 
        Format Painter  2nd 
        moving  2nd  3rd  4th  5th 
        optimizing data entry  2nd  3rd  4th 
        properties  2nd 
        selecting  2nd  3rd  4th  5th  6th 
        sizing  2nd 
        smart tags 
        tab controls.  [See tab controls]
        text editing  2nd 
        Windows XP themes 
    label controls  [See labels]
    moving
        DAP controls  2nd 
    properties  2nd 
    report controls 
        ActiveX controls 
        aligning  2nd  3rd  4th 
        bound object frames 
        calculated controls  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        check boxes 
        copying  2nd 
        deleting  2nd  3rd 
        editing  2nd  3rd 
        formatting  2nd  3rd 
        line spacing  2nd  3rd 
        option buttons 
        relocating  2nd  3rd 
        shapes 
        unbound object frames 
    SQL statements  2nd 
    subform controls
        VBA references to  2nd 
    unbound controls 
    unbound object frame controls
        images, adding 
    VBA references to  2nd  3rd  4th 
Convert Database command  2nd  3rd 
Convert Database Into dialog box  2nd 
CONVERT function  2nd  3rd  4th  5th  6th  7th 
Convert/Open Database dialog box  2nd 
ConvertAccessProject method
    Application object 
converting
    data access pages to Access 2003  2nd 
    field data types  2nd  3rd  4th 
        imported/linked files  2nd  3rd 
    select queries to action queries  2nd  3rd 
converting databases
    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 
cookies
    crumbs 
    passing filter criteria with  2nd  3rd  4th  5th  6th  7th 
    troubleshooting  2nd 
Copy Database command 
Copy Database File command  2nd 
CopyDatabaseFile method
    DoCmd object  2nd 
copying
    Clipboard operations  2nd 
    controls  2nd  3rd  4th  5th  6th 
        troubleshooting 
    databases
        john add pgs 
        to specified locations  2nd 
    databases to servers  2nd 
    form controls 
        john sb just controls 
    records 
    tables  2nd  3rd 
CopyObject method
    DoCmd object  2nd 
corrupted databases  2nd 
Count function 
Create a New File link (Getting Started page)  2nd 
CreateNewWorkgroupFile method
    Application object 
CreateParameter method
    Command object  2nd  3rd 
crossfooting 
crosstab queries  2nd  3rd  [See also summary queries]4th  5th  6th  7th 
    advantages of  2nd 
    creating
        manually  2nd  3rd  4th 
        with Crosstab Query Wizard  2nd  3rd  4th 
        with CrosstabUpsizer application 
    emulating with T-SQL  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 
        Crosstab Upsizer  2nd  3rd  4th  5th 
        with static tables  2nd  3rd  4th  5th  6th  7th  8th  9th 
        with stored procedures  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th 
    fixed column headings  2nd  3rd  4th  5th 
    linked graphs, creating  2nd 
        assigning query  2nd 
        designing query  2nd  3rd 
    restrictions 
    SQL aggregate functions and 
    upsizing 
    uses 
    versus PivotTables  2nd  3rd 
Crosstab Query Wizard  2nd  3rd  4th  5th  6th 
Crosstab Upsizer application  2nd  3rd  4th  5th 
CrosstabUpsizer application 
crumbs 
CSng function 
CSS (Cascading Style Sheets)  2nd 
    in DAP (Data Access Pages)  2nd  3rd  4th 
CStr function 
CSV files 
    exporting table data as  2nd  3rd 
    importing  2nd  3rd  4th  5th  6th  7th 
Ctrl+ 
    (colon) key combination 
    (semicolon) key combination 
Ctrl+ (double quote) key combination
    john add double quote 
Ctrl+' (apostrophe) key combination 
Ctrl+ key combination 
Ctrl+< key combination 
Ctrl++ (plus) key combination  2nd  3rd 
Ctrl++ key combination 
Ctrl+, key combination
    john sb a comma 
Ctrl+- (minus) key combination 
Ctrl+C key combination  2nd 
Ctrl+End keyboard combination 
Ctrl+Enter key combination 
Ctrl+F key combination  2nd 
Ctrl+F1 key combination 
Ctrl+F4 key combination 
Ctrl+F6 key combination 
Ctrl+H key combination  2nd 
Ctrl+Home key combination 
Ctrl+Insert key combination  2nd 
Ctrl+Shift+ key combination 
Ctrl+Shift+ key combination 
Ctrl+Shift+F9 key combination 
Ctrl+spacebar key combination 
Ctrl+V key combination  2nd 
Ctrl+X key combination 
Ctrl+Y key combination 
Ctrl+Z key combination  2nd 
cubes 
currencies.xml file 
currencies.xsd file 
Currency data type 
currency fields 
    default values  2nd  3rd 
current record 
Current Record button 
Cursor Control Language (CCL) 
CursorLocation property
    Connection object 
    Recordset object  2nd 
CursorType property
    Recordset object  2nd  3rd 
custom class modules 
custom subprocedures 
Customer Feedback Options command
    (Help menu) 
Customize AutoFormat dialog box  2nd 
Customize Toolbars dialog box  2nd  3rd  4th  5th 
customizing
    AutoFormat styles  2nd  3rd 
    Table Datasheet view  2nd  3rd  4th  5th 
    toolbars  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
cutting
    Clipboard operations  2nd 
    form controls 
    records  2nd 
CVar function 
CVErr function