Index_A


A

Access, 129–57

backing up and restoring databases, 338

compacting and repairing databases, 339–40

data access pages, 156

database maintenance, 337–41

connecting to external data, 132–37, 353

documenting databases, 337

features, 13, 129–30, 202

as file-based, 11, 194–95

filtering data, 139–46, 354

Office Web Components and, 160

OLAP and, 205

Performance Analyzer, 339

PivotTable and PivotChart views, 153–55, 355

programming, using code, 313–15

querying data, 146–50, 354–55

quick reference, 353–55

relational data, nonrelational data, and, 33–35, 130–32

reports, 150–53, 355

securing databases, 340–41

sorting, 138–39, 144–46, 353

SQL Server 2000 databases and, 155–56

SQL Server 2000 Desktop Engine and, 16

Table Analyzer Wizard, 339

XML data analysis, 277–80

active reports, 98

Advanced Filter, Excel, 46–48, 346

Advanced Filter/Sort, Access, 140, 144–46, 354

aggregation, OLAP, 200–201

Analysis Services. See SQL Server 2000 Analysis Services

Analysis ToolPak, Excel, 73–88

Descriptive Statistics tool, 76–78

Histogram tool, 78–80

inserting functions using code, 302–6

installing, 74

Moving Average tool, 81–83

Rank and Percentile tool, 83–84

running functions, 349

Sampling tool, 84–88

tools, 73–76, 87–88

append queries, 147

Application object, 294–97

applications, business intelligence, 225. See also Microsoft software

archiving. See backing up

area charts, 28, 58–59

areas

PivotChart report, 100

PivotTable report, 97–98

arguments, function, 49

asterisk (*), 45

attributes, XML, 37, 262

AutoCalc, 178, 357–58

AutoFilter

Excel, 44–46, 49, 345

Spreadsheet Component, 169–70, 356–57

AutoFormat, 113

automated data capture, 8

AutoSum, 168–69

average tool, Excel, 81–83, 87–88




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