Index_O


O

Object Browser, 291–94

object models, 289–97. See also code

Application object, 294–97

Object Browser and online help, 291–94

objects, 289–90

Visual Basic Editor and, 290–91

observational data capture, 8

Office. See Microsoft software

Office Web Components, 159–92

Chart Component, 182–92

creating, 161–62

data storage, 11–12

Excel and, 12

features, 13–14, 159–61

OLAP data and, 205, 211–14

PivotTable Component, 172–82

programming, using code, 291, 315–20

quick reference, 356–58

Spreadsheet Component, 162–72

offline cube files. See cubes, OLAP

OLAP. See online analytical processing

OLTP (online transaction processing), 9, 201–2

one-to-many relationships, 32

one-to-one relationships, 32

online analytical processing (OLAP), 193–206

advantages, 194–95

business decisions and, 199–201

calculated fields and calculated items, 120

cubes. See cubes, OLAP

data analysis, 204–5. See also Data Analyzer; Excel, OLAP data analysis with

data storage options, 203–4

features, 195–99

multidimensional data and, 32–33, 193–94

online transaction processing (OLTP) and, 9, 201–2

online help, Office VBA, 291–94. See also help

online transaction processing (OLTP), 9, 201–2

Open Database Connnectivity (ODBC) File Data Source Name files, 213

opening

data in Excel, 61

offline cube files in Excel, 351

XML data in Excel, 311–13

operators, for Access filters, 144

orphaned records, 34

output range, 75




Accessing and Analyzing Data With Microsoft Excel
Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
ISBN: 073561895X
EAN: 2147483647
Year: 2006
Pages: 137
Authors: Paul Cornell

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net