Notice:  As of December 14, 2016, the MindBites Website and Service will cease its operations.  Further information can be found here.  

Hi! We show you're using Internet Explorer 6. Unfortunately, IE6 is an older browser and everything at MindBites may not work for you. We recommend upgrading (for free) to the latest version of Internet Explorer from Microsoft or Firefox from Mozilla.
Click here to read more about IE6 and why it makes sense to upgrade.

Microsoft Access: Crosstab (Pivot Table) Queries

Screencast HD Screencasts now available in their original high resolution. Click here to view this video in a new window at actual size!

Like what you see? false to watch the full lesson online.

You Might Also Like

About this Lesson

  • Type: Video Tutorial
  • Length: 34:41
  • Media: Flash video file
  • Use: Watch Online
  • Access Period: Unrestricted
  • Posted: 06/16/2011

This lesson is part of the following series:

Computer Apps Bundle - ALL Videos (23 lessons, $346.50)
Microsoft Access & Excel: Concept Video Series (14 lessons, $217.80)
Microsoft Access: Understanding & Creating Queries (5 lessons, $89.10)

This is the fifth of a series that covers the nuts and bolts of queries in Microsoft Access. This series is designed for students and coaches seeking to learn access to compete in the UIL High School Computer Applications contest but has proven to be useful for anyone seeking to learn or brush up on their Access skills. In this lesson, we focus on the crosstab query features and functionality in Microsoft Access.

In this video, you'll learn how crosstab queries work, what row headings, column headings and values are in the context of crosstab queries, what the limitations of Access crosstab queries are, how Access crosstab queries are similar and dissimilar to Excel pivot tables, what the limitations and benefits of both crosstab queries and pivot tables are, etc.

To illustrate these things, we'll go through example crosstab queries in Microsoft Access (and example pivot table creation and manipulation in Excel to provide a point of reference). Note that starting point access and excel files are attached as are ending point databases and worksbooks in order to allow you to work off of the starting document and compare your results to the ending document.

This video is screencasted. To watch it in the resolution in which it was recorded (which will offer a crisper screen resolution than the player here), move your mouse over the player and click the 100% (Actual Size) button.

This video was recorded using Microsoft Access 2010. There are very minor differences in newer versions and the content covered here is the same across versions. A minor difference is that the Pivot Table labels have been shortened.

Supplementary Files

  • Once you purchase this lesson you will have access to these files:
  • Crosstab_Queries__-_Starting_File.accdb Crosstab_Queries__-_Starting_File.accdb
  • Crosstab_Queries__-_Ending_File.accdb Crosstab_Queries__-_Ending_File.accdb
  • Crosstab_Queries_-_Starting_File.xlsx Crosstab_Queries_-_Starting_File.xlsx
  • Crosstab_Queries_-_Ending_File.xlsx Crosstab_Queries_-_Ending_File.xlsx

About this Author

Hexco Academic
Hexco Academic
31 lessons

Academic publishing company for 28+ years offering instructional videos, books, software, virtual flashcards, workshops, spelling coaching, and geographic coaching. Most products are geared for competitive academics and home schooling to include materials to study for the Scripps' National Spelling Bee, National Geographic Bee, Texas University Interscholastic League (UIL), North South Foundation, TAPPS, SAT, and more. The 2010 National Spelling Bee champion, Anamika Veeramani was the 11th champion in a row to use our products. Studio Hexco at MindBites is a collection of course material and live presentations by experts in a variety of popular topics. We welcome and appreciate your...


Recent Reviews

This lesson has not been reviewed.
Please purchase the lesson to review.
This lesson has not been reviewed.
Please purchase the lesson to review.

Embed this video on your site

Copy and paste the following snippet: