Access 365 Intermediate

bLACK fRIDAY DEAL rELOADED! Get Lifetime Access to All Courses for Just £99. Claim Offer

Learning Outcome


Discover how to enhance and develop your existing skills with Microsoft’s primary information handling tool with this Access 365 Intermediate course. Access 365 continues to be one of the most reliable and effective ways to integrate data and link to other tools in the Office 365 suite. This informative training will ensure that your skills are updated and take full advantage of all the primary functions and utilities that Access can offer you and your workplace.           

This Microsoft Access 365 tutorial has been carefully crafted to offer valuable hints and tips for those that want to enhance and improve their use of it. It offers useful ways to manipulate data tables, information records, and specific fields to a much greater extent and level of intracity. This will allow you to be more creative with reports and statistics, providing valuable input and foundations for important business decisions. Get ready to take the next step to be an Access expert by enrolling now.    

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

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

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.

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 365 Intermediate 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

Module 1: Design Tables for Better Data Entry
Reviewing Table Design Principles 00:11:00
Setting Field Size, Formats, and Captions 00:11:00
Setting Default Values and Required Fields 00:05:00
Restricting Data Entry-Validation Rules 00:07:00
Restricting Data Entry-Input Masks 00:09:00
Module 2: Share Data with Other Apps
Exporting Tables and Queries to Excel 00:05:00
Exporting Data to a SharePoint List 00:02:00
Importing Data from Excel 00:06:00
Importing Data from a SharePoint List 00:02:00
Linking External Data Sources 00:05:00
Using Word Merge 00:06:00
Module 3: Work with Action Queries
What are Action Queries 00:04:00
Creating an Update Query 00:06:00
Creating an Append Query 00:04:00
Creating a Delete Query 00:04:00
Creating a Make Table Query 00:04:00
Changing Start Number of an Auto Number Field 00:04:00
Module 4: Advanced Query Techniques
Modifying Query Joins 00:06:00
Using Self Joins to Combine Data 00:06:00
Creating Find Unmatched and Find Duplicate Queries 00:09:00
Creating Parameter Queries 00:05:00
Creating a Top X Query 00:02:00
Reviewing Calculated Query Fields 00:06:00
Summarizing Query Data with Totals 00:04:00
Creating Crosstab Queries 00:06:00
Module 5: Automate Processes with Macros
Understanding Macro Basics 00:14:00
Creating Macros to Open Forms by Record 00:09:00
Validating Data Entry with Macros 00:10:00
Creating a Macro to Automate Data Entry 00:08:00
Advanced Data Entry Using Macros and DLOOKUP 00:11:00
Module 6: Advanced Form Techniques
Using Conditional Formatting 00:04:00
Working with the New Label Name Property 00:03:00
Organizing Form Fields with Tab Controls 00:09:00
Creating an Option Group Control 00:06:00
Creating a Combo Box Control 00:04:00
Configuring a Combo Box Control to Show Search Results 00:04:00
Using a Subform to Show Data From a Related Table 00:06:00
Module 7: Advanced Report Techniques
Inserting a Chart on a Report 00:07:00
Showing Data in Columns 00:07:00
Inserting a Subreport 00:05:00
Configuring Reports with Parameter Queries 00:03:00
Sending Reports 00:03:00
Resource – Access 365 Intermediate 00:00:00
Final Exam
Final Exam – Access 365 Intermediate 00:20:00

COPYRIGHT © 2022 One Education

Home Search Cart
    Your Cart
    Your cart is emptyBrowse Courses
    Deal Of The Day
      Apply Coupon