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

object libraries
object models 2nd 3rd 4th 5th
    learning names in 2nd
    referencing
object variables 2nd 3rd
    declaring 2nd
    objects in For Each loops 2nd
    setting 2nd
objects
    . [See also ADO (ActiveX Data Objects), DAO]
    adding to VBA 2nd
    ADO (ActiveX Data Objects) 2nd
        versions
    Connection (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 5th 6th 7th 8th 9th 10th 11th
        UDL (universal data link) files 2nd 3rd 4th 5th 6th
    DAO (Data Access Objects) 2nd
        versions
    methods
    object libraries
    object models 2nd 3rd 4th 5th
        learning names in 2nd
        referencing
    Parameter
    properties
ODBC Microsoft Access Setup dialog box 2nd
OFFSET function 2nd
Offset function 2nd
OFFSET function
    BaseCells 2nd
    example 2nd
    Height/Width arguments 2nd 3rd
    multiple cells, returning 2nd 3rd
OLAP Cubes
On Error GoTo statement
one-to-many relationships 2nd
one-to-one relationships 2nd
Online Analytic Processing (OLAP) Cubes
Open event 2nd 3rd 4th 5th 6th 7th 8th
Open function
Open method
    arguments 2nd 3rd 4th
    example 2nd 3rd
OpenDatabase method 2nd 3rd
opening
    ADO connections 2nd 3rd 4th
        GetConnectionStrings function 2nd
        MakeTheConnection function 2nd
        Open method with arguments 2nd 3rd 4th
        Open method with no arguments 2nd 3rd
    DAO connections 2nd
    secured Access databases 2nd 3rd 4th
OpenRecordset() function 2nd 3rd 4th
optimistic locking
Optimize Memory option (pivot tables)
Option Explicit statement 2nd
Options command (Tools menu)
Options parameter (OpenDatabase method)
Options property (CreateDatabase method)
Options property (OpenRecordset() function)
orientation
    changing with Paste Special command 2nd
    changing with TRANSPOSE function 2nd
outer joins 2nd 3rd 4th
overworking functions 2nd 3rd 4th 5th 6th
Overwrite Existing Cells with New Data, Clear Unused Cells property (data ranges)

Table of content

Managing Data with Microsoft Excel

ISBN: 789731002
EAN: N/A

Year: 2003
Pages: 134

BUY ON AMAZON

Interprocess Communications in Linux: The Nooks and Crannies

The CISSP and CAP Prep Guide: Platinum Edition

Cisco Voice Gateways and Gatekeepers

Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment

Introducing Microsoft ASP.NET AJAX (Pro - Developer)

Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)