This Safer Recruitment online training course is designed for those who are responsible for hiring people who work with children. Safer recruitment training online will teach you what is meant by safer recruitment and the practices involved, which legislation underpins safer recruitment, as well as cases where safer recruitment practices could have prevented abuse, how to assess the suitability of candidates, the 6 NHS employment check standards and their process.

Course Overview

Format

• Intermediate
• 2 Study Hours
• Online Study

Accreditation

• 5 CPD Points
• CPD Certified

Course description

Safer recruitment is designed to help those who are responsible for hiring anyone who works with children, to identify and deter or reject individuals who are deemed to be at risk of abusing children. 

It’s crucial that all employers have a recruitment policy in place that takes into account safer recruitment best practices and considerations. This course covers key topics including: advertising, application forms, selecting candidates for interview based on the information they have presented, and post-interview checks before making an offer of employment.

This Safer Recruitment course has been updated to be compliant with new Keeping Children Safe in Education 2022 legislation and how this applies in the workplace or when working with children and young people.

Recruitment of staff is now a complex process and there are many issues that need to be considered to ensure safe and successful recruitment, to reduce in turn the risk of harm, abuse and neglect of adults and children.  

What’s covered in this Safer Recruitment course?

Our online Safer Recruitment training course is broken down into the following sections and can be completed at your own pace, the course includes:

Module	What it includes
Introduction	An introduction to the course structure, learning outcomes and who the course is for.
What is the Safer Recruitment Framework?	This module will enable you to recognise legislation and other practices associated with safer recruitment, allowing you to make safer recruitment decisions. You will be able to identify legislation that underpins safer recruitment and understand the guidance that leads to safer recruitment procedures.
What is Safer Recruitment?	This section outlines what safer recruitment is and why it’s so important to get right. Following this section, you’ll understand safer recruitment and the practices involved and explain how it supports effective safeguarding practice.
Safer Recruitment: Best Practice	We provide essential knowledge on how to implement safer recruitment practices. You’ll be able to assess the suitability of a candidate and outline the treatment of ex-offenders when working with individuals at risk. We also go through communicating with candidates, applications and references.
NHS Safer Recruitment	This module take you through the NHS process verifying that a candidate meets the preconditions of the role they are applying for. We explain what pre-employment checks are and who they apply to, as well as identify cases where safer recruitment process could have prevented, or limited, the abuse of patients.

This course includes case examples, and challenges to help professionals check their knowledge and apply it into everyday working life. This course is suitable for people working in roles in HR and those involved in recruitment of staff.  

Having a greater understanding of safer recruitment best practices are crucial for anyone who work in an environment where children and young people or vulnerable adults are present. It is very important that extra care is taken to ensure people are safe to work in such environment when recruiting or managing new members of staff. Safer recruitment is design for the safeguarding children and young people – also ensure that the staff follow a clear code of conduct and mitigate inappropriate behaviours in new staff members.

Our Safer Recruitment Training online course is applicable to the following places of work:

• Academies
• Care homes
• Children’s homes
• Free schools
• Higher education establishments such as colleges and universities
• Hospitals
• Independent schools
• Law firms
• Nurseries
• Primary schools
• Pupil referral units
• Secondary schools
• SEN schools
• Sports clubs

Test and certificate

At the end of the course there will be a multiple-choice quiz testing your knowledge of the topic. Following the successful completion of the course you will receive a digital certificate, which you can download or print. We recommend that you keep these for your records.

Accreditation

The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines.

Duration

Approximately 2 hours. The length of time taken depends entirely on how quickly you can study and absorb the material. The course is self-paced, you do not have to complete all the training in one session. Your progress will be recorded throughout.

Target Audience

This course is suitable for anybody involved in the recruitment of people who will work with children, young people or vulnerable adults.

It is recommended that those who work with children on a regular basis complete either Level 2 Safeguarding Children or Level 3 Safeguarding Children training.

