Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Microsoft Access 2010 - Level 2 & 3 / Advanced

Learn to perform advanced tasks in Access 2010 such as creating advanced queries, subforms, pivot tables and pivot charts.

GK# 6697

Course Overview


Students will learn to perform advanced form tasks using subfoms and macros. Learn to create pivot tables and pivot charts and be introduced to SQL statements.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn


In this course, you will be given the tools to become an Access 2010 power user. Learn in depth methods to manage data and data entry; create forms, and dialog boxes; split databases; create and use pivot tables and charts; utilizing Add-Ons and SQL.


Viewing outline for:

Classroom Live Outline

Advanced Table Tasks

  • Using the Table Analyzer Wizard
  • Creating Validation Rules
  • Configuring Validation Messages

Managing Data Entry in Tables

  • Creating Lookup Fields
  • Creating Value Lists
  • Creating Input Masks

Creating Advanced Queries

  • Creating and Using Parameter Queries
  • Creating and Using Crosstab Queries
  • Creating and Using Make-Table Queries
  • Creating and Using Multiple Table Queries
  • Creating and Using Append Queries
  • Creating and Using Delete Queries
  • Creating and Using Update Queries

Creating Subforms

  • Creating Subforms
  • Using Subforms
  • Linking Subforms with Parent Forms
  • Formatting a Subform Within a Main Form

Creating Navigation Forms

  • Creating a Navigation Form
  • Adding Tabs to a Navigation Form
  • Creating a Tab Hierarchy
  • Displaying the Navigation Form when the Database Opens

Splitting the Database

  • Backing Up the Database
  • Splitting the Database

Advanced Data Management

  • Referential Integrity
  • Table Relationships
  • Switchboards
  • Modal Dialogue Boxes

Advanced Form Tasks

  • Using Subforms
  • Advanced Form Tasks
  • Exporting Your Form
  • Using Outlook and SharePoint with Access

Pivoting Data

  • Creating a PivotTable
  • Creating a PivotChart
  • Using PivotTables and PivotCharts

Access and Windows

  • Access and Windows
  • Using the Access Viewer
  • An Introduction to SQL

Add-Ons to Access

  • COM Add-ins
  • Digital Signatures
  • Smart Tags
  • Managing Your Database
  • Customizing Access

Using Scripts in Access

  • Macro Basics
  • Other Macro Tasks
  • Visual Basic and Macros
  • Macro Groups

Using Access to Collaborate

  • SharePoint Basics
  • SharePoint Data
  • Your Personal SharePoint Space

SQL and Microsoft Access

  • Understanding SQL
  • Using the Select Statement
  • Using Subqueries
  • Using SQL Joins



The prerequisites for this course is our Access Level 1 course or an equivalent working knowledge of Access or other database applications.

Who Should Attend


For those who require greater complexity in their data management than Access Level 1 provides.

Training Exclusives

This Office course comes with extended access to the following benefits:

  • Concept Training
  • ClipTraining Video Library
  • Free Refreshers
  • Online Course Content
Learn More >
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Request this course in a different delivery format.