Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

Q

Query, 63–70, 213, 220

Query Analyzer, SQL Server 2000, 333

Query Wizard, Excel, 62–63, 219–24, 347–48

querying

Access, 142, 145–50, 155–56, 354–55

data analysis and, 28

data connection file types, 213

Excel, 12, 63–70, 275–76, 347–49

OLAP data, 219–24, 349

relational data, 33

SQL Server, 14

Web data, 12, 67–70, 156, 275–76, 348

question mark (?), 45

quick references

Access, 353–55

Data Analyzer, 358–61

Excel, 345–49

Office Web Components, 356–58

OLAP data in Excel, 349–51

PivotTable and PivotChart reports, 351–53

Категории