Chat with us, powered by LiveChat
  • LOGIN
  • No products in the cart.

Microsoft Access Advanced Level

Microsoft Access Advanced Level

2 STUDENTS ENROLLED

Introduction

Learn how to safely and securing import, export and manage your data with this comprehensive online qualification. Microsoft Office 2016 Access Advanced course is the final stage of our Access training, covering expertise in database management needed for more senior digital analysis and office administration roles. You learn through video tutorials which explain each function in an accessible, user-friendly manner, augmented by PDF handouts, mock exams, and online multiple-choice assessments.

Course description

The Microsoft Office 2016 Access Advanced – Complete Video Course builds on our beginners and intermediate qualifications to walk you through the more advanced functionality of Microsoft Access. This includes applying conditional formatting to your database, validating data entry and automating functions using macros, splitting a database for multiple user access, and efficiently managing a database switchboard.

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
  • Mock exams
  • Multiple-choice assessment

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

While I receive a certificate of completion?

Upon successful completion you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Microsoft Access Advanced Level is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

 

Course Curriculum

Module 01
Add Controls to Forms 00:11:00
Enhance Navigation and Organization of Forms 00:14:00
Apply Conditional Formatting 00:04:00
Module 02
Import Data into Access 00:08:00
Export Access Data 00:06:00
Link Tables to External Data Sources 00:05:00
Create a Mail Merge 00:02:00
Module 03
Create a Macro 00:08:00
Restrict Records by Using a Condition 00:04:00
Validate Data by Using a Macro 00:05:00
Automate Data Entry by Using a Macro 00:04:00
Module 04
Manage a Database 00:08:00
Determine Object Dependency 00:04:00
Module 05
Manage a Database 00:07:00
Determine Object Dependency 00:04:00
Document a Database 00:04:00
Module 06
Splitting a Database for Multiple User Access 00:05:00
Implement Security 00:03:00
Convert an Access Database to an ACCDE File 00:04:00
Package a Database with a Digital Signature 00:01:00
Module 07
Create a Database Switchboard 00:05:00
Modify a Database Switchboard 00:02:00
Set Start up Options 00:04:00
Mock Exam
Mock Exam- Microsoft Access Advanced Level 00:20:00
Final Exam
Final Exam- Microsoft Access Advanced Level 00:20:00

Course Reviews

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

COPYRIGHT © 2018 One Education