549 Courses in London

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

The ability to influence others is a life skill but also one that has never been so critically useful at work. This one day workshop will set you on the road to discover what you need to be able to think and do that will help you take people with you. This involves learning some new tools and strategies that fit the situation you are in and making sure you use the right skills and behaviours to influence well, whether it is a single person or a room full of cynical expectant people! This workshop will enable you to: Learn about and understand influencing styles and strategies available and formulate plans and ideas on how to use them in influencing situations Understand which skills and behaviours to use to be the most effective influencer Have greater confidence in situations where they need to influence someone Use thinking, speaking and behavioural techniques that enable influencing to be effective and positive Review and evaluate learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions & getting to know you and why you are here Course objectives 2 Personal objectives Introducing a learning diary 3 Gallery exercise - using images of exemplars brought by participants Plenary discussion The skills and behaviours of an exemplar influencer 4 Group task - what does your self-evaluation say? Discussion and conclusions 5 Influencing - what is it? - why do we need it? The current organisational landscape including values and behaviours the influencer operates in 6 Pit Stop - 'pull / push', 'the lost horse' and 'talking at' 7 Direct / support / delegate / coach: the different choices and approaches to choose from 8 Updating the learning diary 9 Power and types of power - its impact on influencing ability and approach and what is within your control Group task and discussion 10 The 5 influencing styles tool Series of tasks and exercises Drilling down to a personal action plan for maximising influence 11 'The person with the most flexibility has the most influence' Skills and behaviours for effective influencing Exercises and techniques that develop skills for influencing 12 Review and evaluation Action planning

Learn how to design and create your own river table.

A masterclass in devising therapeutic metaphors This inspiring online training day gives you powerful, non-intrusive ways to help distressed young people – and others – overcome difficulties in their lives – the skills you will learn can also be used with adults Accredited CPD: 6 hours Length: 1 day (9.15am - 4.00pm GMT) LIVE ONLINE – Join Pamela Woodford live online on Tuesday 18th June 2024 for this enjoyable, experiential CPD accredited training day – you will have plenty of opportunities to ask questions, take part in exercises to practice the steps involved, come up with pertinent metaphors and create your own story. Limited numbers. BONUS RECORDING – you will also get a recording of the tutor sessions for a limited time afterwards to maximise your learning. >> If you can’t make this date please register your interest below and we’ll let you know as soon as a new date is available. Fantastic online training, engaging and thought-provoking throughout. The confidence Pamela has given me will impact positively on my everyday practice, I am truly inspired...PSYCHOTHERAPIST Why take this course Children’s natural affinity with stories gives us an incredibly powerful, non-directive way to help emotionally distressed and abused young people, who can sometimes be hard to reach in any other way. On this practical live training event you will learn how to tap into your own metaphorical brain to create therapeutic stories and metaphors ‘in the moment’ that are appropriate to each individual’s circumstances and experiences. Throughout the day Pamela – a master storyteller and highly experienced psychotherapist – draws on her own case histories, metaphor and story examples as she guides you through the steps involved in ‘thinking on your feet’ and creating a story yourself in the moment. By the end of the day you will have lots of new, innovative ways to engage with and help distressed children deal with the experiences they have had – whilst also offering them hope, understanding, and new ways of thinking and feeling about life and themselves. Indeed, you may well be surprised at how quickly positive psychological changes occur as a result of the stories you will create and tell ‘in the moment’. Stories also play a crucial role in child development – through the ways the different characters think, act and overcome difficulties, children gain important templates for understanding the world and dealing with the challenges and situations they will meet in life – both now and in the future. They are a wonderful way to help build resilience. Storytelling and the careful use of therapeutic metaphor are crucial elements of successful counselling and psychotherapy – they help bypass assumptions and rigid thinking to offer a new, broader way of looking at things, awaken innate resources and offer crucial hope – just what struggling children need… Wonderful, interactive online course. Pamela is a joy to listen to – I learnt so muchCOUNSELLOR What will you learn A clear understanding of how to address emotional issues in children Simple ways to calm and relax children – “it’s the way you tell ‘em” Tips for igniting your own imagination and creativity How to ‘think metaphor’ to find the right one for each situation A step-by-step guide to creating your own stories – the 6 steps for creating short stories with metaphors specifically tailored to quickly bring about positive psychological changes in children and young people Breathing life into inanimate objects and taking inspiration from nature – how to tune into your metaphorical mind Valuable experience in creating your own therapeutic story from scratch How to use your stories and metaphors The importance of paying attention to the words children use when telling you something Case histories which illustrate the effectiveness and flexibility of stories – and show why they are such powerful therapeutic tools, even with difficult cases How to find your own metaphors and connect them emotionally to distressing situations Using embedded suggestions in stories – exercise Different ways to use therapeutic stories, such as those in Pamela’s acclaimed Brighter Little Minds series, to develop emotional literacy The importance of incorporating all of our senses How to adapt stories to use with adolescents and adults Tips for thinking creatively ‘on your feet’ to come up with suitable metaphors and ideas there and then in the moment Flexible skills that can easily be adapted to working with adults Why subtly entwining a child’s interests into a story makes its impact stronger How to introduce a story or therapeutic metaphor naturally into your conversation Feedback on the story you create and time to ask questions of the tutor – a highly experienced and creative psychotherapist who has spent decades working therapeutically with distressed children and young people A greater appreciation of the subtle power of metaphor, imagination and embedded suggestions and how to use them to help the young people you care for Increased confidence in creating and telling therapeutic stories yourself A variety of story examples and ‘scripts’ Lots of new ideas from Pamela Woodford’s ‘treasure chest of healing spells’ to spark your own creativity Tips for improving your own storytelling abilities Such a helpful live online training day – the use of metaphor via story form is a powerful toolHEAD OF BEHAVIOUR SUPPORT SERVICE – EDUCATION Course Programme The ‘How to create healing stories for distressed children’ live online workshop starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am What can go wrong for children? How stories can help 11.00am Comfort break and discussion 11.10am Using metaphor, relaxation, imagination and embedded suggestions 1.00pm Lunch break 1.40pm Setting the scene and creating the story 3.10pm Comfort break and discussion 3.20pm Sharing the stories you have created 4.00pm Day ends Who is this course suitable for? Anyone working with emotionally distressed children or young people, including: Psychotherapists, therapists and counsellors Teachers and educational professionals Childcare and healthcare professionals (and students) Foster carers Adoptive parents – and perspective adoptive parents Social workers Parents and carers Interested friends or family who wish to help a young person they know And anyone who would like to attend for personal reasons 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.

