Microsoft Access

Microsoft Access Training

At a basic level, you can use Access to develop simple, personal database-management systems. Some people accululate everything from their wine collections to their home finances.

Companies use Access to develop Customer Databases, Asset Databases and many more. Access makes it easier to not only store information but also to create user forms to suit the user run queries on the stored data and run reports.

Good database design will make a difference for the end user and the amount of effort required in finding the necessary information.

With the help of our excellent trainers, you can learn how to design database that will suit your requirements. From small, one table database design to big databases with multiple tables linked together and automated actions created in Visual Basics, we will be happy to assist with all aspects of database creation.

Please select the version that you’re interested from below:

Please select the level that you’re interested in

Microsoft Access 2016 Advanced

Course Overview

Audience:

This course is designed for existing Access users who need to start automating database tasks or simplify complex database sequences.

Prerequisite:

You must have sound Access skills and understand key concepts of a database equivalent to our intermediate course contents.

Duration:

This is a 1 day MS Access Advanced course. The course starts at 09:30 and runs until 16:30.  Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Microsoft Access Advanced course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

Access 2016 Advanced Course Outline

MACROS

An Overview

Creating and Running Macros

Various Macro Actions

Applying Macros

NAMES MACROS

Using ^ + letter

Using ^ + Number

Function keys

CONDITIONAL MACROS

Msgbox

Set value

Using functions

EVENT PROCEDURES

On open/close

On got/lost focus

DATABASE UTILITIES

Compact and repair

Save as alternate formats

Split database

Package and distribute

Password protect

Application options (created database application)

Compile code

Make accde file

Backup database

Database Templates

CREATING A SWITCHBOARD
(USER INTERFACE)

Design a switchboard

Use Macros with Command Buttons

Use Macros with Code

Format switchboard forms

Create a Splash Screen

Use an autoexec Macro

Customise ribbon

Customise the Quick access toolbar

Start-up Menu

VBA

Convert macro’s to code

Sample subroutine

Sample function

Libraries

Navigate the VBA window

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.