Entry Requirements

There are no specific entry requirements for this course.

You will learn

• Outline what is meant by safer recruitment and the practices involved
• Explain how safer recruitment supports effective safeguarding practice, define pre-employment checks (PEC) and who they apply to
• Identify legislation that underpins safer recruitment, and cases where a safe recruitment process could have prevented abuse
• Understand how to assess the suitability of candidates
• Outline the treatment of ex-offenders when working with individuals at risk
• Know the six NHS employment check standards and their processes
• Understand the guidance the leads to safer recruitment procedures

Who is it for?

Roles including:

• Teachers
• Teaching Assistants
• Nurses
• Council Workers
• Social Workers
• Nursery Staff
• Volunteers
• Head Teachers
• HR Staff
• Governing Bodies
• Governors
• Full Time Staff
• Agency Workers
• Part Time Staff

Safeguarding Level 3 for Children is one of our most in depth courses and is designed for managers/practitioners who frequently come into contact with children and their families. This online course outlines the core responsibilities of lead workers as well as why safeguarding is important, serious case reviews, key terms, reducing the likelihood of abuse, signs and symptoms of abuse, what to do if you suspect abuse, and the importance of whistleblowing.

Course Overview

Format

• Level 3
• 2-3 Study Hours
• Online Study

Accreditation

• 3 CPD Points
• CPD Certified

Course description

Anyone who requires Level 3 Safeguarding Training has a considerable responsibility for safeguarding children and they have to be able to act accordingly to information and concerns brought to them.

Anyone working at this level needs to be confident in working with multiple agencies and advise on local and national policies.

We also offer Safeguarding Children Training at Level 2

This Safeguarding Children Level 3 course has been updated to be compliant with new Keeping Children Safe in Education 2022 legislation and how this applies in the workplace or when working with children and young people.

Level 3 training is suitable for anyone who holds a management position and frequently works with children, or anyone who has a designated child protection role. These positions could be in schools, hospitals, sports clubs where safeguarding level 3 training is particularly useful and beneficial. 

What does this Level 3 Safeguarding Children training course cover?

The aim of this level 3 safeguarding training is to develop an understanding of safeguarding children, making sure you have up-to-date knowledge of safeguarding policies, legislation and guidance, and how you can reduce the risk of abuse. 

Module	What it includes
The Key Principles of Safeguarding	Children’s Safeguarding is underpinned by 4 key principles that we delve into to give you the best understanding and awareness.
What is Abuse?	You will learn about the different categories of abuse, what abuse actually is and how it can be recognised. This will help make you aware of the indicators of abuse to look out for.
Safeguarding Legislation	This section explores the different legislation in place in which the welfare of the child is paramount. We look at The Children Act 1989, The Children and Social Work Act 2017 as well as The UN Convention on the Rights of the Child and more.
What is Professional Curiosity?	You’ll learn what professional curiosity, disguised compliance and culturally competent curiosity mean and how it can help. We also look at the barriers faced.
Barriers to Reporting Abuse	We explain the barriers you may face when raising concerns and how to respond to a child’s disclosure of abuse including the interpersonal skills that help, questioning techniques, confidentiality and consent and what to do if consent is refused.
Referrals and Concerns: The Process	This section shows you the sequence of referrals. We explain the importance of taking your concerns seriously. We also explore what happens next after a referral is made. We also look at effective record keeping.
Writing Court Reports and Giving Evidence	As this is a very serious task for any social worker, we give you the tools you need to write the most effective court reports. We also explore each stage of care proceedings and the outcomes as well as preparing for and giving evidence in court.
Risk Assessments and Case Studies	We explain the importance of risk assessments and provide case studies for you to read, now that you have further understanding of the processes. We show you how to evaluate risks and agree safety measures.

Why take this Level 3 Safeguarding course?

