Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. It can also import or link directly to data stored in other applications and databases. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2013 for the beginner, intermediate, and advanced-level users. Then you learn the different components of the database so that you understand the structure underlying your data.

Who is the course for?

  • Professionals who want to learn about the Microsoft Access 2013
  • People who have an interest in learning all the features of the Access 2013

Entry Requirement:

  • This course is available to all learners, of all academic backgrounds.
  • Learners should be aged 16 or over to undertake the qualification.
  • Good understanding of English language, numeracy and ICT are required to attend this course.


  • At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.
  • Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.


  • After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24.
  • PDF certificate’s turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.

Why choose us?

  • Affordable, engaging & high-quality e-learning study materials;
  • Tutorial videos/materials from the industry leading experts;
  • Study in a user-friendly, advanced online learning platform;
  • Efficient exam systems for the assessment and instant result;
  • The UK & internationally recognised accredited qualification;
  • Access to course content on mobile, tablet or desktop from anywhere anytime;
  • The benefit of applying for NUS Extra Discount Card;
  • 24/7 student support via email.

Career Path:

The Microsoft Access for Beginners, Intermediate and Advanced course is a useful qualification to possess and would be beneficial for following careers:

  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester.

Course Curriculum

Microsoft Access for Beginners
Module One – Getting Started 00:30:00
Module Two – Opening and Closing Access 01:00:00
Module Three – An Introduction to Databases 01:00:00
Module Four – Sharing Data Using Apps 01:00:00
Module Five – Working in Your App 01:00:00
Module Six – An Introduction to Desktop Databases 01:00:00
Module Seven – Performing Basic Table Tasks 01:00:00
Module Eight – Working with Fields 01:00:00
Module Nine – Working with Table Relationships 01:00:00
Module Ten – An Introduction to Queries, Forms, and Reports 01:00:00
Module Eleven – Protecting Your Data 01:00:00
Module Twelve – Wrapping Up 00:30:00
Activities – Microsoft Access for Beginners 00:00:00
Microsoft Access for intermediate level
Module One – Getting Started 00:30:00
Module Two – Creating a Custom App 01:00:00
Module Three – Customizing App Actions 01:00:00
Module Four – Customizing Your App Views with Macros 01:00:00
Module Five – Working with Validation Rules and Messages 01:00:00
Module Six – Working with Macros 01:00:00
Module Seven – Advanced Query Tasks 01:00:00
Module Eight – Designing Forms 01:00:00
Module Nine – Advanced Reporting Tasks 01:00:00
Module Ten – Advanced Database Tools 01:00:00
Module Eleven – Working with the Access Environment 01:00:00
Module Twelve – Wrapping Up 00:30:00
Activities – Microsoft Access Intermediate Level 00:00:00
Microsoft Access Advanced Level
Module One – Getting Started 00:30:00
Module Two – Using App Views 01:00:00
Module Three – Customizing Apps, Part One 01:00:00
Module Four – Customizing Apps, Part Two 01:00:00
Module Five – Working with More Record Tasks 01:00:00
Module Six – Using Advanced Field Tasks 01:00:00
Module Seven – Working in Table Design View 01:00:00
Module Eight – Working with the Expression Builder 01:00:00
Module Nine – Working with External Data 01:00:00
Module Ten – Creating Queries 01:00:00
Module Eleven – Creating Forms and Reports 01:00:00
Module Twelve – Wrapping Up 00:30:00
Activities – Microsoft Access Advanced Level 00:00:00
Mock Exam
Mock Exam- Microsoft Access – Beginners, Intermediate, Advanced 00:30:00
Final Exam
Final Exam- Microsoft Access – Beginners, Intermediate, Advanced 00:30:00

Course Reviews


6 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.



certificate mockup


John Academy - Accrediting Body 2

John Academy - Accrediting Body


John Academy - Awarding Body

Registered with the UK Register of Learning Providers (UKRLP)
UKPRN: 10063816


John Academy - Course Partners




We are a company who is best known for offering awarding body accredited courses for anyone who wishes to take their professional life to the next level.

 2nd Floor, 16-18 Whitechapel Rd, London E1 1EW, United Kingdom.
020 3744 3990

Certificate Code

Coming Soon


© Adams Academy Inc. Ltd. T/A John Academy.