MicrosoftВ® Office ExcelВ® 2003 Step by Step (Step By Step (Microsoft))

Q

queries, 253, 25561, 861

action (see action queries)

adding tables to, 256

aggregate functions, 264

append, 254

commands, displaying, 292

creating, xlv, 255, 290

creating, with wizards, 262

crosstab (see crosstab queries)

delete (see delete queries)

duplicate, 253

fields in, 256

fields in, hiding, 263

vs. filtering/sorting, 254

including fields in, xlvi

make-table, 254

moving all fields to, 295

naming, 261

parameter, 254

renaming, 263

results, viewing, 257

running, xlvi, 257, 263, 291

saving filters as, 250

select (see select queries)

sorting, 257

specifying tables for, 256

unmatched, 253

update (see update queries)

uses for, 241

Query Wizard, 26263

Quick Notes, lxxi, 733, 861

entering text, 735