7448 Courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Birth Right Hypnobirthing is a full antenatal birth preparation course for pregnancy. Particularly useful for those who are scared of giving birth. Whether this is your first or tenth baby this information is essential. Whether you're looking for a natural birth or support for your caesarean birth this course will support you and give you the tools for the best birth for you.

This qualification is for learners who wish to gain the knowledge, skills and confidence to effectively coach or mentor people within an organisational context. It is also an ideal qualification for those who wish to commence a career in coaching or mentoring.

Uncovering Emotional Root Causes of Health Challenges Instructor Craig Weiner, DC, Licensed MetaHealth Foundation Trainer, EFT Master Trainer of Trainers. Learn to apply a method of analysis that effectively guides the application and integration of EFT, Matrix Reimprinting and other alternative healing modalities you may already currently use for yourself and on your clients. Discover how symptoms and disease are actually an intelligent process that is the body’s attempt to heal stress and trauma. With this knowledge, fear can be greatly reduced and a therapeutic intervention can then be utilized in a more precise way. You and your clients will achieve results faster and will be amazed at the insights, connections and progress they make in their healing journey. META-Health is the science, practice and art of Body-Mind-Social Health with a focus on how specific stress triggers, emotions and beliefs affect specific organ symptoms. META-Health is a methodology based on Integrative Medicine and Prevention and is practiced by all types of health professionals interested in a precise and effective Body-Mind-Social analysis and approach towards most effectively supporting individuals working to find emotional and physical healing. Your trainer for this Foundation weekend will be Craig Weiner, who has worked in the complementary health care field for over 30 years. He brings his professional clinical experience, his years as an educator and certified trainer in the Emotional Freedom Techqniques and Matrix Reimprinting and as a licensed META-Health Foundation Trainer. In the Foundation Course you will get the overview of the META-Health concepts and its implications for self-healing, assistance in transforming disease, and achieving sustainable health and resilience, including: Rhythms of life, and the organism’s self-regulating intelligence How the bio-logical needs change your perception and create life strategies How to decode the language of your organs Recognize the key points and phases of the healing process Experience the powerful META-Analytics questions Use the 8 milestones of META-Health to address the whole system and its soil Find META-meanings to create resilience Demonstrations and practical exercises will lead you to deeply integrate the wisdom of your body, and inspire you to actively claim and support your health. You will understand the natural, dynamic path of healing, and be empowered to lift your – and others’ – consciousness to make use of our potential! During this weekend we will spend time reviewing the core META-Health Principles: Our body-mind is highly intelligent Bio-logical survival and stress strategies, regeneration and resilience are at play in our brain, nervous system and hormonal system Significant emotional experiences shape our beliefs, personality and lifestyle Specific individual stress triggers influence typical organ tissues and functions The cycle of stress, regeneration and learning goes through distinct points and phases Awareness and imagination are capabilities of our brain which can recreate meaning and reprogram body-mind’s reactions There is no pre-requisite to taking this weekend course. Anyone who is interested can participate in the META-Health Foundation Training. The Foundation Training is the first step in becoming a certified META-Health Practitioner. Times: The course is a 12 hours training and will be held from 9:00 to 4:00 Seattle/Pacific time on both Friday and Saturday with a 60 minute lunch break held at approximately 12:30pm.

Fatigue Reset: Crack Pacing once and for all! Module One: Your fatigue experience is about to get easier! Welcome to your Fatigue Reset! Here you will find everything you need to know about how you too can Crack pacing once and for all with my unique pacing method. Pacing often isn’t enough in itself to help someone achieve full recovery - attention to other healthy protocols is usually important too. But pacing is the way to make life feel easier, soon, and as well as helping to control your symptoms it gives your body the stability it needs to do whatever restorative work is needed. In short, pacing is vital - so I’m delighted you’ve signed up for this course.  Welcome 4 mins483 MB What is pacing? 187 KB Why you need this course 6 mins753 MB How to get the most from this course 4 mins490 MB About my own Fatigue Recovery journey 202 KB Module Two: The importance of getting into the right mindset. Tackling life with extreme fatigue can be difficult emotionally, not just physically. This module talks about a very important mindset shift that will help to ensure you adapt to pacing as quickly as possible. Although it’s a technique that’s often discussed, I hope my way of explaining it will encourage you to really try it. Why finding acceptance is so important 6 mins868 MB A simple technique to help you find acceptance5 mins662 MB Some more reframing examples 190 KB Module Three: My pacing method. This module contains step by step tutorials about my pacing method, including how to complete the different templates provided. If viewing on a small screen, you may wish to print the templates off first so that you can look at them clearly as I'm explaining the different sections. A brief introduction before we get started 3 mins343 MB Step 1 - Creating a master task list 24 mins612 MB Task List MASTER.pdf 51.1 KB Task List MASTER.xlsx 19.4 KB Step 2 - Pacing your week 11 mins311 MB Weekly plotter MASTER.pdf 46.5 KB Weekly plotter MASTER.xlsx 17.4 KB Step 3 - Planning your day 15 mins398 MB Daily scheduler MASTER.pdf 291 KB Daily scheduler MASTER.xlsx 22 KB Step 3a - Carrying out a daily review 7 mins261 MB How to put it all into practice 6 mins753 MB Getting started guide 224 KB Module Four: Further guidance to help you make this a success. The support and guidance in this module is here to help you as you start to put my pacing method into practice. Updates will be made each month and you will be alerted when new content is available. My support for you 2 mins210 MB Frequently asked questions and answers 334 KB Quick tips for re-sizing tasks 202 KB Some more examples of delegating and outsourcing tasks 182 KB Using your baseline 190 KB How to rest 9 mins1.26 GB Resting factsheet (summary points) 16.5 KB Module Five: Moving to a more sustainable pacing approach. When the time is right, this lighter approach to pacing will help you stick to your baseline while enjoying carrying out each day with a little less structure and up-front planning. Why I feel moving to a simplified approach is important 3 mins337 MB My 'Guardrails' approach to pacing 9 mins1.29 GB A guide to my Guardrails approach 170 KB The End I'm so pleased you've made it this far, and I wish you all the very best with your ongoing fatigue rescue journey. A few final words 3 mins371 MB

>>24 Hours Left! Don't Let the Spring Deals Slip Away - Enrol Now!<< The Health & Social Care industry is one of the most important and rewarding fields of work. With a growing aging population and increasing demands for healthcare, there has never been a better time to consider a career in this Health Social Care sector. OurLevel 2 & 3 Diploma in Health & Social Care + Care Certificate Standards (1 to 15) Package provides a comprehensive curriculum covering all the essential aspects of this industry, from communication and caregiving to legal and ethical standards. You will learn the principles and policies of working in Health Social Care, and gain an understanding of important issues such as safeguarding vulnerable individuals, risk management, and health and safety responsibilities. Courses Are Included in This Care Certificate (1 to 15 Standards) with Health & Social Care Level 3 Diploma: Course 01: Level 2 & 3 Diploma in Health & Social Care Course 02: Care Certificate (Standards 1 to 15) Course 03: Observation Skills for Carers Course 04: Dementia Training Course 05: Medication Administration Training By completing this course, you will be equipped with the knowledge and skills needed to work as a competent Health Social Care professional. You will be able to communicate effectively with patients and colleagues, understand your rights and responsibilities, and promote equality, diversity, and rights in the workplace. You will also have a strong understanding of the legal, professional, and ethical aspects of healthcare, enabling you to provide safe and effective care to vulnerable individuals. This course is suitable for anyone who is interested in working in the Health Social Care sector. Whether you are a school leaver, looking to change careers, or simply want to develop your knowledge and skills in this area, this Health Social Care course is for you. At the end of this Health Social Care course, you will learn: Develop effective communication skills in Health Social Care. Understand legal and ethical standards of practice in healthcare. Promote equality, diversity, and rights in the workplace. Understand the principles and policies of working in Health Social Care. Identify and manage risks in the workplace. Safeguard vulnerable individuals in Health Social Care. Why Choose Our Health Social Care Course: Get instant access to this course. Health Social Care is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the course materials Health Social Care comes with 24/7 tutor support Level 2 & 3 Diploma in Health & Social Care Certificate Introduction to Health Social Care Certificate Health Social Care Certificate Communication and its Relevance Rights and Responsibilities as a Health Social Care Worker Role as A Caregiver and Health Social Care Professional Working in Health Social Care Certificate; Promoting Equality, Diversity and Rights Important Principles and Policies in Health Social Care Work Legal and Professional Standards of Practice in Health Social Care Part - 1 Legal and Professional Standards of Practice in Health Social Care Part - 2 Health Social Care Safeguarding Vulnerable Individuals Health Social Care Responsibilities The Economics of Health Social Care Strategic Marketing for Health Social Care Managing Finance in Health Social Care Certificate Managing Service Delivery in Health Social Care Course 02: Care Certificate Standards 1-15 Your Health Care role and responsibilities Your personal development Health Care & Safeguarding children Health Care & Safeguarding Adults Person-centered health care certificate Infection prevention and control Health and safety Fluids and nutrition Equality and diversity Equality and diversity Data protection and confidentiality Health care Communication Basic Life Support Caring for Mental Health Privacy and Dignity Assessment Process Your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Health Social Care Level 3 course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Health Social Care course is suitable for: School leavers Career changers Healthcare assistants Support workers Caregivers Anyone interested in Health Social Care This Diploma in Health & Social Care Level 2 & 3 course doesn't have formal qualifications. However, in order to get qualified, you have to join - RQF health and social care level 3 level 3 nvq health and social care Certificate Level 3 Diploma in Health and Social Care Certificate Level 4 NVQ Health and social care Certificate level 5 nvq health and social care Certificate level 2 nvq health and social care Certificate level 3 nvq health and social care Certificate Level 3 Diploma in Health and Social Care a level health social care Certificate Level 4 NVQ Health and social care Certificate RQF health and social care level 3 QCF level 2 health and social care Certificate health and social care level 3 Level 3 Diploma in Health and Social Care Certificate Level 4 NVQ Health and social care Certificate QCF level 3 health and social care Certificate level 3 nvq health and social care Certificate Mental Health Care Worker rqf health and social care Certificate Level 3 Diploma in Health and Social Care Certificate Level 3 Diploma in Adult Care (RQF) level 2 rqf Health and social care Certificate Level 5 nvq Health and Social Care Management Mental Health Care Worker level 3 nvq health and social care Certificate Level 3 Diploma in Health and Social Care Certificate Certificate in Management for Level 5 nvq health and social care or qcf level 3 nvq health and social care Certificate Level 3 nvq health and social care Certificate Level 4 NVQ Health and social care Certificate Mental Health Care Worker Level 3 Diploma in Health and Social Care Certificate level 3 nvq health and social care Certificate Level 4 NVQ Health and Social Care Certificate level 3 nvq health and social care Certificate NCFE CACHE Level 2 Certificate in Understanding Mental Health First Aid and Mental Health Advocacy in the Workplace NVQ Level 3 Mental Health Care Certificate level 3 nvq health and social care Certificate Level 3 Diploma in Health and Social Care Certificate level 2 diploma in health and social care ncfe cache level 2 extended diploma in health and social care Requirements There is no formal requirement for Health Social Care course. Career path Enrolling on this Health Social Care Level 3 can lead you to the following career paths: Healthcare Assistant (£16,000 - £22,000) Support Worker (£16,000 - £23,000) Caregiver (£16,000 - £25,000) Mental Health Support Worker (£17,000 - £25,000) Residential Support Worker (£18,000 - £27,000) Community Support Worker (£20,000 - £30,000) Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

