Access 2007 Advanced Series

For pricing see our e commerce site at www.AuditExcel.com

Summary

Access 2007 offers many more powerful features than a beginning user first touch. This series will explore some of the more powerful abilities of Access, including pivot tables and charts, graphs, forms, security, multitable and crosstab queries, macros, and more.

Audience

This series is for anyone who wants to move beyond the basic concepts of Microsoft Access.

Access 2007 Advanced Macros and Data Imports/Exports - 3 hrs

This course focuses on the use of macros and the ability to import and export data between Microsoft Access 2007 and other programs.

View macro events and actions
Create embedded macros
Import and link data from Excel
Import text data
Export Access data
Import and export XML data

Access 2007 Advanced Expressions and Queries - 3 hrs

This course focuses on the use of VBA functions when creating queries, and examples of queries that use the four basic types of joins you can create in Microsoft Access 2007.

Discuss the elements of expressions
Use the Immediate window to test return values of VBA functions
Describe the use of inner joins
outer joins
self-joins
and theta joins in queries
Create crosstab queries using the Crosstab Query Wizard

Access 2007 Advanced PivotTables, PivotCharts, and Graphs - 3 hrs

This course provides an introduction to working with PivotTables and PivotCharts.

Describe the main features of PivotTables and PivotCharts
Create a query for a PivotTable
Create
optimize
and export PivotTables
Create and modify PivotCharts

Create and modify Graphs

Purchase this course from our e commerce site at www.AuditExcel.com

Downloads and Free Trial

See how it works with our free Excel 2003 beginner course.

Convince you manager to pay for your education

More about the training material and how it works

Looking for something else? Search the site