Level 3 safeguarding children training is one of our most in depth safeguarding courses available and has been designed for managers/practitioners working in roles where they frequently come into contact with children and their families. This safeguarding training level 3 course contains core safeguarding modules to ensure that learners are up to date with the latest information and then goes onto more detailed information about reporting suspecting abuse whether it has been reported directly to them or via a member of staff.

The depth of this safeguarding level 3 course allows learners to understand how key safeguarding cases have shaped legislation and how that will impact on them as managers/practitioners and their workplace.

This safeguarding level 3 course covers key topics to ensure learners have a strong grasp on current safeguarding knowledge and key procedures. 

To help professionals apply knowledge into everyday life, this safeguarding children level 3 course uses immersive real-world scenarios which can help learners to better understand the importance of certain topics. On completion of this safeguarding training level 3 course learners will be able to: 

• Apply the changes to practice made over the past three years to your work 
• Identify different levels of harm and follow the appropriate safeguarding procedures 
• Collect safeguarding children information from both a local and national context 

Our Safeguarding Children Level 3 training is underpinned by the principles of:

• Working together to safeguard children
• Keeping children safe in education

You will learn

• Explain the profound impact some well-known cases of child abuse have had on legislation
• Explain the importance of multi-agency cooperation
• Define safeguarding in respect of children and young people
• Describe what you need to do if a child makes a disclosure or if you suspect abuse
• Explain what whistleblowing is, what it is not, and why it is important
• List the ways you can reduce the risk of abuse
• List the signs and symptoms of the different kinds of abuse
• Outline the responsibilities lead workers in the children’s and young person’s sector have

Who is it for?

Roles including:

• Teachers
• Childminders
• Doctors
• Nurses
• Social workers
• Sports teacher/coaches
• Care workers
• Police
• Paramedics
• Council workers
• Practitioners

Safeguarding Children Level 2 introduces key areas of safeguarding and is suitable for a range of roles including; administrators, teaching assistants, and early years practitioners. This course will ensure you have up-to-date knowledge of safeguarding policies, legislation and guidance, and includes ways you can reduce the risk of abuse, the signs and symptoms of different types of abuse, and the impact well-known child abuse and neglect cases have had on legislation.

Course Overview

Format

• Level 2
• 1-2 Study Hours
• Online Study

Accreditation

• 3 CPD Points
• CPD Certified

Course description

This Level 2 Safeguarding Children introduces safeguarding as a topic and covers key safeguarding areas such as, safeguarding jargon, working in a multi-agency approach and best practice.

This level 2 course will give learners the knowledge they need to be able to identify the signs and symptoms of abuse and what they need to do if they suspect a child is being abused or discloses sensitive information to them.

We also offer Safeguarding Children Training at Level 3

This Safeguarding Children Level 2 course has been updated to be compliant with new Keeping Children Safe in Education 2022 legislation and how this applies in the workplace or when working with children and young people.

It is a statutory requirement for anyone who works with children to have up-to-date knowledge of safeguarding policies, legislation and guidance so they can proactively focus on keeping them safe from harm and maintain the ability to act on any concerns about the safety and welfare of children and young people.

Why take this Level 2 Safeguarding Children course

If you are someone who regularly comes into contact with children in your work and needs to reach a more advanced level of safeguarding knowledge, then our safeguarding level 2 course has been designed for you.

Our Level 2 safeguarding children training gives you a deeper understanding of safeguarding issues and how to effectively report them when abuse is suspected.

To help you apply your knowledge in everyday life, we have used real-world scenarios. These scenarios and the supporting case studies will enable you to see how your training can apply to you in your role. A key aim of this level 2 safeguarding training is to provide you with strong context to the training so they can easily relate to the situations presented to you within the training.

On completion of this level 2 safeguarding training course you will be able to:

• Apply the changes to practice made over the past three years to your work
• Identify different levels of harm and follow the appropriate safeguarding procedures
• Collect safeguarding children information from both a local and national context

Safeguarding Children Level 2 is underpinned by the principles of:

