Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
1035
Troubleshooting
To create a PivotTable view of a query, open the query in Datasheet view and then choose
View, PivotTable View. As shown in Figure 38.9, you can drag columns from the Field List
to the “drop zones” on the PivotTable canvas to build the PivotTable.
Figure 38.9
Access PivotTables
work much like their
Excel counterparts.
Access PivotTables are a powerful way to analyze data interactively, just as they are in Excel.
Excel PivotTables are easier to use for simple lists; use Access PivotTables when you need to
combine data from multiple sources for analysis.
Troubleshooting
Tracking Down Data Integrity Problems
I applied a validation rule to ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link