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.
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
Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.
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.
|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 – Access 2019 Advanced||00:20:00|