• Working together to safeguard children
• Keeping children safe in education

What does this Safeguarding Children training course cover?

The aim of this level 2 safeguarding training is to develop an understanding of safeguarding children, making sure you have up-to-date knowledge of safeguarding policies, legislation and guidance, and how you can reduce the risk of abuse. 

Module	What it includes
Understanding Safeguarding	We look into the definitions of Safeguarding and why children must be protected from abuse.
What is Abuse?	You will learn about the different categories of abuse, what abuse actually is and how it can be recognised. This will help make you aware of the indicators of abuse to look out for.
The Impact of Abuse	This section delves into the impact abuse can have on chilren, be it physical harm, emotional ramifications like attachment issues or mental health difficulties such as anxiety and depression.
Early Help	You’ll learn what early help means, who needs it, and how schools can get involved. We explore the different types of early help so you’ll be able to identify who needs it and when.
Children in Need	This section explores the many different examples of children in need and the legislations involved. We also look onto the categories of families who are at the highest risk of significant harm.
Social Services	You’ll learn about the role and responsibilities of social services. We also explore multi-agency working and duty to share information.
Reporting Abuse	We explain how vital it is to recognise and understand your professional responsibility to protect those who need to be protected. We show you what do if a child discloses information.
Referrals and Concerns: The Process	This section shows you the sequence of referrals. We explain the importance of taking your concerns seriously. We also explore who is classed as an adult and what adult safeguarding is.
Multi-Agency Working	You’ll learn what multi-agency working is, and why it is so important. We look at the functions of agencies in multi-agency working and who could be involved.
Case Studies	We provide case studies for you to read, now that you have further understanding of the processes and aftermath of abuse in children. We also provide you with helpful resources and information on organisations that can help with further learning.

Who should take this course

This Safeguarding Children Level 2 online course is suitable for a range of roles which includes frequent or regularly work with vulnerable children. Some of these roles may include administrators and reception staff, teaching assistants, nursery staff, early years practitioners and safeguarding teams.

Accreditation

The content of this safeguarding children level 2 course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines.

Duration

The safeguarding children level 2 course should take approximately 1-2 hours to complete. The length of time taken depends entirely on how quickly you can study and absorb the material. You can proceed as quickly or slowly as you like, and there is no limit on how long you can take to do the level 2 safeguarding course.

Entry requirements

There are no specific entry requirements for this level 2 safeguarding course.

Test and certificate

The end of safeguarding level 2 training course test consists of 15 multiple choice questions. Learners are required to achieve a 75% pass mark, and, if necessary, may attempt the safeguarding level 2 training test six times at no extra cost.

If learners do not achieve the 75% pass mark, further attempts may be given by contacting our support team.

Learners will be able to download a safeguarding level 2 course digital certificate on completion. This can be printed, and we suggest you keep it for your records.

You will learn

• Recognise why safeguarding is important
• Recognise the signs and symptoms of abuse
• Know what to do if a child discloses information
• Know how to help children who you suspect are subject to abuse
• Recognise and report unsafe practices
• Understand what is meant by multi-agency working
• Key legislation underpinning multi-agency working
• Understand why multi-agency working is important
• Understand the roles in multi-agency working

Who is it for?

Roles including:

• Level 2 advanced safeguarding children training is suitable for anyone who frequently works with children and needs a more in-depth knowledge of safeguarding legislation and procedure
• Teachers
• Teaching Assistants
• Childminders
• Daycare Assistants
• Doctors
• Nurses
• Care Workers
• Health and Social Care Suppport Workers
• GP Reception or Practice Managers
• Housing Officers
• School Governors
• Trustees
• Advocacy Workers
• Community Safety Officers
• Non-Clinical Staff

Microsoft Excel 2016 – Set of 3 Interactive Courses

Microsoft Office 2016 – Library of 16 Interactive Courses

Microsoft Office 2016 – Library of 12 Interactive Courses

