Webucator personnel did a great job meeting our specific needs and in putting our class together. More Testimonials »

Access 2007 Advanced eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. FAQs
  10.  | 
  11. Try Free
  12.  | 
  13. Cancellation
  14.  | 
  15. Login
  16.  | 
  17. Support
Click here for Microsoft Official Curriculum eLearning courses
Save money by buying eLearning courses in packages.

Packages include multiple eLearning courses that are bundled together for a great value.

Of course, you can buy this Access 2007 Advanced eLearning course individually as well. Just click on the "Register Now" button below.

Access 2007 Advanced eLearning Course Series (9 hours)

Access 2007 offers many more powerful features than a beginning user first touches. 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.

Self-Paced eLearning Course Benefits

Only $42.95

12-month subscription!

Register Now

  • Learn online with these interactive online courses.
  • Affordable Pricing (Only $42.95 for the complete series)
  • A full year to complete the courses
  • Retake the courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Access 2007 Advanced:1 Expressions and Queries (Time: 3 hours)

This eLearning 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.

Course Objectives

  • 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

Course Topics

  • Expressions, operators, literals, constants
  • Working with functions
  • Types of functions
  • Creating expressions
  • Using inner joins for multitable queries
  • Using outer, self, and theta joins
  • Creating crosstab queries

2. Access 2007 Advanced:2 PivotTables, PivotCharts, and Graphs (Time: 3 hours)

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

Course Objectives

  • 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

Course Topics

  • Working with PivotTables
  • Creating PivotTables
  • Exporting and optimizing PivotTables
  • Working with PivotCharts
  • Working with graphs
  • Modifying graphs
  • Using PivotChart forms

3. Access 2007 Advanced:3 Macros and Data Imports/Exports (Time: 3 hours)

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

Course Objectives

  • 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

Course Topics

  • Introducing macros and events
  • Generating embedded macros
  • Importing and linking Excel data
  • Importing text files
  • Exporting data from Access
  • Importing XML data
  • Exporting tables and queries to XML
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723