index_C | Managing Data with Microsoft Excel

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

cache
    refreshing 2nd
        Refresh on Open versus Workbook_Open event 2nd 3rd 4th 5th 6th 7th 8th
    suppressing
calculating
    commissions
        VLOOKUP function 2nd 3rd
case studies
    Append and Delete queries 2nd
    Ballou Realty
        multiple table queries 2nd 3rd 4th
    The Sisyphus Corporation
        functions, overworking 2nd 3rd 4th 5th 6th
    TotalByVendor worksheet 2nd 3rd 4th 5th
catalogs
CellColor variable
cells
    BaseCells 2nd
    basis cells
    bottommost cells
        defined
        distinguishing from last cell 2nd
    last cell search, extending 2nd 3rd 4th
    rightmost cells
        defined
Cells command (Format menu)
check boxes
    queries 2nd 3rd 4th
child records
    joining with parent records 2nd
        inner joins 2nd 3rd
        outer joins 2nd 3rd 4th
        parent record selection 2nd 3rd
        relational structures 2nd 3rd
Chipman, Mary
Choose Columns window (Query Wizard)
Choose Data Source dialog box 2nd 3rd 4th
classes
    defined
CleanupPeriods variable
Clear function
clearing
    worksheets 2nd
Close and return to Microsoft Excel command (File menu)
cmd object variable
cnn object variable
code listings
    Reservations application 2nd 3rd 4th 5th 6th 7th 8th 9th
codes
    codes versus labels 2nd
        data validation 2nd 3rd
        lookups 2nd 3rd 4th
coding
collapse dialog buttons
COLUMN function
column headings
columns
    column headings
    transposing rows and columns 2nd
        Paste Special command 2nd
        TRANSPOSE function 2nd
COLUMNS function
combo boxes
commands
    Application.DisplayAlerts
    Data menu
        Filter
        Form
        Get External Data 2nd
        Group and Outline
        Import External Data 2nd 3rd 4th
        List
        PivotTable and PivotChart Report
        Refresh External Data
        Sort 2nd 3rd
    Edit menu
        Find
        Paste Special 2nd 3rd 4th 5th
    File menu
        Close and return to Microsoft Excel
        Return Data to Microsoft Excel
        Save
    Filter menu
        Advanced Filter
        AutoFilter
        Show All
    Get External Data menu
        Import
        New Database Query
    Insert menu
        Modules
        Name
    List menu
        Create List
        Total Row
    Macro menu
        Record New Macro 2nd
        Stop Recording
    Name menu
        Define 2nd 3rd
    Paste Special menu
        Transpose
    Query menu
        Append Query
        Delete Query
        Run
        Update Query
    Relationships menu
        Edit Relationship
        Show Direct
        Show Table
    Table menu
        Joins
    Tools menu
        Macros
        Options
        References
    Tools menu commands
        Security
    View menu
        Relationships
commans
    Format menu
        Cells
commas (,)
commissions
    calculating with VLOOKUP 2nd 3rd
Confirm Workgroup Information dialog box
confirming
    user requests 2nd
Connect parameter (OpenDatabase method)
connecting to databases 2nd
    ADO connections
        ADO library, referencing 2nd 3rd
        connection strings 2nd 3rd 4th 5th 6th 7th 8th 9th
        data sources, specifying 2nd
        declaring 2nd
        instantiating 2nd
        New keyword 2nd
        opening 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
        records, adding 2nd 3rd
        records, editing 2nd 3rd 4th
        UDL (universal data link) files 2nd 3rd 4th 5th 6th
    DAO connections 2nd
        DAO library, referencing 2nd 3rd
        declaring 2nd 3rd
        file types, filtering 2nd 3rd
        GetOpenFilename method 2nd 3rd 4th 5th 6th
        locating databases 2nd
        OpenDatabase method
        opening 2nd
        records, adding 2nd 3rd
        records, editing 2nd 3rd 4th
    Jet databases 2nd 3rd 4th
        Access database passwords 2nd 3rd 4th
        Admin restrictions
        opening 2nd 3rd 4th
        password requests 2nd 3rd
        securing 2nd 3rd 4th 5th 6th
        user accounts, creating 2nd
        user-level security 2nd 3rd 4th
        workgroup information files 2nd 3rd 4th
Connection object (ADO)
    ADO library, referencing 2nd 3rd
    ConnectionString property 2nd 3rd 4th 5th 6th 7th 8th 9th
    data sources, specifying 2nd
    declaring 2nd
    instantiating 2nd
    New keyword 2nd
    opening 2nd 3rd 4th
        GetConnectionStrings function 2nd
        MakeTheConnection function 2nd
        Open method with arguments 2nd 3rd 4th
        Open method with no arguments 2nd 3rd
    UDL (universal data link) files 2nd 3rd 4th 5th 6th
connection strings
    ADO 2nd 3rd 4th 5th 6th 7th 8th 9th
ConnectionString property (Connection object) 2nd 3rd 4th 5th 6th 7th 8th 9th
constants
    naming 2nd
CopyFromRecordset function 2nd 3rd 4th 5th
CopyFromRecordset method
    ADO recordsets 2nd
    DAO recordsets 2nd
CopyFromRecordsetWithADO() function 2nd
CopyFromRecordsetWithDAO() function
copying
    external data ranges
    recordset data to workbooks 2nd 3rd 4th 5th
        ADO recordsets 2nd
        DAO recordsets 2nd
COUNT function
Create List command (List menu)
Create New Data Source dialog box
CreateDatabase method
CreateDatabase statement
CreateDatabaseWithDAO() function 2nd 3rd 4th 5th 6th 7th
CreateQueryDef function
criteria (queries) 2nd 3rd
CurDir method
CursorLocation property (recordsets) 2nd
cursors 2nd
CursorType property (recordsets) 2nd
Custom AutoFilter 2nd 3rd

Table of content

Managing Data with Microsoft Excel

ISBN: 789731002
EAN: N/A

Year: 2003
Pages: 134

BUY ON AMAZON

Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)

Inside Network Security Assessment: Guarding Your IT Infrastructure

Systematic Software Testing (Artech House Computer Library)

Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century

Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain

Microsoft VBScript Professional Projects