Welcome to Insight

Delivering private IT training for businesses,
public sector and voluntary organisations

We deliver our training
Onsite & Offsite

We Provide
A Wide Range
of Business Skills courses

We Can Help You
Build Your Own
Tailored Courses

The Training You Want
When & Where
You Want It

Keep an Eye on
Our Special Offers
Updated Regularly

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Microsoft Access Level 3

< Back to Microsoft and Office Courses | Insight IT Training

Course Details

Access

Course Duration – One day

Benefits of Microsoft Access Level 3 Course

Those taking Microsoft Access Level 3 are database administrators or prospective database administrators who have experience working with Access and need to learn advanced skills.

This one day instructor-led course provides students with an overview of the more complex features and functions of Microsoft Access. During this Level 3 course, participants will learn the more complex techniques such as advanced form design, using macros and advanced database management. This course also covers securing a database and managing switchboards. For more information, please read our course content below.

Insight IT specialise in on-site training and can come to you to run our Level 3 course either on your PC's or using our own high specification equipment. If you want specific training for your staff, we would be glad to customise this course to your needs, adding or removing topics as necessary. Our trainers are extremely knowledgeable with the Microsoft Office suite of products with many years of experience.

You will get the most out of the Microsoft Level 3 course if you have attended Microsoft Access Level 1 and 2.

Course Content

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

Prerequisites

Microsoft Access Levels 1 & 2

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 08452 306 099 or contact us online here.