Online
John Academy Level 3 Diploma in Microsoft Access John Academy
  • Duration / Course length: 34 Hours Start now
  • Accredited by: CiQCPD Qualification Standards
  • Certificates:
  • Course delivery: This course is delivered in video format

Course details

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 stores data in its format based on the Access Jet Database Engine. Through this course, you will learn from beginner, intermediate, and advanced level skills, knowledge, and information about Microsoft Access 2013. You will then know the different components of the database so that you understand the structure underlying your data to know data manipulation and user control.

COURSE CURRICULUM

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

Eligibility / Requirements

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.

About John Academy

John Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online course provider, we are aware of the fact that there are a lot of people out there who consider themselves to be very curious learners but the courses that they are interested in are not available at their convenient time and place. So, we have decided to give them a unique opportunity for them to learn and obtain necessary skills in a very convenient way at any time from anywhere.

Who We Are

We are an online course provider who wants to make sure that the students would be able to learn everything there is a need for them to learn regarding the course that they have enrolled in on our site. So, we see to it that they would be provided with the highest possible standard of online learning. That way, students would be able to use it in the real world – the employment world and at their desired field of interests.

Certification

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 hard copy 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.

570 students have enrolled with John Academy through Laimoon
See all John Academy courses

Rate this page

95% off through Laimoon! Get This Deal
USD 34
USD 720
Money Back Guarantee