O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Conclusion

In this chapter, you learned the basics of pivot tables and pivot charts. Hopefully the discussion was useful, but I'm certain that for some readers it was simplistic. The examples I used didn't include any calculated expressions, which are often integral to data analyses. For example, extensions of quantity and unit price (such as 7 units @ $3 = $21) would be handled by a calculated expression.

An excellent place to learn about the use of calculated expressions in pivot tables/charts is a Microsoft Support WebCast on the topic; in fact, it's a good introduction (or, at this point, review) of the entire area. The webcast is for Access 2002, but nearly all of it is still applicable for Access 2003. You can find it as Microsoft Knowledge ...

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