O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Go Multidimensional with PivotTables

A PivotTable is an analysis tool that offers a great deal of flexibility for viewing summary data from different perspectives. You can think of a PivotTable as an expandable summary because it neatly tucks information away to be viewed by expanding your selection. For example, if you view summary information by the year, you can drill down to expand any year to see its details. The capability to “pivot” the perspective of your table by transposing rows and columns gives the PivotTable its name.

PivotTables give new meaning to the term interactive, which refers to the capability of users to enter data or commands in programs, as opposed to just viewing data. Tables and forms are interactive to a certain extent. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required