ms access courses - pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access courses - Pivot tables

ms access courses - Pivot tables

resolvedResolved · Low Priority · Version Standard

Sheila has attended:
Access Advanced course

Pivot tables

what is a pivot table

RE: pivot tables

Hi Sheila

A Pivot table allows you to easily sort and view the data in a table in whichever way you need to.

You can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data.

Pivot tables are useful to create crosstabs quickly. You set up and change the summary's structure by dragging-and-dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

To do this:

1. In the Tables area of the database

2. Select and open the required table

3. Select the View menu and click Pivot Table view

The table turns into a blank Pivot table

Move the fields you wish from the Field list to the table

Hope this helps

Carlos


 

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Server loaded in 0.09 secs.