Training Category
Training Method
Course Location

Access - Level 2 (2003/2007/2010/2013 & 2016)

SquareOne Training
Course summary
Length: 1 day
Price: 195 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: 28/02/2017 09:30 - Liverpool
Course Dates
28/02/2017 09:30  (English)
195 GBP
Please enquire for dates & details  (English)

Access - Level 2 (2003/2007/2010/2013 & 2016)

Microsoft Access Level 2 Training CourseAccess - Intermediate Level 2 (2003; 2007; 2010; 2013 & 2016) - 2 day course in Liverpool

This high-impact training programme is delivered over the course of 2 days and is designed to provide delegates with enhanced knowledge of Microsoft Access and its features. As this is a level 2 course, it is best suited to delegates with some experience using Microsoft Access.

Delegates will learn-by-doing to get to grips with the more advanced functions of Microsoft Access, including table design, relational concepts, select queries and reports.

Suitability - Who should attend?

This Access - Level 2 (2003; 2007; 2010; 2013 & 2016) course is suitable for existing users of Access who would like to develop their database skills.

Course Pre-Requisites

Delegates should have previous experience with Microsoft Access and basic knowledge within the package.

For more information on suitability, please send an enquiry here.

Training Course Content

This Access - Level 2 (2003; 2007; 2010; 2013 & 2016) course is designed to cover the following areas:

Advanced Table Design

  • Attachment fields
  • Multiple value fields
  • Lookup fields
  • Advanced field properties including Input Masks
  • Multiple field primary keys
  • Multiple field indexes
  • Using the Access Documenter

Relational Concepts

  • Relational concepts & rules
  • Data structure principles
  • Types of relationship
  • Referential integrity
  • Relating tables

Multiple Tables and Forms

  • Using a combo box in forms
  • Combo box properties
  • Lookup properties
  • Creating forms with subforms
  • Editing sub forms
  • Tabbed sub forms
  • Embedding sub forms using drag & drop

Advanced Select Queries

  • Filter by form
  • Advanced Filter/Sort
  • Convert filter to select query
  • Duplicate records query
  • Unmatched records query
  • Working with multiple tables
  • Understanding query join types
  • Concatenating fields
  • Calculations in queries
  • Using string functions
  • Using date functions
  • Using the immediate if function
  • Using wildcards & parameters

Advanced Reports

  • Working with multiple tables
  • Concatenating fields
  • Date & time functions
  • String functions
  • Custom styles



For information on pricing for this Access Level 2 public course, please send an enquiry here.

In-House Option

For teams, groups and companies, this course is also available on an in-house basis and can be customised to the specific needs of each organisation. For a custom training quote, please send an enquiry here.

Provider: SquareOne Training

SquareOne Training - In-House IT & Computer Training

We are an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. We specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support to...

Read more and show all courses with Provider: SquareOne Training

Request information - obligation free


Fill out your details to find out more about Access - Level 2 (2003/2007/2010/2013 & 2016).

  Contact the provider

  Get more information

  Register your interest


Contact information for SquareOne Training

SquareOne Training

2 Tower Road
CH41 1FN Birkenhead

 Show phone number

Contact SquareOne Training
Request Information

Find out more & get a FREE call back about this Access - Level 2 (2003/2007/2010/2013 & 2016) course - simply fill out your details:

There are no reviews available yet.
Case Study
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more