Toll Free - 877-442-3915

Account | Self-Paced Login

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

Microsoft Access 2013 Intermediate Course

Microsoft Access 2013 Intermediate Onsite Group Training Course


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

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

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

Microsoft Access 2013 Intermediate - Course Syllabus

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 If 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 Sub form
  • Modifying and Working with Sub forms
  • Working with Forms Review

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

Additional 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
  • Additional 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 computers 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