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