page fields, 98–99, 101
pages, PivotTable and PivotChart report, 97
pages, Web. See Web pages
passwords, Access, 340–41
percentages as totals, 181–82
percentile tool, Excel, 83–84, 87–88
performance, SQL Server, 15
Performance Analyzer, Access, 339
periodic sampling, 84
pie charts, 28, 58–59, 228, 360
PivotChart reports, Excel
calculated fields and calculated items, 352–53
charting data, 29
creating, 124–27, 351–52
creating, using code, 308–11
creating, with wizard, 105–9
Data Analyzer vs., 226–27
as data sources, 108–9
features, 99–101
filtering data, 352
PivotTable reports and, 12, 95–96, 124. See also PivotTable reports, Excel
PivotChart views, Access, 13, 138, 153–55, 355
pivoting, 30–31, 95–96. See also PivotChart reports, Excel; PivotChart views, Access; PivotTable Component; PivotTable reports, Excel; PivotTable views, Access
PivotTable Component, 172–82. See also Office Web Components
analyzing data, 175–80, 357–58
features, 14, 172–75, 181–82
OLAP data, 211–14
programming, using code, 315–20
PivotTable reports, Excel, 95–127
calculated fields and calculated items, 120–23, 352–53
creating, 101–4, 351–52
creating, using code, 308–11
creating, with wizard, 105–9, 124–27
Data Analyzer and, 226–27, 255–56
as data sources, 108–9
features, 96–104
Field List, 110–12
Field Settings, 116–18
filtering data, 118–20, 352
multidimensional data and, 35–36
OLAP data and, 208–11, 214–18, 349–50
PivotChart reports and, 12, 29, 95–96, 124–27. See also PivotChart reports, Excel
pivoting data, 30–31, 95–96
quick reference, 351–53
toolbar and shortcut menu, 112–16
XML data and, 269–70, 274–75
PivotTable views, Access, 13, 138, 153–55, 355
plans, database maintenance, 330–31, 335–36
plus sign (+), 255
PowerPoint slides, exporting Data Analyzer views to, 256–57, 361
primary keys, 131
procedures, 284–89
processing instructions, XML, 264
processing OLAP cubes, 341–43
programming. See code
Project Explorer, 290
projects, Access, 155–56
properties, 28, 290
Properties window, 290