• LOGIN
  • No products in the cart.

Microsoft Access Intermediate Level

Microsoft Access Intermediate Level

489 STUDENTS ENROLLED

    Introduction

    Whether you work in data analysis, office administration or software development, Microsoft Access is an invaluable tool. Building on our beginner level qualification, the Microsoft Office 2016 Access Intermediate course builds on your existing knowledge of the database management software and explores developed skills in relational design, creating query joins, form and field validation processes and adding advanced functions to a form.

    Course description

    The Microsoft Office 2016 Access Intermediate is delivered through online video tutorials which break down each function of Access into accessible, easy-to-understand step-by-step instructions. You acquire knowledge and competencies than can be applied to a range of roles across a variety of careers and business, with enhanced data analysis and management abilities in demand throughout digital, IT, and more traditional sectors alike.

    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 Intermediate 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
    Relational Database Design 00:16:00
    Create a Table 00:09:00
    Create Table Relationships 00:09:00
    Module 02
    Create Query Joins 00:14:00
    Relate Data Within a Table.avi 00:04:00
    Work with Subdatasheets from 00:05:00
    Module 03
    Use Field Validation 00:16:00
    Use Form and Record Validation 00:14:00
    Module 04
    Create Parameter Queries 00:12:00
    Summarize Data 00:06:00
    Create Subqueries 00:07:00
    Create Action Queries 00:05:00
    Create Unmatched and Duplicate Queries 00:06:00
    Module 05
    Data Normalization 00:10:00
    Create a Junction Table 00:04:00
    Improve Table Structure 00:06:00
    Module 06
    Include Control Formatting in a Report 00:04:00
    Add a Calculated Field to a Report 00:05:00
    Add a Subreport to an Existing Report 00:07:00
    Mock Exam
    Mock Exam- Microsoft Access Intermediate Level 00:20:00
    Final Exam
    Final Exam- Microsoft Access Intermediate 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