Microsoft Outlook 2013: Advanced

Microsoft Word 2013: Intermediate

Microsoft Outlook 2013: Intermediate

Microsoft Access 2013: Introduction

Microsoft Office 2016 – Library of 15 Interactive Courses

Microsoft Access 2016 – Set of 3 Interactive Courses

Microsoft Excel 2016: Advanced

Microsoft Word 2013: Introduction

Microsoft Word 2016: Advanced

Course Overview

Format

• Advanced
• 7-8 Study Hours
• Online Study

Accreditation

• Online Interactive Course
• Bathe Qualifications Endorsed

Course description

This online course has been made for those who have previous experience using Microsoft Word 2016 but are looking to take their skills onto the next level, the course covers many of the advanced features in the program which will help you in the workplace or for self-development.

The course Microsoft Word 2016: Advanced focuses on the tools used mainly for editing longer documents or for automating the work in the program.

You will learn to split documents into sections, especially in order to insert various headers and footers into different pages. and will also learn to insert a title page and set a watermark. You will learn to create a table of contents based on the document headings, to number inserted pictures and other objects and to create also their automatic list.

You will further learn to use fields, hyperlinks and cross-references, footnotes and endnotes. You will also familiarise yourself with the tools used when multiple users work with the same document, such as making notes, tracking performed changes or creating subdocuments.

You will learn

• Document sections
• Setting a page background
• Inserting symbols and drop caps
• Custom cover page
• Auto Text
• Document pagination
• Searching in a document
• Replacing text
• Hyphenation
• Tracking changes
• Working with comments
• Advanced setting of headers and footers
• Splitting text into columns

Who is it for?

Roles including:

• Office computer user
• Those wanting to develop Microsoft Word skills and knowledge
• Job Seekers
• Those working with computers
• Those using Microsoft Word at work, home or in education

Course Overview

Format

• Introductory Course
• 16-17 Study Hours
• Online Study

Accreditation

• Online Interactive Course
• Bathe Qualifications Endorsed

Course description

Learn the basics of Microsoft Word 2013 with our online course, designed for those who have little or no experience of the program.

In the course Microsoft Word 2013: Introduction, you will familiarise yourself with the program interface and the navigation in it.You will learn how to enter basic text properly and how to check spelling and grammar in it, andwill examine the options of formatting text and the whole paragraphs.You will get to know the basic settings before printing a document, including page setup and inserting headers and footers into the document pages.

You will learn

• Introduction to Word
• Viewing documents
• Read Mode
• Creating a new document
• Opening documents
• Navigation in a document
• Entering and editing text
• Text selection techniques
• Moving and copying text
• Saving a document
• Page setup
• Text formatting
• Quick text formatting
• Paragraph formatting
• Numbered lists
• Bulleted lists
• Borders and shading
• Automatic text corrections
• Proofing tools
• Language settings
• Header and Footer
• Printing a document
• Working with Microsoft Word Help

Who is it for?

Roles including:

• Office computer user
• Those wanting to develop Microsoft Word skills and knowledge
• Job Seekers
• Those working with computers
• Those using Microsoft Word at work, home or in education

Course Overview

Format

• Advanced
• 8-9 Study Hours
• Online Study

Accreditation

• Online Interactive Course
• Bathe Qualifications Endorsed

Course description

This online course has been made for those who regularly use Microsoft Excel 2016 but want to become fully familiar with the various tools and features the program offers.

The course Microsoft Excel 2016: Advanced is focused mainly on the creation of charts and automation of the work in the program by using macros.

Besides these main topics, you will also examine the insertion of various graphical elements into worksheets, such as shapes or SmartArt graphics.

You will learn to prepare a table or the entire worksheet before printing and you will familiarise yourself with the options of protecting and sharing the workbook content.

You will further familiarise yourself with the usage of macros, including their creation and editing and you will also examine the options of macro security.

