Site Navigation
Private/Group Training
- On-Site Training
- Online Training
- Local Training
Public Courses
Self-Paced Online Classes
User Login
My Account
Self Paced Class Login
Call Toll Free for Customer Service at 800-682-9613
Microsoft Training
Excel Training Classes
Access Training Classes
Project Training Classes
PowerPoint Training Classes
Word Training Classes
Outlook Training Classes
Partner Sites
California Computer Training
Chicago Computer Training
Kids Credit School
Computer Training   | Access Courses   | Microsoft Access 2007 Advanced
Microsoft Access 2007 Advanced Course

Microsoft Access 2007 Advanced Training Course


Course Decription: The Microsoft Access 2007 advanced course utilizes the skills learned in the Introductory and Intermediate Access 2007 courses, to help users understand the more complex topics in Access 2007. We recommend this course for students who have significant experience using Access 2007, and want to completely master the program.

The Advanced Access 2007 Training Course will cover the following subject areas:
  • Working with Reports
  • Formatting Forms and Reports
  • Working with Macros
  • Using Macros Effectively
  • Advanced Access Functions
  • Course Schedule
  • Syllabus
  • Self-Paced Training
  • Related Courses
  • Corporate Training
Online Instructor Led Class Dates:
Start Date End Date Time Location Price Seats Registration
8/19/20108/19/201010AM-5PM CSTOnline$250.0014Class Registration
10/4/201010/4/201010AM-5PM CSTOnline$250.0014Class Registration
Course Syllabus:

Working with Reports

Creating a Report
Working in Layout View
Adding a Logo
Working in Design View
Adjusting Page Margins and Orientation
Adding Page Numbers and Dates
Grouping and Sorting
Summarize Data using Totals
Understanding Report Sections

Formatting Forms and Reports

Formatting Fonts
Changing Text Alignment
Changing Colors
Applying Special Effects
Using Conditional Formatting
Adding Pictures, Lines and Gridlines
Working with Number Formatting
Using AutoFormat

Working with Macros

Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Shortcut
Macro Action Reference

Advanced Topics

Importing Information
Exporting Information
Linking Information from an External Source
Using Hyperlink Fields
Displaying Database Object Dependencies
Setting a Password in Access
Compacting and Repairing a Database
Corporate Training Options:

Option 1: On-Site Microsoft Access 2007 Advanced Training
  • Access Training at your office.
  • Microsoft Certified Intructor teaches the class in person
  • Flat Rate of $1500/class day, up to 12 students can attend
  • Training Materials Provided at no extra charge
  • Additional Students can be added for $125/person
Option 2: Online Microsoft Access 2007 Advanced Training
  • Access Training at your office.
  • Microsoft Certified Intructor teaches the class via web conference
  • Flat Rate of $1100/class day, up to 12 students can attend
  • Training Materials Provided at no extra charge
  • Additional Students can be added for $125/person




Find Access Training Near You:
Albuquerque
Arlington
Atlanta
Austin
Baltimore
Boston
Charlotte
Chicago
Cleveland
Colorado Springs
Columbus
Dallas
Denver
Detroit
El Paso
Fort Worth
Fresno
Honolulu
Houston
Indianapolis
Jacksonville
Kansas City
Las Vegas
Long Beach
Los Angeles
Louisville
Memphis
Mesa
Miami
Milwaukee
Minneapolis
Nashville
New Orleans
New York
Oakland
Oklahoma City
Omaha
Orlando
Philadelphia
Phoenix
Portland
Sacramento
St Louis
San Antonio
San Diego
San Francisco
San Jose
Seattle
Tampa
Tucson
Virginia Beach
Washington DC