5092 Courses delivered Online

Learn and master Excel 2019 by learning advanced functions and formulas

10 QLS Endorsed Courses for Financial Analyst | 10 Endorsed Certificates Included | Life Time Access

10 QLS Endorsed Courses for Paralegal | 10 Endorsed Certificates Included | Life Time Access

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

Course Overview Are you a video game fanatic who's always trying out the latest games? Then you might want to consider becoming a Game Tester! Turn your passion for gaming into a steady income and get qualified to test games with this Game Testing Online Course. This Game Tester training course will teach you everything you need to know about the quality assurance testing of games, taking you through the testing process step-by-step. You will learn how to find and report bugs and glitches and detect code errors and faults, gaining an in-depth understanding of how video games are made.  What's more, you will develop your knowledge of the history and nature of the gaming industry, including industry trends and developments. This course is ideal for anyone seriously considering a career in gaming, who has excellent IT and analytical skills. Do you live and breathe video games? Become a certified Game Tester, with this comprehensive course!    What You Will Learn This Game Tester Course will teach you everything you need to know to test the quality of video games, with step-by-step guidance. It covers the role of the Game Tester in detail, including skills and career opportunities. Game Quality Assurance & Testing An Overview of the Game Testing Process The Role & Responsibilities of a Game Tester Career Path & Skills in the Gaming Industry How to Report Bugs and Glitches Understanding How Video Games Are Made The History and Evolution of the Gaming Industry How to Detect Code Errors and Faults Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course. Game Tester Secrets Introduction to Game Testing FREE 01:00:00 Two Rules of Game Testing FREE 01:00:00 How to Put a Resume Together 01:00:00 How give Examples During Job Interview 00:30:00 Contacting Game Developers 01:00:00 Use the Correct Search Keywords 01:00:00 Wrapping Up 00:15:00 Additional Study Material Game QA & Testing 00:00:00 Game Testing Changers 00:00:00 Become A Game Tester 00:00:00 Mock Exam Mock Exam- Game Tester Secrets 00:20:00 Final Exam Final Exam- Game Tester Secrets 00:20:00

This comprehensive course is beneficial for those who work with children on a regular basis and want to understand child safeguarding and protection in detail. This course will help you adhere to the legal frameworks for child safeguarding. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand child safeguarding and child abuse Demonstrate the key legal framework for child safeguarding Identify the children in need and child abuse Know how to report abuse and record information Know how to design effective assessments of children in need Master key organisations and tips for child safeguarding Understand child safeguarding standards and safeguarding arrangements Understand the importance of good record-keeping and when to report concerns Child Protection and Safeguarding Course Overview All childcare providers must abide by the guidance provided by Working Together to Safeguard Children (2018) which requires them to create strict safeguarding rules and regulations for their facility that include how to handle and document child safety concerns. This course outlines the typical forms of abuse, and how to identify them, and report them. You will learn how to recognise children in need, effective assessment of children in need, and safeguarding arrangements. This online course will help you understand child safeguarding standards, key organisations and tips for child safeguarding, and recording information. Upon successful completion of this Child Protection and Safeguarding, you will have in-depth knowledge of child safeguarding, child abuse, and the legal framework for child safeguarding. Who should take this course? This Child Protection and Safeguarding is primarily aimed at: Nurse Teachers Parents Healthcare Assistant Social Care Workers Students of Psychology Childcare Provider Staff Mental Health Professionals This training is, however, not restricted to a particular profession or field of endeavour. It may also benefit a larger range of people who want to gain in-depth knowledge in child safeguarding, child abuse, and legal frameworks for child safeguarding. Entry Requirements There are no academic entry requirements for this Child Protection and Safeguarding, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method  This Child Protection and Safeguarding assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum How IT Works How IT Works Module 1: Introduction to Child Safeguarding Module 1: Introduction to Child Safeguarding Module 2: Understanding Child Safeguarding Understanding Child Safeguarding Module 3: Child Abuse Child Abuse Module 4: Legal Framework for Child Safeguarding Legal Framework for Child Safeguarding Module 5: Recognition of Children in Need Recognition of Children in Need Module 6: Effective Assessment of Children in Need Effective Assessment of Children in Need Module 7: Safeguarding Arrangements Safeguarding Arrangements Module 8: Child Safeguarding Standards Child Safeguarding Standards Module 9: Key Organisations and Tips for Child Safeguarding Key Organisations and Tips for Child Safeguarding Module 10: Recording Information Recording Information Conclusion Conclusion Assessment Assessment - Child Protection and Safeguarding Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification. Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Using VBA with Form Controls Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Our 'Child Neglect Awareness Certificate Course' is your gateway to understanding and combatting child neglect. Through a series of comprehensive modules, you'll delve into the intricacies of this critical issue. Learn to recognize the signs of child neglect, explore the risk factors involved, and grasp the profound impact it has on children's lives. This course equips you with the knowledge to identify and report cases of child neglect while understanding the relevant legislation. By the end of this course, you'll be empowered to actively prevent child negligence and play a crucial role in creating a safer environment for children. Learning Outcomes Gain a deep understanding of child neglect. Recognize the signs and risk factors associated with child neglect. Comprehend the significant impact of child neglect on children. Familiarize yourself with relevant legislation related to child neglect. Learn how to respond, report, and actively prevent child neglect. Why choose this Child Neglect Awareness Certificate Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Child Neglect Awareness Certificate Course for? Parents and caregivers seeking knowledge on child neglect. Educators and school personnel concerned about child welfare. Social workers and professionals in child protection services. Healthcare providers wanting to identify child neglect. Anyone interested in safeguarding children from neglect. Career path Child Protective Services Worker: £25,000 - £40,000 Social Worker: £25,000 - £45,000 Teacher: £25,000 - £40,000 Nurse: £24,000 - £40,000 Counselor: £23,000 - £45,000 Childcare Worker: £15,000 - £25,000 Prerequisites This Child Neglect Awareness Certificate Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Child Neglect Awareness Certificate Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Child Neglect Introduction to Child Neglect 00:19:00 Module 02: Signs of Child Neglect Signs of Child Neglect 00:38:00 Module 03: Risk Factors for Neglect Risk Factors for Neglect 00:25:00 Module 04: The impact of Child Neglect The Impact of Child Neglect 00:28:00 Module 05: Child Neglect Cases Child Neglect Cases 00:33:00 Module 06: Legislation Surrounding Child Neglect Legislation Surrounding Child Neglect 00:25:00 Module 07: Responding to and Reporting Child Neglect Responding to and Reporting Child Neglect 00:36:00 Module 08: Prevent Child Negligence Prevent Child Negligence 00:26:00 Assignment Assignment - Child Neglect Awareness Certificate Course 00:00:00

Kickstart your career with this Salesforce Platform App Builder Certification program. Salesforce skills are in high demand, and you can learn the core concepts of online application development using Salesforce App Builder and Force.com Platform Fundamentals.

Foundation Level training course is for people working with Children and Young People who are victims of County Lines abuse.