– a psychotherapy skills masterclass The language we use has a huge impact on others – on this practical, inspiring course you will learn how to combine solution-focused techniques and effective language skills to help relieve distress and improve outcomes, as quickly as possible… Accredited CPD Certificate : 12 hours Length 2 days (9:30am - 4:00pm) Excellent course! I’ve learnt so much and been inspired so much. Gareth has a wonderful style of delivery...MARY FLYNN This course is suitable for anyone working with adults, teens or children – the knowledge and skills you will gain have a wide range of applications in addition to therapy and counselling, including coaching, healthcare, teaching, motivation, overcoming resistance, emotional turmoil and much more. You will leave with a powerful toolkit of precisely-targeted and creative therapeutic language skills, as well as a range of effective brief therapy strategies. These can be easily tailored to any individual and used to successfully help people resolve a wide range of conditions and problems as quickly as possible. If you want to be more effective in what you do, these are core skills to have… Denise Winn previously taught this course, it is now delivered by Gareth Hughes Why take this course Language is key to everything we do – being aware of the power of language to help or do harm is essential when we’re trying to help people. Knowing how to use it well can make all the difference to a successful therapeutic outcome. Paying attention to the language we use is central to the human givens approach to therapy and counselling: our choice of words is crucial in building rapport with people, learning more about someone – their unique qualities and abilities – in listening and responding, in providing motivation and in collaborating to agree goals and strategies for the effective resolution of their problems. The careful use of language is essential for other areas of life too: at work, home, with family and friends – and this 2-day course is accessible to all. It can be taken as part of the Human Givens Diploma or as a stand-alone course. You will gain a solid foundation in the most effective brief solution-focused strategies and language skills that are essential if you want to be able to help people as quickly as possible. By distilling the essence of proven brief therapy approaches and working in tune with the givens of human nature, outcomes can be dramatically improved and suffering successfully reduced. You will also learn how any team of professional healthcare workers can safely incorporate brief therapy techniques into their work with patients suffering from depression, anxiety, panic attacks, PTSD, anger, OCD, eating disorders, addiction and relationship/marital/family problems, thereby improving outcomes and reducing suffering on an even wider scale. Good to know This course gives you essential skills that are used in the successful treatment of a wide range of conditions, such as anxiety disorders, depression, addictions, self-harm, OCD and the rewind technique for treating trauma and phobias. They are also fundamental skills to have when using guided imagery and visualisation. This course is an essential component of Part 1 of the HG Diploma. I feel very excited and energised. I can't wait to start using these techniques...OCCUPATIONAL THERAPIST What will you learn The essential skills needed for successful brief therapy New information about the APET™ model – why it is so important to construct therapy that is in tune with our how brains work (our emotional reactions come first) – this speeds up therapy and explains why purely cognitive and behavioural approaches can take so long An ability to get to the root of the matter quickly by establishing which innate needs are not being met and why (the essence of effective brief therapy) Quick rapport building skills How to use the RIGAAR™ structure to improve therapy outcomes Reflective listening and reflective reframing How to use therapeutic language skills directly and indirectly to initiate change Ways to use solution-focused questioning to create a framework for change How to identify and use your client’s own life resources An understanding of why the human givens approach dramatically increases the likelihood of therapy being brief, regardless of the presenting problem A range of psychological interventions to use with common psychiatric problems: anxiety, panic attacks, depression, intrusive thoughts, relationship difficulties and so on Promoting cooperation by developing realistic and achievable goals How to identify exceptions (when the problem doesn’t occur) and get the patient to take credit for them How to generate motivation for change in your patients Separating the patient’s core identity from their problem How to minimise or overcome resistance How not to be drawn in to a client’s negative self-view Great use of case histories to illustrate the skills covered How to use the psychological laws of positive expectancy and concentrated attention An understanding of why taking this collaborative human givens stance, reduces stress and pressure on you Plenty of opportunity to consolidate what you are learning by practising the skills yourself How is the course structured? Held over two consecutive days, this skills-based practical workshop combines a blend of talks, demonstrations and exercises. Each day starts at 9.30pm and finishes at 4.00pm, with 2 breaks for networking and refreshment and 45 minutes for lunch. Course notes, refreshments and lunch are included on both days. Who is this course suitable for? You and your patients will benefit enormously from you attending these two days. If you are a counsellor, psychotherapist, clinical psychologist, mental health nurse, GP, doctor, nurse, OT, physiotherapist, youth worker, social worker, health visitor, support worker or any other caring professional, and wish to be more effective in what you do, this course gives you the perfect opportunity to discover new, subtle but highly effective skills with plenty of time to practise to help you assimilate them into your own work. Many other professions – such as educational and business professionals – also find the skills and information covered highly applicable to and beneficial for their own work. It is also suitable for anyone who is thinking of a career in this field as these are core skills needed for successful brief, solution-focused psychotherapy. This course has been independently accredited by the internationally recognised CPD Standards Office for 12 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

NLP Business Diploma - The Fundamentals of Collaborative Relationships training & certification with Proactive NLP Ltd is your first step towards developing collaborative leadership and collaborative cultures. Start transforming your projects now!

Mix your Own Palette and create a set of coasters & a decorative tray while enjoying delicious pizza and Italian craft beers!

Based in London, UK Creature Courage is the UK's animal phobia expert, get over your animal phobia in a fun way in just one afternoon!

Intelligent Yoga Teacher Training (IYTT) is unique amongst teacher training courses. We offer an incisive, thoughtful and intelligent approach to yoga teacher training, driven by the most current scientific developments in anatomy and movement research. Delivered by an elite group of senior yoga teachers at the top of their field, IYTT offers a spacious, immersive modular structure which provides time and space for profound learning, integration and growth. Each of the teaching team draws on decades of practical experience of yoga, including particularly the work of Vanda Scaravelli and somatic, embodied practices.

Take your sales people from average to high performance. Motivate and develop experienced sales professionals with some new insights and learning. Applying NLP principles, techniques and models, this workshop will introduce the core attitudes and behaviours that differentiate the excellent sales person from the average one. The programme will help participants: Understand and adopt the mindset and beliefs needed for sales excellence Build rapport and connect with buyers at a deeper and more personal level Recognise some of the thinking and language patterns that make each individual unique Ask powerful questions to further understand the unique world of the individual and how they make decisions Apply tools and techniques to empathise with clients - seeing things from their perspectives Tailor their sales approach to the individual buyer's style, and talk in their language Influence with integrity and sell to organisations and individuals successfully 1 Introduction Aims and objectives of the programme Personal introductions and objectives Workshop overview 2 An introduction to NLP and sales excellence with NLP An overview of NLP and applying it to selling The pillars of NLP The NLP model of communication The difference that makes the difference 3 Building enhanced rapport Defining rapport and why it is important when selling Going beyond the initial small talk Building relationships with individual decision-makers Matching and mirroring Levels of rapport 4 Understanding the buyer's personal buying map How we take in, filter and process information How we judge others based on our own experiences of the world The different ways in which we communicate when selling Recognising and understanding the language and thinking patterns of others Adapting your sales communication style to different buyers 5 Making sense of the buying process How we filter information through our senses Understanding how we see, hear and experience the world Visual, auditory and kinaesthetic buyers Listening for key insights What different buyers want from you to help them to buy Applying sensory awareness to the sales process 6 Successful sales mindset The connection between thoughts and actions The sales beliefs of excellence Identifying negative thoughts and beliefs that are holding you back How to change your mindset Adopting the sales beliefs of excellence 7 Powerful questions Reviewing and honing your questioning skills Understanding the questions that great sales people ask Avoiding assumptions Clean language questions Getting to the bottom of it - precision questions Turbo-charging how you qualify 8 Influencing with integrity Understanding empathy Stepping into the buyer's shoes Speaking the buyer's language Tailoring your sales approach to the individual Match, pace, lead - how to take your buyer with you 9 Putting it all together Personal learning summary and action plans