Productivity & Collaboration Tools     Microsoft Office 2010     Access 2010     Microsoft Office 2010: Advanced Access

---

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.

---

---

Objectives
PivotTables and PivotCharts 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