Toll Free - 877-442-3915

Account | Self-Paced Login

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

Microsoft Access 2010 Intermediate Course

Microsoft Access 2010 Intermediate Onsite Group Training Course


Course Description: The Microsoft Access 2010 intermediate course leverages the core skills learned in the introductory Access 2010 course, to help students become more adept and productive with Access. We recommend this course for students who have some experience using Access 2010 and want to take their skills to the next level.

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

  • Working with Tables and Fields
  • Creating Relational Databases
  • Working with Queries
  • Working with Forms

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 $1600/day (over 10% off our Individual Training rates)
  • Additional students can be added for $150/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: $1600/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 $2400/day (over 33% off our Individual Training rates)
  • 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 12 students: $2400/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 42% 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 18 students: $3100/day (Flat Rate)

Microsoft Access 2010 Intermediate - Course Syllabus

Microsoft Access 2010 Intermediate - Syllabus

Working with Tables and Fields
Understanding Field Properties
Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Adding Field Descriptions and Captions
Changing the Field Size
Formatting Number, Currency, and Date/Time Fields
Formatting Number, Currency, and Date/Time Fields by Hand
Formatting Text Fields
Setting a Default Value
Requiring Data Entry
Validating Data
Creating an Input Mask
Creating a Lookup Field
Creating a Value List
Modifying a Lookup List
Working with Tables and Fields Review

Creating Relational Databases
Understanding Table Relationships
Creating Relationships Between Tables
Enforcing Referential Integrity
Printing and Deleting Relationships
Understanding Relationship Types
Creating Relational Databases Review

Working with Queries
Understanding Different Types of Queries
Creating a Multiple Table Query
Creating a Calculated Field
Working with Expressions and the Expression Builder
Using an IIf Function
Summarizing Groups of Records
Display Top or Bottom Values
Parameter Queries
Finding Duplicate Records
Finding Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make-Table Queries
Update Queries
Working with Queries Review

Working with Forms
Creating and Using a Form
Understanding Form Views
Modifying a Form in Layout View
Form Design View Basics
Changing Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form Property Reference
Changing a Control’s Data Source
Creating a Calculated Control
Changing a Control’s Default Value
Creating a Subform
Modifying and Working with Subforms
Working with Forms Review

Request a Quote for Onsite Training

Thank you for your interest in our onsite training courses. Please complete the information request form below, and one of our agents will contact you shortly.


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile