This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access
This practical workshop covers the unique challenges of working with complex trauma cases and gives you clear guidance on the most effective ways to help Accredited CPD: 6 hours Length: 1 day (9.30am - 4.00pm) Absolutely jam-packed with techniques/information and resources. Ros is superlative. A calm, confident and articulate trainer...J YAP, THERAPIST Why take this course Clients suffering from Complex PTSD (C-PTSD) or who have experienced trauma in a shutdown or dissociative state, can present unique challenges to practitioners working with them – but with the right knowledge and skills we can help sufferers move forward in their lives. In this hands-on, experiential workshop you will learn more about what makes trauma ‘complex’, why shutdown or dissociation are often experienced by sufferers, and how to best work with such presentations using the Human Givens framework of understanding. You will also have the chance to collaborate with other experienced practitioners and clinicians during exercises designed to further your understanding, add to your existing skillsets, and bring wider context to an often-misunderstood area of work. During this intensive day of live, in-person training, experienced psychotherapist Ros Townsend will introduce you to a framework within which you can set your understanding of complex trauma presentations and discover the opportunities that we have to help clients move forward from their difficulties. You will learn more about the neurobiology of the automatic survival options that we have available to us, especially dissociative and ‘shutdown’ states, and leave with an understanding of how to use this knowledge to inform your work, giving you greater confidence to work creatively and flexibly with such presentations. From understanding the symptoms that are now recognised as distinguishing C-PTSD, to adapting existing HG techniques and strategies and introducing new tools and skills, this course will explore how we, as clinicians, can approach such complex presentations without getting lost in the complexity ourselves. Using case histories and discussion you will have the chance to understand more about the unique challenges that such work presents and to leave feeling more confident in your ability as a therapist to work effectively and contextually with these. Such a thought-provoking and informative day. Complex PTSD is a real buzz word at present, this took the mystery out of it in a clear and understandable way – highly recommend...MELISSA DERRICOURT What will you learn What Complex PTSD (C-PTSD) is What other symptoms a client may present with in addition to those meeting the criteria for ‘classic’ PTSD How to effectively work with these within the Human Givens framework of understanding Vital tools for psycho-education – both adding to your own understanding and to pass on to clients Why individuals enter into a dissociative or ‘shutdown’ state The difference between ‘freeze’ and ‘shutdown’ Why anger can present when an individual comes out of a ‘shutdown’ state How to help a client deal effectively with anger if it does arise The crucial role of the pattern-matching processes in the brain in post-traumatic stress symptoms – and how the kinds of templates stored can subtly differ in more complex trauma How to adapt existing techniques – such as rewind and deconditioning molar memories – to work creatively with such presentations The Dos and Don’ts when working with Guided Imagery in complex presentations How to refine your Guided Imagery skillset to powerfully benefit clients who have experienced trauma in a shutdown state Why any work that we do must be informed by the innate ability we all have to recover from trauma How to avoid negatively reframing trauma and making symptoms worse The most effective ways to help clients towards recovery and post-traumatic growth Under careful guidance from the tutor, you will: Explore and discuss the different survival options available to us as humans in traumatic situations Learn more about the neurobiology of these states – including our passive survival responses Develop a new framework of understanding within which to set your work with all kinds of trauma Understand more about why ‘shutdown’ or ‘dissociation’ are often associated with complex presentations Understand why addictions and self-harming behaviours are often a part of the picture Work collaboratively with peers and colleagues to extend and develop your own skillsets and knowledge Explore how guided imagery can be adapted and used to most powerfully benefit clients suffering in this way You will leave with: The confidence to work creatively and flexibly with a wider range of presentations A clear understanding of a framework within which you can work and continue to develop and adapt your tools and skillsets An appreciation of the importance of taking your time with such work and proceeding at a pace right for each individual client An understanding of how to support clients in moving forward from the use of faulty coping strategies – such as addiction and self-harm Greater confidence in creating metaphors that work powerfully for clients An understanding of how helping a client to meet their emotional needs is particularly key to recovery in the most complex cases Throughout the day there will be plenty of opportunity for you to ask questions and to engage in collaborative work and discussion with the tutor and with experienced colleagues and practitioners. Important note Working with Complex PTSD requires specific skills and experience and thus is only suitable for practitioners either already working in this area and looking to extend their skillset or those who are already practicing as therapists and wish to begin working in this area. If you are an experienced practitioner from another modality, we recommend you familiarise yourself a little with the HG approach before you attend, see: About HG therapy, benefits of the approach, and what is RIGAAR. Who is this course suitable for? Any qualified therapist working with distressed or traumatised people. In order to take full benefit from the course, you will ideally have already taken our Guided Imagery and Visualisation for therapeutic change and Rewind Technique workshops. NB If you are an experienced practitioner from another modality, we recommend you familiarise yourself a little with the HG approach before you attend, see: About HG therapy, benefits of the approach, and what is RIGAAR. Any qualified practitioner in the field of psychiatry, psychology, psychotherapy or counselling can attend; again you would benefit most by having previously attended our Guided Imagery and Visualisation and Rewind Technique workshops and familiarising yourself a little with the HG approach to therapy. Course Programme This intense 1-day training proceeds through a blend of talks, skill-developing exercises, discussions and deconstruction of real-life case-studies. There is also plenty of opportunity for networking and discussion during the breaks. The training runs from 9.30am–4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am What is complex trauma? A framework for understanding 11.00am Discussion over tea/coffee 11.30am Adapting our toolkit: working creatively with complex presentations 1.00pm Lunch (included) 1.45pm Self-efficacy: supporting a client to become an active agent in life 2.45pm Discussion over tea/coffee 3.00pm Reframing: adding context in complex cases 3.30pm Serving clients well 4.00pm Day ends This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.
The aim of this programme is to help attendees create better quality technical documents in an organised and efficient manner. It will give those new to the topic an appreciation of how to approach the task professionally whilst those with more experience will be able to refresh and refine their skills. The programme comprises three complementary one-day modules: The programme presents a structured methodology for creating technical documents and provides a range of practical techniques that help delegates put principles into practice. Although not essential, it is strongly advised that delegates for modules 2 and 3 have already attended module 1, or another equivalent course. Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. This course will: Explain the qualities and benefits of well written technical documents Present a structured approach for producing technical documents Review the essential skills of effective technical writing Demonstrate practical methods to help create better documents Provide tools and techniques for specification and report writing Review how technical documents should be issued and controlled Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. Module 1: Essential skills for technical writers 1 Introduction to the programme Aims and objectives of the module Introductions and interests of participants 2 Creating effective technical documents What is technical writing? how does it differ from other writing? Key qualities of an effective technical document Communication essentials and the challenges faced by technical writers The lessons of experience: how the best writers write The five key steps : prepare - organise - write - edit - release (POWER) 3 Preparing to write Defining the document aims and objectives; choosing the title Understanding technical readers and their needs Getting organised; planning and managing the process Integrating technical and commercial elements The role of intellectual property rights (IPR), eg, copyright 4 Organising the content The vital role of structure in technical documents Deciding what to include and how to organise the information Categorising information: introductory, key and supporting Tools and techniques for scoping and structuring the document Creating and using document templates - pro's and con's 5 Writing the document Avoiding 'blinding them with science': the qualities of clear writing Problem words and words that confuse; building and using a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity; being concise and ensuring clarity Using diagrams and other graphics; avoiding potential pitfalls 6 Editing and releasing the document Why editing is difficult; developing a personal editing strategy Some useful editing tools and techniques Key requirements for document issue and control Module 2: Creating better specifications 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' writing process for specifications 2 Creating better specifications The role and characteristics of an effective specification Specifications and contracts; the legal role of specifications Deciding how to specify; understanding functional and design requirements Developing the specification design; applying the principles of BS 7373 Getting organised: the key stages in compiling an effective specification 3 Preparing to write a specification Defining the scope of the specification; deciding what to include and what not Scoping techniques: scope maps, check lists, structured brainstorming The why/what/how pyramid; establishing and understanding requirements Clarifying priorities; separating needs and desires: the MoSCoW method Useful quantitative techniques: cost benefit analysis, QFD, Pareto analysis Dealing with requirements that are difficult to quantify 4 Organising the content The role of structure in specifications Typical contents and layout for a specification What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the specification Identifying and understanding the specification reader Key words: will, shall, must; building and using a glossary Writing performance targets that are clear and unambiguous Choosing and using graphics Exercise: writing a specification 6 Editing and releasing the document Key editing issues for specifications Issue and control of specifications Module 3: Writing better reports 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' technical writing process for technical reports 2 Creating better reports What is a technical report? types and formats of report The role and characteristics of an effective technical report Understanding technical report readers and their needs The commercial role and impact of technical reports Getting organised: the key stages in compiling a technical report 3 Preparing to write reports Agreeing the terms of reference; defining aims and objectives Being clear about constraints; defining what is not to be included Legal aspects and intellectual property rights (IPR) for reports Preparing the ground; gathering information and reference documents Keeping track of information: note making, cataloguing and cross referencing Tools and techniques for developing a valid and convincing argument 4 Organising the content The role of structure reviewed; some typical report structures Who needs what: identifying the varied needs of the readership What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the report Planning the storyline: the report as a journey in understanding Recognising assumptions about the reader; what they do and don't know Converting complex concepts into understandable statements Presenting technical data and its analysis; the role of graphics Presenting the case simply whilst maintaining technical integrity Exercise: writing a technical report 6 Editing and releasing the report Key editing issues for technical reports Issue and control of technical reports
If your organisation manages contractors then your staff need to understand the health and safety issues. This course is the answer. The expert trainer will set out clearly the legal responsibilities of all relevant parties and explore the practical application of these responsibilities with the course participants. The course will then examine the issues associated with the planning of work to be contracted out and the evaluation, selection, control and monitoring of contractors engaged to undertake the work. Although the main focus is on health and safety, the course will also explain how health and safety issues need to be integrated into your organisation's functional management processes to ensure effective control of contractors. The course will consider all types of contracted activities, including construction and maintenance, cleaning, security, plant installation, etc. This programme will give participants: A clear understanding of the organisation's legal responsibilities for managing contractors The information they need to assess the competence of contractors A practical understanding of risk assessment principles and the transfer of risk to contractors A step-by-step guide to the key aspects of managing contractors in practice, covering:Planning of the workSelecting contractorsHandover prior to work commencementDuring the workReviewing the work on completion Practical guidance on the integration of health and safety controls into organisational procedures for contractor management 1 Introduction Who are contractors? Why manage contractors? Different types of contractors Costs of poor contractor performance 2 Overview of health and safety law and liability Health and safety law and statutory duties Relevance of civil and criminal law Enforcement and prosecution 3 Relevant legislation for controlling contractors Health and Safety at Work Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 1994 (as amended, 2007) Other relevant legislation Contract law 4 Managing contractors in practice Exercise - how well is it happening? The objectives Five step approachPlanning of the workSelecting contractorsHandover prior to work commencementDuring the workReviewing the work on completion 5 Planning the work Scope and extent Risk assessment Interface and other activities Who controls what? Contract arrangements 6 Selecting the right contractor(s) Locating contractor organisations Selection the right contractors Assessing contractor competence Approved lists/frameworks Tender process 7 Pre-work commencement Co-ordination and co-operation Exchange of information Contractor risk assessments and method statements Permits to work Case study exercise 8 During contract work Communication and liaison Supervision and inspection of the work Inspection and reporting procedures Security issues Facilities and access 9 Reviewing work on completion Why, what and how? Achieving continuous improvement in contractor performance 10 Questions, discussion and review
First Aid at Work (RQF) accredited course delivered by Health Care Professionals
Our Health & Safety Awareness Course at Knight Training provides you with an understanding of health and safety in construction so which you can later use to apply for the CSCS Green Card. Come and train with us now at https://knight.training/products/1-day-health-and-safety-awareness-green-card-qualsafe
Weekend Course Covevering The Taoist Practice of Dragon Dao Yins
Do you wish to advance your professional development in healthcare by gaining the necessary skills and knowledge relevant to catheterisation? This comprehensive catheterisation training course is ideal for you! This course will help you learn about the entire process of catheterisation and the best practices for handling, inserting, and changing catheters securely. Whether you are a beginner or an experienced individual looking to advance your career in the healthcare sector, this course will set you up with the appropriate training required to excel in your role. This extensive catheter training online course covers the following credentials: Catheterisation process and methods Male and female catheterisation Various types of catheters Placement of the catheter after surgery Aseptic method Female and male urethral catheterisation Course Highlights Designed by healthcare professionals Accredited by the CPD Certification Recognised and Valuable Certification Self-Paced Online Theoretical Learning High-Quality E-Learning Study Materials Interactive practical training Remote Theoretical Learning Classroom-Based Catheterisation Training Course To ensure effective catheter training, our classroom-based learning is divided into two parts: Remote theoretical learning (online) We offer comprehensive theoretical instruction for the first portion of our catheterization training course, which you can finish at your own convenience. After successfully completing the courses and assessments, you can go on to the practical learning phase. Practical learning As part of the practical training, you will receive practical demonstrations and hands-on experience to justify your role. Who is this Catheterisation Training Course for? This catheterisation course is primarily aimed at: Health Visitors Healthcare professionals Nurses, midwives, pharmacists and doctors Freshers looking to begin their career in the healthcare sector Anyone looking to enhance their catheterisation skills Whether you are a fresher looking to kickstart your career in the field of healthcare and searching for catheterisation training for nurses or practising healthcare looking to enhance your catheterisation skills, this course will help you achieve your professional aspirations by all means. Aims and Learning Outcomes of this Catheterisation Training Course By the end of this catheterisation training course, you will: Grasp the entire process and methods of catheterisation Recognise the basic types of catheters Gain knowledge about the process of female and male urethral catheterisation Know where the post-procedure catheter should be placed Learn how to change and handle catheters properly Understand how to maintain catheter systems on a daily basis Know how to keep and maintain records Entry Requirements There are no academic entry requirements for this catheterisation training course, 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 Female and Male Catheterisation training course 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%. Upon successful completion of the coursework and assessments, you will be directed to the practical learning part which will be conducted face-to-face. The practical training is taken during weekends to ensure maximum attendance. You will be required to attend the training from our London-based office which will be specified to you during enrolment. Upon successful demonstration of catheterisation, you will be awarded a certificate that is accepted by thousands of professional bodies and government regulators here in the UK and around the world. Course Curriculum 1. Introduction to Catheterisation 2. Anatomy and Physiology of Urinary System 3. Methods of Catheterisation 4. Size of Catheters 5. Reasons for Catheterisation 6. Causes and Types of Incontinence 7. Male Catheterisation Procedure 8. Female Catheterisation Procedure 9. Post Catheterisation Care 10. Removing an Indwelling Urethral Catheter 11. Risks Involved with an Indwelling Catheter 12. Infection Control and Prevention 13. Record Keeping 14. Conclusion Recognised Accreditation 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. Certificate of Achievement Competency Certificate and Certificate of Achievement from Lead Academy You will receive a competency certificate after successfully completing the Part 2 of the phlebotomy course, which serves as confirmation that you are qualified to function as a phlebotomist without the need for close supervision. Also, on successful completion of the phlebotomy course, you will be eligible to obtain a CPD accredited PDF and Hardcopy 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.
Are you confident your organisation could cope if a bad news story went viral and you were besieged by the media? Would you be able to fend off a determined and aggressive journalist, take control and deliver your key messages? Our crisis communications courses show you how to cope when your organisation is under fire, and protect your good name. We can: Train your spokespeople to handle challenging interviews, pitting their wits against a hostile reporter Train your PR team to manage communications during an unfolding crisis Deliver a fast-paced crisis simulation where your team have to decide how to handle the press during an unfolding emergency Facilitate a crisis strategy workshop, where we work together to develop your crisis communications strategy All of our crisis communications courses are bespoke, so we will design each one to meet your specific needs. Areas we can cover include: How a crisis can escalate in seconds How journalists respond to bad news stories How to develop effective key messages & write holding statements How to manage your social media How to take control of an interview and get your message across How to handle press conferences and doorsteps Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.
Do you want to boost your medical career by learning about the cannulation process? This comprehensive cannulation course is ideal for you! You can learn about the whole venepuncture and cannulation procedure in this Venepuncture and Cannulation Training Course, as well as the safest methods for handling, flushing, and removing a cannula. This course will provide you with the necessary training to flourish in your profession, whether you are a novice or an experienced individual wishing to enhance your career in the healthcare industry. Course Highlights Designed by healthcare professionals Accredited by the CPD Certification Recognised and Valuable Certification Self-Paced Online Theoretical Learning High-Quality Study Materials Interactive practical training Practical Day Class Schedule – 1 Day Face-to-Face Training Venue Location London: Bank Studio, 23 Park Royal Road, NW10 7JH Date: 21st February, 2025 Date: 30th March, 2025 Date: 28th April, 2025 Date: 27th May, 2025 Date: 21st June, 2025 Time: 10:00 am – 05:00 pm Venue Location Birmingham: 83-85 Hagley Road, Birmingham, B16 8QG Date: 25th January, 2025 Date: 24th February, 2025 Date: 23rd March, 2025 Date: 21st April, 2025 Date: 26th May, 2025 Date: 26th June, 2025 Time: 10:00 am – 05:00 pm This extensive IV Cannulation Course covers the following credentials: Selection of veins for cannulation Arm and hand physiology and anatomy Types of cannula Process of cannulation Safety measures Proper insertion of the cannula Classroom-Based Cannulation Course Practical learning We offer comprehensive theoretical study materials and practical sessions for our cannulation training. As part of the practical training, you will receive practical dry lab demonstrations and hands-on experience to justify your role. Who is this Venepuncture and Cannulation Course for? This Venepuncture and Cannulation course is primarily aimed at: Health Visitors Healthcare professionals Nurses, midwives, pharmacists and doctors Freshers looking to begin their career in the healthcare sector Anyone looking to enhance their cannulation skills Aims and Learning Outcomes of this Venepuncture and Cannulation Training Course Know how to select the appropriate veins for cannulation Understand the anatomy and physiology of hands and arms Recognise the various sizes of a cannula Identify the risks concerning cannulation Know how to insert the cannula properly Recognise the safety precautions that should be maintained Gain knowledge about the dressing procedure Know how to safely flush and remove a cannula Learn how to securely dispose of all the sharps Learning how to perform Phlebotomy Trainingand Catheterisation Training can help you to provide better care to your patients. By being able to insert a catheter quickly and effectively, you can administer necessary treatments more efficiently, which can improve patient outcomes and reduce discomfort. Entry Requirements There are no academic entry requirements for this cannulation course, and it is open to students of all educational backgrounds. You need to join the Phlebotomy Training before attending the Cannulation Training. Assessment Method In this Venepuncture and Cannulation training, learners will be assessed via observation. That means during the practical training, you will be observed by the supervisor/trainer. Upon successful demonstration of blood sampling and blood draw, you will be awarded a CPD-accredited certificate accepted by thousands of professional bodies and government regulators in the UK and worldwide. Whether you are a fresher looking to kickstart your career in healthcare or practising healthcare looking to enhance your cannulation skills, this course will help you achieve your professional aspirations by all means. Course Curriculum 1. Cannulation Training - Course Introduction 2. What are Venepuncture and Cannulation 3. Anatomy and Physiology of the Circulatory System 4. Legal Aspects of Venepuncture (Phlebotomy) and Cannulation 5. Practitioner Requirements 6. Professional Competence and Accountability 7. Documentation and Record Keeping 8. Vicarious Liability 9. Consent 10. Influencing Factors during Venepuncture 11. Infection Prevention and Management 12. Haemolysis 13. Selecting Correct Equipment 14. Procedure of Venepuncture and Cannulation 15. Order of Draw 16. Peripheral Cannula and Venepuncture 17. Procedure Prior to Cannulation 18. During Cannulation 19. Cannula Size and Cannulation Aftercare 20. Removal of Cannulation 21. Complications 22. Cannulation Training - Conclusion Recognised Accreditation 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. Certificate of Achievement On successful completion of the cannulation course, you will be eligible to obtain a CPD-accredited 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.