Welcome to Insight

A Business to Business training specialist
Delivering Business Skills and IT training nationwide

At your Convenience
We come to you or
you come to us
Wherever you are!

Flexibility
Build your own tailored course
Lots of options available

Good Value
Your company saves money
and your staff save time

What's New?
Remote Classroom Training...
...coming shortly!

It's Your Training!
When and Where
You want it

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.