Access 2019 Advanced

Access 2019 Advanced


Take your existing skills with Microsoft’s primary information handling tool to their absolute peak and become an expert with this Access 2019 Advanced course. The 2019 version of Microsoft Access goes “end of life” in 2025 and will be supported until at least 2028, so there’s no excuse not to get the most from it. With this training, you will gain the full benefits from this versatile platform and ensure that you are acutely aware of every function and utility that it holds for your individual needs.           

This Microsoft Access tutorial provides the most progressive and complete techniques for completing your Access education and allows you to become a specialist in its use, whether needed for team contributions or business superiority. Your existing talents will be stretched to encompass new and exciting possibilities, making your data management abilities second to none. Everything you need to succeed from database contingency to high-level security and macro conversion is presented here for you in easily digestible online modules. Use Access for success and enrol now.     

What you'll learn


After completing this course's assessment, you will be eligible for:

OE Certificate@2x-100 (1) (1) (1)

The CPD QS Accredited Certificate Is Available In PDF Format, At The Cost Of £9, Or A Hard Copy Can Be Sent To You Via Post, At The Cost Of £15.​

Order Your Certificate here

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Access 2019 Advanced is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

Course Curriculum

Access 2019 Advanced
Module 1: Introduction to the course 00:01:00
Module 2: Using the table Analyzer Wizard 00:07:00
Module 3: Append Querying to Normalize a Table 00:06:00
Module 4: Creating a Junction Table 00:05:00
Module 5: Backing up a Database 00:02:00
Module 6: Using the Compact and Repair Database Tool 00:03:00
Module 7: Using the Object Dependencies Tool 00:02:00
Module 8: Using the Database Documenter Tool 00:02:00
Module 9: Using the Analyze Performance Tool 00:02:00
Module 10: Creating a Navigation Form 00:03:00
Module 11: Modifying a Navigation Form 00:03:00
Module 12: Setting the Startup Options 00:02:00
Module 13: Using the Database Splitter 00:03:00
Module 14: Configuring Trusted Locations 00:03:00
Module 15: Password Protecting a Database 00:03:00
Module 16: Password Protecting Modules 00:02:00
Module 17: Converting a Database to an ACCDE File 00:02:00
Module 18: Understanding VBA Basics 00:03:00
Module 19: Exploring Variables and Control Flow Statements 00:07:00
Module 20: Exploring a Table or Query with VBA 00:10:00
Module 21: Converting a Macro to VBA 00:03:00
Module 22: Understanding Table Events 00:02:00
Module 23: Using the Before Change Event Command 00:05:00
Module 24: Using the After Update Event Command 00:03:00
Module 25: Recap 00:01:00
Resource – Access 2019 Advanced 00:00:00
Final Exam
Final Exam – Access 2019 Advanced 00:20:00

COPYRIGHT © 2022 One Education

Home Search Cart
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon