fact tables, 196
facts, 2
Field List, 97, 100, 110–12
fields
data list, 31–32, 70
defined, 2
PivotChart report, 99–101, 352–53
PivotTable Component, 358
PivotTable report, 97–99, 116–23, 352–53
file types, data connection, 213
file-based data storage, 3, 10–11
files
cube. See cubes, OLAP
Data Analyzer view, 358–59
workgroup information, 338
filtering
Access, 13, 139–46, 313–15, 354
Chart Component, 187–88
data analysis and, 24–25
Excel, 44–49
Excel data lists, 297–302, 345–46
imported data, 62–63
Office Web Components, 356–57
PivotTable and PivotChart reports, 118–20, 352
PivotTable Component, 176–78
querying vs., 28, 146
relational data, 33
sorting vs., 20
Spreadsheet Component, 169–70
flattener, Excel XML spreadsheet schema, 266–70
fonts, formatting, 55
foreign keys, 131
Form view, Access, 138
Form Wizard, Access, 135
FormatCondition object, 306–8
formats, data
Access importing and, 133
Access linking and, 136
data analysis and, 2–4, 9–10
Excel importing and, 61
importing, exporting, querying, and, 27–28
OLAP. See cubes, OLAP
VBScript Variant data type, 318
XML. See XML data
formatting
data analysis and, 25–26
Excel conditional, 54–57, 306–8, 346
sorting vs., 20
Formula Bar, Excel, 53
FrontPage, 161–62, 211
functions
Analysis ToolPak, 349
Excel worksheet, 49–54, 72, 121, 302–6, 346
MDX, 246
Office Web Components summary, 167–70, 178–79, 190, 357–58
SQL Server, 155