938 Design courses in Tranent

A study day designed for HCAs who are working in a supportive role in primary care, offering care for patients with asthma. This day provides an overview of how asthma is diagnosed and managed and includes a practical inhaler delivery systems workshop.

A workshop designed specifically for healthcare professionals to meet the standards of the NHS Serious Incident Framework. The day will provide clinical leaders with practical skills to enable them to undertake a root cause analysis and develop an action plan in order to improve quality and safety in their clinical setting.

The emphasis is on competence, fitness to practice and life-long learning. Underpinning this is that clinical specialists and experts take the lead in teaching and training to develop knowledge and skills. However, not everyone has the tools to teach knowing how to is the key to successful learning, this programme is designed to Train the Trainer.

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

Body Sculpt is a medium-impact workout designed to strengthen, tone, and sculpt the body using a combination of body weight exercises and resistance bands. This dynamic class focuses on building lean muscle, enhancing endurance, and improving overall body definition through controlled, targeted movements. By engaging multiple muscle groups, Body Sculpt helps to increase strength, improve posture, and boost overall fitness levels. This workout is suitable for all fitness levels, as exercises can be modified to match individual abilities and goals. Whether you're looking to tone your arms, strengthen your core, sculpt your legs, or improve overall muscle endurance, this class provides a challenging yet accessible approach to full-body conditioning. Join us for a Body Sculpt class and take your fitness to the next level! With expert guidance, a supportive atmosphere, and a motivating routine, you’ll leave feeling stronger, more energized, and one step closer to your fitness goals. Egle is a fully qualified Level 3 (UK) Personal Trainer, Pilates Mat Teacher, Yoga Teacher, Sports Massage Therapist, Outdoor Fitness Instructor, and Group Exercise Instructor. Passionate about health, fitness, well-being, and nutrition, she firmly believes that the fitter and healthier a person is, the more enjoyable life becomes. Egle works with individuals of all fitness levels, from those who have never stepped into a gym or exercise class to those seeking their next challenge. Her main focus is to provide a diverse range of services tailored to meet various health and fitness needs. She is also deeply committed to injury prevention and rehabilitation, helping clients move safely and effectively toward their goals. This class is sponsored by Cash4Clubs, Sported and Flutter UKI It is FREE and is aimed at adults (particularly, but not only 18-25), women, etnic minorities, any individuals from low-income background. Suitable for all levels experience. By attending this class you release the teacher, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.

I've added this two day workshop because a one day workshop gives you the basics, but two days will allow you to develop your carving technique and use additional knife grasps.  By embedding good technique into the way you carve, you will avoid injuries and additional regular stretching will help you to look after your body. You will leave with the knowledge and confidence to carve safely at home.  You will have access to a range of different tools, starting with the axe to rough out spoon blanks - I have a good range of axes you can try from budget to the Gransfors large carving axe. Next using the Mora wood carving knives (105/106/120) to shape your blanks into spoons following traditional designs for optimising strength and utility. I also have a range of hook knives to try out. Using these traditional tools you will make a spoon from local and sustainable fresh cut green wood (usually willow/birch/alder or cherry) - starting with a log and leaving with a spoon. From the initial splitting of the log, trimming it down with an axe, to carving finer details and decorations with chip carving knives. This course is located close to central Edinburgh and is accessible by public transport.  Depending on the weather it can be inside or outdoors in the wildlife garden. Courses can also be arranged to suit your availability! Please email to discuss your requirements, discounts are available for small groups or multiple days. Course numbers are usually limited to five or less; individual training courses can also be arranged. What's included in the price? Tea, coffee, light lunch of bread and soup and snacks. Professional training in the use of a range of traditional tools. Advice on tool care and sharpening. Fresh cut (green) wood for carving. Some tools available for sale at competitive rates.  

This half day course is designed for those people working or volunteering in groups or working on projects who would like some practical tips on making their marketing and publicity more effective.

This half day course is designed for new treasurers, general trustees and management committee members or staff who work in smaller organisations to understand the basics of how to manage the finances within a voluntary or community organisation. It covers all the essential issues ranging from drawing up a budget to ensuring that the organisation has sound financial procedures.

This course, which can be run as a half day (3.5 hours) or a whole day course, is designed to help those who chair or participate in meetings to understand how to run effective meetings that are constructive, concise and actually achieve something! The course can be adapted to cover meetings in general or focus on specific types of meetings such as trustee, director or committee meetings, staff or project meetings.

This half day course is designed for voluntary and community organisations and those involved in community development who need to write funding applications and want to ensure that their bids are clear, focussed and meet the funders’ criteria.