Computer Tutoring Logo
Est. 2002
Menu Button

Live Online Prices

1-8 Students

£250 + VAT - 3hrs (bespoke)

£500 + VAT - 6hrs (full day*)

* Full training days can be split into 2 sessions

Classroom Course Calculator

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Testimonials

Pepsico

"Only a small group so really great training interaction. Well prepared and friendly, made what could of been a slightly dull topic enjoyable."

"Very good. I have never used Access before but feel confident that I will be able to set up and manage databases going forward."

British Antarctic Survey

"Our bespoke training was really good and invaluable. We learnt a great deal about Microsoft Access and databasing techniques. Both aspects are so important to our work. Simon, our trainer, was a real expert and he made the two days interesting and enjoyable. Thank you so much"

Microsoft Access 2019 Training Course Advanced

Microsoft Access 2019 Overview

This course will ensure you're familiar with the more advanced aspects of Microsoft Access. Features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access will be learnt.you will manage an Access 2019 database and add complex database features to improve its usability, efficiency, performance, and security

This course would also be suitable for those using Access 365.

As part of the course you will:

  • Share data across applications
  • Use action, unmatched, and duplicate queries to manage data
  • Create complex reports and forms
  • Use macros to improve user interface design
  • Use VBA to extend database capabilities
  • Perform tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting
  • Implement security strategies and distribute a database to multiple users
  • Course Duration: 1 Day

    Course Prerequisites:

    To get the most out of this course, please ensure that you have Microsoft Access Beginners and Microsoft Access Intermediate equivalent knowledge or have previously taken these courses. This includes a working knowledge of database design and creation, report design and creation and a working knowledge of database querying and the various table relationships

    Course Outline

    Importing and Exporting Table Data in Microsoft Access 2019

    • Import and Link Data
    • Export Data
    • Create a Mail Merge

    Using Queries to Manage Data

    • Create Action Queries
    • Create Unmatched and Duplicate Queries

    Creating Complex Reports and Forms

    • Create Subreports
    • Create a Navigation Form
    • Show Details in Subforms and Popup Forms

    Creating Access Macros

    • Create a Standalone Macro to Automate Repetitive Tasks
    • Create a Macro to Program a User Interface Component
    • Restrict Records by Using a Condition
    • Create a Data Macro

    Using VBA to Extend Database Capabilities

    • Getting Started with VBA
    • Using VBA with Form Controls

    Managing a Database

    • Back Up a Database
    • Manage Performance Issues
    • Document a Database

    Distributing and Securing a Database

    • Split a Database for Multiple-User Access
    • Implement Security
    • Convert an Access Database to an ACCDE File
    • Package a Database with a Digital Signature

    Live Online Instructor Led Training

    1 - 8 Students

    £250 + VAT - 3hrs (bespoke)

    £500 + VAT - 6hrs (full day*)

    * Full training days can be split into 2 sessions


    Classroom based Advanced Access Prices from:

    If you are interested in this classroom based course but want to know the price beforehand then use the the following form to calculate how much.

    Number Students?
    Laptop hire?
    Offsite training?

    Per Person £ *
    Total Price:
    £ .

    Duration:
    1 Day

    * Price is exclusive of VAT.

    If you are interested in this course fill out the following form for further details:

    Live Online Classroom
    First Name:

    Last Name:

    Email:

    Tel:

    Location:

    No. Students:

    First NumberPlusSecond Number  = 
    Please enter the answer to prove that you are human and not a machine.

    I would like to receive training special offer emails
    I would like to be notified about free software hints and tips



    Each student will receive:

    • Comprehensive training notes coupled with exercise files they can use at their leisure
    • Access to online training materials including Video Tutorials and Keyboard shortcuts
    • 3 months of post training support which includes email, phone and screen sharing assistance


    Microsoft Access 2019 Training Course Advanced