1596 Courses in Edinburgh

Training for your dog. Whether they're starting from scratch, need a little refresher or a require a full boot-camp, my proven methods will bring you swift and permanent results.

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This update meets the recommendations of Public Health England and Public Health Wales National Minimum Standards and Core Curriculum for Immunisation Training of Healthcare Support Workers (2015).

Level 2 NVQ Diploma in Drilling Operations - Directional Drilling - Drill Rig Operator

This course is about learning to use your digital SLR camera with confidence and skill. Explore aperture, shutter speed and megapixels through to white balance, ISO ratings, histograms and much more! With a blend of technical tuition, demonstration, practical assignments and group discussion, you will discover how to unlock your camera’s full potential and take better pictures. If you don’t have a digital SLR we can often provide one for you – please select from dropdown at time of booking. You can also use your interchangeable or fixed lens system, mirrorless or rangefinder camera on this course. Bridge cameras without interchangeable lenses can be used too, but please note that they may not allow the full range of camera controls. Computer experience is beneficial. Day 1: Features of your Digital SLR camera. Areas covered include aperture, shutter speed and megapixels through to white balance, ISO ratings, histograms and all the rest. There will be time to ask questions and demonstrate the advantages of each feature, getting to grips with the “how’s” and “why’s” We will put into practise all the features that have been discussed and demonstrated in session one on a walk around town with your cameras. We will come back to the gallery, learn a little about methods of downloading and viewing photographs, and explore some basic Photoshop tools. Day 2: Exercises, Assignments and Review Question time. There will be a few formal exercises set up to practise on and time to discuss the elements learned in day one. We will also discuss in more detail the more compositional aspects of photography, and prepare for the afternoons’ assignment. You will carry out your assignments outside the gallery and be given a time to return with your completed assignments. Assignment presentations, troubleshooting and review. The last half will involve editing and viewing the photographs, open discussions and asking any final questions.   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

This is a practical ‘non medical’ day for front line practitioners working with children and young people with serious attachment issues arising from loss, trauma and abuse. We look at what Psychology may help us in our understanding of children who have faced issues with love and attachment. Splitting, handling projected feelings, constancy and permanence are explored. Online Course now available via Teachable Platform – Understanding Attachment Learn at your own pace… lots of text and video support Course Category Meeting emotional needs Behaviour and Relationships Inclusion Teaching and Learning Description This is a practical ‘non medical’ day for front line practitioners working with children and young people with serious attachment issues arising from loss, trauma and abuse. Drawing from the international research and literature and our own experience over many years as educational psychologists of the challenges of children with major social and emotional needs, we will explore together what the best practice can and could look like. We explore the language of attachment and outline very practical classroom strategies. We look at what Psychology may help us in our understanding of children who have faced issues with love and attachment. We explore the feelings of being on a desolate island of relational poverty or to imagine swimming with sharks. We explore the themes of violence, anxiety and experience of being a victim as young people grow older. We look at telling lies and explore how we can respectfully understand this. We reveal the new and innovative compass of vulnerability – the cognitive errors to which some are much more vulnerable. We look at triggers, self regulation and unpack a range of strategies.  Transference and counter transference are examined along with splitting, handling projected feelings, constancy and permanence. We explore what young people with these difficulties really need from us. We also spend time looking at the emotional impact on practitioners working with children with such needs and what helps at an personal and team level. We can all do something – we do not have to wait for expert therapists to arrive!  Testimonials Very moving presentation I will always try and think behind the behaviour now It had a huge impact on all levels We all seem to need it Belonging and feelings are so important Very user friendly Excellent! Learning Objectives Increased confidence regarding developing inclusive practice for children with serious attachment needs in mainstream schools Simple understandable explanation of attachment understood Access to a wider range of practical strategies to impact on social and behavioural needs Deeper understanding of core values surrounding inclusion of emotionally disabled children Opportunity to reflect on professional attitudes and behaviour towards parents and pupils with complex emotional needs New skills, scripts and processes to make inclusion successful Who Is It For ? Practitioners working in schools and other settings with children and young people of all ages Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions : How can we start to develop an understanding of children with attachment needs? What is the true impact of loss, trauma and abuse? What else can we do to go about including high profile children or young people with challenging emotional needs? What useful psychological constructs can we use to guide us? This course also explores practical strategies and language for key adults rebuilding relationships with individual pupils. This is a participative day that aims to be explorative and practical. Opportunities to develop empathy with the children of concern will be created.

CPCS A46 Piling Rig - Driven above 20 Tonnes

A47 Piling Rig - Bored below 20 Tonnes

A48 Piling Rig - Bored above 20 Tonnes

CPCS A45 Piling Rig - Driven Below 20 Tonnes