Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Access 2010 Advanced Course

Microsoft Access 2010 Advanced Onsite Group Training Course


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

The Advanced Access 2010 Training Course will cover the following subject areas:

  • Working with Reports
  • Formatting Forms and Reports
  • Working with Macros
  • Using Macros Effectively
  • Advanced Access Functions

Microsoft Access 2010 Advanced - Course Syllabus

Microsoft Access 2010 Advanced - 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
Working with Reports Review

Formatting Forms and Reports
Formatting Fonts
Changing Text Alignment
Changing Colors
Using Conditional Formatting
Adding Pictures, Lines and Gridlines
Working with Number Formatting
Using Themes
Formatting Forms and Reports Review

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

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
Advanced Topics Review

How On-Site Training Works
How On-Site Training Works

  • Discuss your team's educational needs with a BCS representative.
  • Schedule class date(s) that fit your team's availabilty.
  • Professional Trainer will conduct the class at your facility or online.
  • We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
  • You provide the meeting/conference room, student xomputers with correct software installed and a projector for the instructor to use.
  • Usually a two-week lead time to schedule a class.
  • Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
  • 1 Hour Lunch Break, and Two 15-minute Break

On-Site access Training Packages
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)

On-Site Training Request

Please complete the information request form below, and one of our representatives will contact you within one business day.







"Great class!! Clear explanations of complex topics. I could repeat lessons as many times as needed to make sure I mastered them."
- Thomas L(Akron, OH)


Business Computer Skills Microsoft Partner
Business Computer Skills BBB Profile