You will learn

• Sparklines
• Charts creation
• Chart design
• Chart formatting
• Screenshots and screen clipping
• Shapes
• SmartArt
• Themes
• Proofing tools
• Tracking changes
• Comments
• Managing multiple windows
• Splitting worksheets into panes
• Workbook views
• Header and footer
• Page setup
• Microsoft account
• File properties
• Workbook protection
• Workbook inspection
• File AutoRecovery
• Using templates
• Compatibility issues
• Saving a workbook to the Web
• Introduction to macros
• Macro recording
• Macro editing
• Macro security
• Digitally signed macros

Who is it for?

Roles including:

• Office computer user
• Those wanting to develop Microsoft Excel skills and knowledge
• Job Seekers
• Those working with computers
• Those using Microsoft Excel at work, home or in education

Package Overview

Format

• Basic to Advanced
• Up To 33 Study Hours
• Online Study

Accreditation

• Flexible Online Training
• Bathe Qualifications Endorsed

Package description

This course is designed to improve your Microsoft Access skills whether you have used or not used the software before.

Microsoft Access is a database management system which allows users to analyse large amounts of information and manage data more efficiently than Excel or other spreadsheet applications. 

Designed for all abilities, our courses are broken down into three levels – introductory, intermediate and advanced, so you can be sure to find the level you require.

In the three courses dedicated to this program, you will learn step by step to create such databases and to process their data, ensuring you become familiar with the program environment and terminology.

What is included in this package?

These three courses will help you develop your skills from a beginner’s level to an advanced one. With these three courses you will cover:

• How to design tables, set the properties of their fields and try the entry of data to them
• How to link the individual tables with each other via relations and set the relation properties.
• How to structure the entire database to be able to use it efficiently
• How to select specific data from the created tables via queries, in combination with calculations to achieve new data
• How to use special action queries
• How to arrange the data from tables and those derived by queries using forms and reports in order to print them or to make the entry of new data easier
• How to create macros that will automate the work in a database and will control whether the entered data comply with the set rules
• The options of importing and exporting data in databases and saving their individual objects

Why take this course?

This online training will help learners who may or may not have previous experience with Microsoft Access to develop their skills and understanding of each software and how it works, and create digital documents to improve their work or employability.

Who should take this course?

These courses are aimed at anyone who uses Microsoft Office, whether that is in study, at home or at work. As our courses are tailored to all abilities with introductory, intermediate and advanced levels, they are suitable for all learners. This ranges from beginners to those learners who want to refresh and update knowledge they already have.

Elearning content

• MS Access 2016: Introduction
• MS Access 2016: Intermediate
• MS Access 2016: Advanced

Certificate

All learners who successfully complete the course will be able to download and print a certificate. As this is an excellent indication of your skills, we suggest you keep it for your own records in order to show current or future employers.

You will learn

• How to design tables set the properties of their fields and try the entry of data to them
• How to link the individual tables with each other via relations and set the relation properties
• How to structure the entire database to be able to use it efficiently
• How to select specific data from the created tables via queries in combination with calculations to achieve new data
• How to use special action queries
• How to arrange the data from tables and those derived by queries using forms and reports in order to print them or to make the entry of new data easier
• How to create macros that will automate the work in a database and will control whether the entered data comply with the set rules
• The options of importing and exporting data in databases and saving their individual objects

Who is it for?

Roles including:

• These courses are aimed at anyone who uses Microsoft Office, whether that is in study, at home or at work. As our courses are tailored to all abilities with introductory, intermediate and advanced levels, they are suitable for all learners.
• This ranges from beginners to those learners who want to refresh and update knowledge they already have.
• Anyone who is looking to improve their Microsoft Access skills and knowledge

Package Overview

Format

• Basic to Advanced
• Up To 187 Study Hours
• Online Study

Accreditation

• Online Interactive Course
• Bathe Qualifications Certified

Package description

