1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 

"Wonderful. The trainer was a joy. She was personable, friendly, and a dream to work with. I loved ho..." More quotes

Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ ONLINE ACCESS 2007 ADVANCED TRAINING

Save money by buying series in packages. This course series is included with the following package:

Packages include 24/7 access to subject matter experts.

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

Overview | Catalog | Benefits | FAQs | Try Free Course | Buy | Log in | Support

Online Training

Only $42.95
12-month subscription

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.

Access 2007 Advanced Series (9 hours)

ONLINE TRAINING FEATURES

  • 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. Expressions and Queries

Time: 3 hours
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.

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

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. PivotTables, PivotCharts, and Graphs

Time: 3 hours
This course provides an introduction to working with PivotTables and PivotCharts.

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

Topics

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

3. Macros and Data Imports/Exports

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

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

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
home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA