Index_F

F

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