ONLINE Access 2007 Advanced Training Series- 9 hrs

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.        

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