Mail us
Home » Posts tagged "access pivot table"

Tag Archives: access pivot table

Access Pivot Table Versus Access Crosstab Query

Ms Access Query

The first thing to note when creating an Access Pivot table or a crosstab Ms Access Query is that they both handle the grouping and summarising of ‘detailed’ records which means in most cases this type of output reports are driven by the typical ‘SELECT’ based query. This article is not to show you how to create pivot tables or crosstab queries but how they differ; helping you to understand the key differences. If you want to know how, take a […]

Tags: , , , , ,

Using Pivot Tables to View Data in Access 2007

Microsoft Access Database

A good overview and introduction to using Access database pivot tables. This video tutorial gives you enough to get you going and experiment with the flexible options of a pivot table and is clearly explained – hence the 10 minute video. The key thing to remember is that you need to think about the grouping and analysis of the data required for this type of report which probably means a query and not a table in which your pivot table […]

Tags: , , , , ,