MOS Access 2019 and 365 Expert

Course code: DLC026

Impress employers with expert skills in using Microsoft Access 2019...

Boost your CV with vital Microsoft Access skills that employers look for
Expert knowledge and skills with the latest version of Microsoft Access
Industry recognised MOS certification
Valuable knowledge and skills needed for the MOS exam
Provides you with expert skills to show off to exmployers
Access to GMetrix range of MOS exam practice questions
Need to have a version of Microsoft Access 2019

Course Options	Please choose a course option to see prices	Course Material
Study Options	This course is only available to study online.
Payment Options	Pay Upfront Pay Monthly Pay Monthly is not available in your currency.

Request a call back

Microsoft Access is commonly used in workplaces that handle data. Ensure you stand out from other candidates or colleagues and impress employers with your expert skills in Microsoft Access 2019.

This course is perfect for those who use Microsoft Access regularly but perhaps want to understand how to use the programme in more depth and add to their skillset.

Understand how to manage databases. Learn how to create and modify queries and tables!

Become fully skilled in using Microsoft Access 2019 and choose to sit an exam to receive the full certification.

Study for this course online and study whenever, wherever you want.

Course Duration

Up to 1 year.

Study Hours

Approximately 80 hours.

Course Outcome

You will be ready for your MOS official exam.

Entry Requirements

You will need to have Microsoft Access 365 or 2019.

Assessment

Tutor marked assignments.

Unit 1

Managing Databases

Introduction
Modifying Database Structure
Managing Table Relationships & Keys
Printing and Exporting Data
Lesson Review and Quiz
Assignment 1 – Creating and Modifying Databases Exercises

Unit 2

Creating and Modifying Tables

Introduction
Creating Tables
Managing Tables
Managing Records In Tables
Creating & Modifying Fields
Lesson Review and Quiz
Assignment 2 – Database Table Exercises

Unit 3

Creating and Modifying Queries

Introduction
Creating and Running Queries
Modifying Queries
Creating Calculated Fields and Grouping
Lesson Review and Quiz
Assignment 3 – Query Exercises

Unit 4

Modifying Forms in Layout View

Introduction
Configuring Form Controls
Formatting Forms
Lesson Review and Quiz
Assignment 4 – Forms Exercises

Unit 5

Modifying Reports in Layout View

Introduction
Configuring Report Controls
Formatting Reports
Lesson Review and Quiz
Assignment 5 – Report Exercises
The MOS Examination

Course Requirements

You must have Microsoft Access 2019 to complete this course. The course covers the use of either Microsoft Access 2019 or 365 which is a pc version of the software.

It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office which differs slightly.

Course Duration

You will have up to 1 year to complete your course. The course study time should take approximately 80 hours, so 1 year will allow flexible learning. You can complete your course in as little or as much time as you like.

Study Method

Your course will be studied online, so you have access to your course materials through an online training portal. You will have access to your personal tutor support throughout your course through email, so help is available at any point.

GMetrix Skills Management System is also included in your course, which will allow you to practice for your exam effectively.

Overview of Test features:

Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
All tests have both a testing and a training mode providing step-by-step help on each question.
Progress at own pace, save test to resume later, return to skipped questions.
Detailed, printable score report highlighting areas requiring further review.

Assessment

Your assignments will involve you completing Access based assignments to present your understanding of the course. You will need to submit your assignments online to your tutor. These will be marked and returned to you.

This course prepares you for the official Microsoft Office Specialist (MOS) Word Expert MO-500 exam. If you want to take the exam to receive the full official qualification, you will need to book and pay for this separately. They must be sat at a registered Certiport Testing Centre.

Do I have to sit an exam?

If you want to receive the full official qualification, you will need to sit an exam. This will need to be booked and paid for separately by you. Examinations must be sat at a registered Certiport Testing Centre.

What is included in the cost of my course?

Dedicated personal tutor support
Dedicated student support
GMetrix Skills Management System
Assignment marking and feedback
FREE CV critique service
FREE employability guide to help you impress future employers
FREE XO Student Discounts card

Are there any additional costs?

If you want to sit the exam, this will need to be booked and paid for separately by you.

What if I still have questions?

That's not a problem. We want to make sure you’re 100% confident about enrolling on the course and starting your study. So, just give our Student Adviser Team a call on 03300 563 100 and they’ll do their best to help.