Discover how to reach the next level of data management when you elevate your knowledge of Microsoft’s primary information handling tool with this Access 365 Advanced course. The most current version of Microsoft Access is an integral part of the company’s Office suite and allows for improved links and shared functions between each app. Using this training, you will learn how to gain the full benefits from this reliable and adaptable platform, empowering you to produce more advanced reports and calculations for business and personal use.
This Microsoft Access 365 tutorial is the most progressive and complete way to ensure that you are fully aware of all of the functions and techniques that are available to you for data management and associated tasks. You will impress others as to the professional methods and outcomes you can utilise in your work, making you the “go-to” person for using this tool and the functionality it holds. Everything you need to know about database maintenance, database configuration, and automating processes is presented here for you, all available in easy-to-follow online modules. Be the best with Access 365 by enrolling 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 365 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.
|Module 1: Improving the Structure of a Database|
|Using the Table Analyzer Wizard||00:09:00|
|Append Querying to Normalize a Table||00:10:00|
|Creating a Junction Table||00:06:00|
|Module 2: Maintaining a Database|
|Backup Up a Database||00:03:00|
|Using the Compact and Repair Database Tool||00:03:00|
|Using the Object Dependencies Tool||00:03:00|
|Using the Database Documenter Tool||00:02:00|
|Using the Analyze Performance Tool||00:02:00|
|Module 3: Working with Navigation Forms and Startup Options|
|Creating a Navigation Form||00:03:00|
|Modifying a Navigation Form||00:05:00|
|Setting the Startup Options||00:03:00|
|Module 4: Configuring Access for Multiple Users|
|Using the Database Splitter||00:04:00|
|Configuring Trusted Locations||00:03:00|
|Password Protecting a Database||00:04:00|
|Password Protecting Modules||00:02:00|
|Converting a Database to an ACCDE File||00:02:00|
|Module 5: Automating Processes with VBA|
|Understanding VBA Basics||00:03:00|
|Exploring Variables and Control Flow Statements||00:10:00|
|Exporting a Table or Query with VBA||00:09:00|
|Converting a Macro to VBA||00:02:00|
|Module 6: Using Table Events|
|Understanding Table Events||00:02:00|
|Using the Before Change Event Command||00:07:00|
|Using the After Update Event Command||00:04:00|
|Resource – Access 365 Advanced||00:00:00|
|Final Exam – Access 365 Advanced||00:20:00|