Microsoft Office Access 2010: Level 2 Training in Medford

Enroll in or hire us to teach our Microsoft Office Access 2010: Level 2 class in Medford, Massachusetts by calling us @303.377.6176. Like all HSG classes, Microsoft Office Access 2010: Level 2 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Access 2010: Level 2 may be taught at one of our local training facilities.

Answers to Popular Questions:

Yes, this class can be tailored to meet your specific training needs.
Yes, we provide consulting services.
Yes, group discounts are provided.

Course Description

You will improve and customize tables, queries, forms and reports, and share Access data with other applications.
Course Length: 1 Days
Course Tuition: $250 (US)


To ensure your success, we recommend that you first take Microsoft Office Access 2010 : Level 1, or have equivalent knowledge and skills.

Course Outline


Lesson 1: Controlling Data Entry
     Constrain Data Entry Using Field Properties
     Establish Data Entry Formats for Entering Field Values
     Create a List of Values for a Field

Lesson 2: Joining Tables
     Create Query Joins
     Join Tables with No Common Fields
     Relate Data Within a Table

Lesson 3: Creating Flexible Queries
     Set the Select Query Properties
     Retrieve Records Based on Input Criteria
     Create Action Queries

Lesson 4: Improving Forms
     Restrict Data Entry in Forms
     Organize Information with Tab Pages
     Add a Command Button to a Form
     Create a Subform
     Display a Summary of Data in a Form
     Change the Display of Data Conditionally

Lesson 5: Customizing Reports
     Organize Report Information
     Format Reports
     Control Report Pagination
     Summarize Report Information
     Add a Subreport to an Existing Report
     Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications
     Import Data into Access
     Export Data to Text File Formats
     Export Access Data to Excel
     Create a Mail Merge

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.