Microsoft Access Level 3

Insight IT Training
Course summary
1 day
Next available date: You choose the date that best suits you. - United Kingdom
Last application: Request information or Contact us for a quote & discounts.
Corporate Training for Teams

Microsoft Access Level 3

Delivered by highly knowledgeable trainers with extensive product knowledge, this Microsoft Access Level 3 course provides your database administrators with the advanced skills in using the Access software for effective database management.

The private programme is typically delivered on-site over the course of one day, and includes a large number of practical exercises that enable delegates to practise the skills covered. Using your company PCs or Insight's own high specification equipment, the training covers a range of Access' more complex features, including:

  • Advanced form design
  • Using macros
  • Securing a database
  • Managing switchboards

The hands-on nature of the course ensures that delegates develop a high degree of confidence in using the complex techniques covered. Though the standard course has a set outline, organisations can choose to further customise the content in order to meet a specific need.

Insight IT Training can arrange for the training to cover any version of the Microsoft Access software.

Suitability - Who should attend?

This course is suitable for current and prospective database administrators looking to develop advanced skills in Microsoft Access.

In order to draw the most benefit from the course, Insight IT Training recommends that users attend the Microsoft Access Level 1 and Level 2 courses prior to attempting the Level 3.

Outcome / Qualification etc.

Each trainee will receive a Certificate of Attendance.

Training Course Content

Standard course content includes:

Implementing Advanced Form Design

  • Add Controls to Forms
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation of Forms
  • Apply Conditional Formatting

Using Data Validation

  • Field and Record Validation
  • Form Validation

Using Macros to Improve User Interface Design

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

Using Advanced Database Management

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Distributing and Securing a Database

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

Levels of Study

Insight IT Training delivers standard Access courses at Levels 1, 2 and 3. These programmes can also be tailored - in content, format and duration - to meet your exact needs.


Our prices are all inclusive and the same for any;location in the UK. Prices options are available for training 1 or 2 people and a group of between 3 to 6 people.

Be Inspired! Watch the Video

Insight IT Training

Insight IT Training

Provider: Insight IT Training

Insight IT Training - Customised IT and Business Skills Training

Insight IT Training - Customised IT and Business Skills Training, Tailored to Your Company

A family-run business established in 1998, Insight IT Training is a specialised provider of customised IT, Programming and Business Skills courses for companies across the UK. As an exclusive provider of private (in-company) solutions, Insight IT Training are dedicated to...

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Microsoft Access Level 3.

  Contact the provider

  Get more information

  Register your interest

Contact information for Insight IT Training

Insight IT Training

Heath Farm, Wythall
b47 6aj Birmingham Worcestershire

 Show phone number

Reviews by course attendees

Average rating 5

Based on 1 reviews

It is a fantastic course cutomised to each individual from which everyone can benefit from.
Request information

Find out more about this Microsoft Access Level 3 course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here