PivotTables and PivotCharts in Access 2010

Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
This course demonstrates how to create and manipulate PivotTables and PivotCharts as an effective way to organize and display Access 2010 database data, such as showing and hiding data, sorting and filtering data, performing basic and complex calculations, and exporting to an Excel spreadsheet.

Target Audience
A broad range of business users

Expected Duration (hours)
1.0

Lesson Objectives

PivotTables and PivotCharts in Access 2010

identify key characteristics of Access PivotTables

create a PivotTable in an Access database

use a PivotTable to analyze data

create a PivotChart in an Access database

edit a PivotChart

create a PivotTable and manipulate its data

create a PivotChart and manipulate its data

Course Number:
mo_aacc_a02_dt_enus

Expertise Level
Intermediate