This half-day workshop delivered face-to-face or online is designed for anyone in your organisation that wants to become a Neurodiversity Champion - someone who wants to educate and change the way that Neurodiversity is viewed in the workplace.

Are you seeking to make a real impact at work by gaining new leadership skills and enhancing your personal development? Our accredited Leadership Foundation Programme provides you with in-depth understanding of how to enhance business performance and employee wellbeing, and how you as an effective change leader can coach, inspire, engage and empower your people. And you gain an internationally recognised ILM Level 5 Award in Leadership and Management.

Fully Approved Course - CPD and ILM Approved 100% online training, 90 minutes course Stop & start at anytime No time limit Course Description A leader doesn’t necessarily have to be a ‘manager’, but it’s difficult to see how a manager could be truly effective without having at least some leadership skills. This course starts by introducing the basics of leadership and explores where the concept originated from. It then goes on to discuss various leadership theories, including situational leadership, contingency theories, transactional and transformational leadership and more. It then moves on to discuss developing teams including and team members by looking at the role leaders play in this. The final two modules cover the role communication plays in effective leadership and finishes off with a module about moving forward together to achieve a shared vision. Modules: Leadership and Management Leadership Theories Team Development and Leadership Individuals Within Teams Communicating One-to-One with Individuals Moving Forward Together Target Audience This course is aimed at supervisors and managers that want to develop more effective relationships with members of their teams. T he course can be a great starting point for people new to their leadership role as well as more established managers that want to enhance their skills. This acts as a great introduction to the subject. This course can be sold to individuals who are doing the training for themselves or it can be pitched to businesses who might want to put all of their first line management team through the training, so they are all work in the same way and have the same skill set. Advantages CPD approval means that this course can be used by those that need to prove they are continually developing themselves. ILM approval means that this course can provide candidates with a recognised management qualification. A strong leader will motivate their team, improving morale and efficiency and ensure that their team is of a common purpose. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training around their work and personal life. Further Progression For candidates that want to add more qualifications to their CV our Introduction to Emotional Intelligence course is a great introduction to that aspect of Leadership and management. For candidates specifically interested in developing resilient teams our Developing Teamwork course goes hand in hand with this one and expands on some of the key ideas and how they can be applied to teams. For candidates new to management roles Managing Meetings would be a great next step although working through any of our range of Business Skills courses would be valuable.