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