This set of Microsoft office courses has been designed to give you a complete knowledge of Microsoft office 2016 including Word, PowerPoint, Excel, Access and Outlook. These are the most widely used Microsoft applications in both the workplace and for students.

Overview

This set of Microsoft office courses has been designed to give you a complete knowledge of Microsoft office 2016 including Word, PowerPoint, Excel, Access and Outlook. These are the most widely used Microsoft applications in both the workplace and for students. These courses will cover an introductory level through to an advanced one.

Course Description

As the use of electronic documents is becoming the preferred method of sharing knowledge and information, it is becoming more important to understand how to create, design and use them. In order to achieve this, you need a decent knowledge of the whole suite of common office programs. The presented Microsoft Office suite has established a widely respected standard in this area through years, and at the moment, it represents the widest and most purchased offer of software used in business.

Each of the interactive lessons tackles one specific issue. After getting acquainted with the tools and processes related to it, you can immediately practice the acquired knowledge in the real application. Several quiz questions included at the end then help you realise whether you have mastered the topic or you need to review the content.

Why take this course?

This online training will help learners who may or may not have previous experience with the Microsoft Office programs to develop their skills and understanding of each software and how it works and create digital documents to improve their work or employability.

Who should take this course?

These courses are aimed at anyone who uses Microsoft Office, whether that is in study, at home or at work. This package is tailored to beginners who want to ensure they gain a complete knowledge of these popular Microsoft programs.

E-learning content

MS Word 2016: Introduction

MS Word 2016: Intermediate

MS Word 2016: Advanced

MS Excel 2016: Introduction

MS Excel 2016: Intermediate

MS Excel 2016: Advanced

MS PowerPoint 2016: Introduction

MS PowerPoint 2016: Intermediate

MS PowerPoint 2016: Advanced

MS Outlook 2016: Introduction

MS Outlook 2016: Intermediate

MS Outlook 2016: Advanced

MS Access 2016: Introduction

MS Access 2016: Intermediate

MS Access 2016: Advanced

Certificate

All learners who successfully complete the course will be able to download and print a certificate. As this is an excellent indication of your skills, we suggest you keep it for your own records in order to show current or future employers.

You will learn

• Introductory/Intermediate/Advanced Microsoft Word 2016
• Introductory/Intermediate/Advanced Microsoft Excel 2016
• Introductory/Intermediate/Advanced Microsoft PowerPoint 2016
• Introductory/Intermediate/Advanced Microsoft Outlook 2016
• Introduction/Intermediate/Advanced MS Access 2016

Who is it for?

Roles including:

• These courses are aimed at anyone who uses Microsoft Office, whether that is in study, at home or at work

Course Overview

Format

• Introductory Course
• 8-9 Study Hours
• Online Study

Accreditation

• Online Interactive Course
• Bathe Qualifications Endorsed

Course description

If you have have never used or have little previous experience of using Microsoft Access 2013 then this course is the perfect introduction to the program.

In the course Microsoft Access 2013: Introduction, you will familiarise yourself with the terminology concerning relational databases and with the basics of working in the Access program.

You will try various ways of creating tables and setting the properties of their fields, and will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them.

You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports.

You will learn

• Introduction to databases and their objects
• Access environment
• Creating a table in the Datasheet View
• Design view of tables
• Advanced field data types
• Restricting data input in tables
• Analysis of relationships between tables
• Relationships between tables
• Referential integrity
• Navigation in tables
• Searching for records and editing them
• Sorting and filtering data in tables
• Select queries
• Creating a select query
• Criteria in select queries
• Calculated fields in queries
• Joining tables for the purpose of a query
• Lookup columns in tables
• Editing a lookup column
• Automatic creation of forms
• Report creation

Who is it for?

Roles including:

• Office Workers
• Those wanting to develop Microsoft Access skills and knowledge
• Job Seekers
• Those working with computers
• Those using Microsoft Access at work, home or in education