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
Active Antenatal classes from 14 weeks pregnant until birth. CubCare Active Antenatal is a weekly hypnobirthing and movement antenatal class for pregnant women and people in Welwyn Garden City and Hatfield. Now you can enjoy pregnancy, stay mobile with our yoga based movement, learn hypnobirthing techniques, meet new friends to share the journey and learn about your changing baby and body. All while preparing for a confident birth. A weekly pregnancy class combining pregnancy yoga, hypnobirthing and active birth education. Build your community through our weekly pregnancy classes that are designed to be continued throughout pregnancy.
This Skills for Care Endorsed & CPD accredited training has been designed for existing Social care Staff in line with CQC requirements. Delivered by experienced and professional tutors and trainers with over 25 years of combined experience.
This Skills for Care Endorsed & CPD accredited training has been designed for existing Social care Staff in line with CQC requirements . Delivered by experienced and professional tutors and trainers with over 25 years of combined experience.
Join our comprehensive CPD-accredited Palliative and End-of-Life Care course designed for Nurses and Healthcare Assistants (HCAs). This course offers in-depth training on symptom management, communication skills, ethical considerations, and family support. Perfect for professionals new to the field or with some experience looking to enhance their skills. Gain valuable knowledge and certification, with refreshments provided. Enroll now to provide compassionate and effective care to patients and their families.
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
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
Join our comprehensive face-to-face training course on Obstructive Lung Diseases designed for Registered Nurses (RNs) and Healthcare Assistants (HCAs). Enhance your skills in managing asthma, COPD, bronchitis, emphysema, bronchiectasis, and cystic fibrosis. Earn CPD-accredited certification from our Centre of Excellence. Enroll now! Are you a Registered Nurse (RN) or Healthcare Assistant (HCA) looking to deepen your knowledge of obstructive lung diseases? Our comprehensive face-to-face training course covers everything you need to know about asthma, COPD, bronchitis, emphysema, bronchiectasis, and cystic fibrosis. 🔹 Key Features: Engaging lectures and hands-on workshops Practical skills for effective patient care CPD-accredited certification from our Centre of Excellence Ideal for both new learners and as a refresher course 🔹 Why Enroll? Gain valuable insights into the pathophysiology, diagnosis, and management of obstructive lung diseases Learn from experienced professionals Improve your patient care techniques 🔹 Enroll Now! Visit our website for more details and to book your spot Don't miss out on this opportunity to enhance your professional skills!