Microsoft Access Intermediate Level

Course

Online

£ 425 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    3h

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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.

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.

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.

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 5 years

Subjects

  • Access
  • Database Design
  • Office IT
  • Database
  • Database training
  • Data analysis
  • Design
  • Ms Office
  • Microsoft Access
  • Microsoft Office

Course programme

COURSE CURRICULUM

Module 01
  • Relational Database Design
  • Create a Table
  • Create Table Relationships
Module 02
  • Create Query Joins
  • Relate Data Within a Table.avi
  • Work with Subdatasheets from
Module 03
  • Use Field Validation
  • Use Form and Record Validation
Module 04
  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
Module 05
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
Module 06
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report
Mock Exam
  • Mock Exam- Microsoft Access Intermediate Level
Final Exam
  • Final Exam- Microsoft Access Intermediate Level

Microsoft Access Intermediate Level

£ 425 VAT inc.