Computer and Business Skills training

Sign Up
Home / Access / Level 2

Microsoft Access Training Course Level 2

Course Description

This hands-on intermediate course is suitable for Access 2010/2013/2016 users.

Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.

On this course you will extend your knowledge of Access by building a more complex database, working with external data, running more advanced queries, building more complex forms and generating detailed reports.

You should have completed our Introduction class or have a basic knowledge of Microsoft Access prior to attending.

View our full range of MS Access training courses, or see below for the detailed outline for Access Level 2.

1 Day | $350.00

Register button

Detailed course outline

  • Advanced Record Tasks
    • Showing Totals
    • Adding from Outlook
    • Saving a Record as an Outlook Contact
    • Adjust Row Height
    • Hiding and Un-hiding Fields
    • Freezing and Unfreezing Fields
    • Formatting Text
  • Adding Data Fields
    • Adding Rich Text and Long Text Fields
    • Adding Attachment Fields
    • Adding Hyperlink Fields
    • Adding Lookup & Relationship Fields
    • Adding Calculated Fields
  • Advanced Field Tasks
    • Adjusting the Field Size/Width
    • Setting Field Default Value
    • Working with More Fields
    • Working with Field Validation Options
    • Using the Field List
  • Working in Table Design View
    • Opening Design View
    • Working with Field Properties
    • Setting the Primary Key
    • Using the Properties Sheet
    • Working with Table Properties
    • Viewing Table Relationships
    • Using Relationship Tools
    • Viewing Object Dependencies
  • Working with External Data
    • Linking Data
    • Importing Data
    • Using the Table Analyzer
    • Refreshing Data
    • Exporting Data
  • Creating Queries
    • Creating a Select Query
    • Creating a Make Table Query
    • Creating an Append Query
    • Creating a Cross Tab Query
    • Showing and Removing Tables
  • Creating Forms and Reports
    • Creating a Form with the Form Wizard
    • Creating a Report with the Report Wizard
    • Modifying Form Layout
    • Navigating the Field List
    • Key Features on the Form Tools Tabs
    • Key Features on the Report Tools Tabs

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.



230 W Monroe St
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Peet's Coffee brewed every dayBook two levels of Access training and save $100FREE Class Repeat with each course Book 3 Level of Access Training and save $150