8528 Courses

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. Tailored in company 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

Join Daniel Docherty and master stone-mason Nicholas G. Durnan for this week-long course where participants will learn the principles of Order in Space through a deep study and immersion in the five platonic solids. Daniel will lead the first two days where we will familiarise and befriend the forms as we draw, model and weave them in various ways and at various scales. The focus of the Thurs/Fri/Sat sessions will be on the carving of the forms in stone. It is likely that particpants will be able to carve a full set of all five 'Platonic' solids.

Clinical Risk Assessment and Documentation is facilitated by Registered Clinicians with extensive experience

Facilitated by Registered Clinicians with extensive experience

Facilitated by Registered Clinicians with extensive experience

This course provides a basic understanding of health & safety duties and responsibilities...

Managing Project Scope Although scope is just one part of a project's competing constraints, it has a direct bearing on your project's cost and schedule outcomes. In this course, you will explore and practice straightforward, specific tools and techniques required to effectively manage scope at each phase of the project life cycle. You will also discover common pitfalls and best practices that can significantly hinder or foster the probability of project success. Although scope is just one part of a project's competing constraints, it has a direct bearing on your project's cost and schedule outcomes. So effectively managing project scope is critical, requiring constant vigilance and discipline throughout the entire project life cycle. This especially includes the avoidance of scope creep, a major challenge to deliver successful projects. In this course, you will explore and practice straightforward, specific tools and techniques required to effectively manage scope at each phase of the project life cycle. You will also discover common pitfalls and best practices that can significantly hinder or foster the probability of project success. What you Will Learn At the end of this program, you will be able to: Recognize the relationships among project management deliverables, scope management, stakeholders, and project success Explain the spectrum of interactive processes and documentation impacting scope during the project life cycle Generate an inventory of common pitfalls and best practices during scope management phases Create and develop realistic deliverables reflecting critical phases of scope management, based on a real-world case study Foundation Concepts What is project scope? Project scope management Progressive elaboration and project life cycle Stakeholder management and communication Progressive Elaboration of Scope Progressive elaboration and SDLC example Elaboration process before project initiation Elaboration process after project initiation Developing the WBS, requirements document, & PSOW Monitoring and Controlling Scope Why project control? Project control process & the PM role Control scope Validate scope Project Closeout Project closure overview Close project or phase & scope management Evaluation and lessons learned

Empowering workers with the knowledge to safely move people, clients, residents or patients. What is moving and handling? In health and social care settings, regular tasks often involve the manual movement, lifting, or handling of people in your care. Our moving and handling training courses aim to instruct participants on the legislation, necessary skills and potential risks associated with the safe movement of people. This includes people’s mobility and the varying types of equipment and techniques you will come across. Why is moving and handling training important? There are an estimated 400 million hours of care delivered annually in the UK and these hours are gradually growing due to having and increasingly aging population, playing a crucial role in providing personal care and enabling individuals of all ages and backgrounds to maintain as much independence as possible. Carers frequently engage in lifting activities, which require correct training and experience to minimise the risk of short and long-term injuries to both the carer and the individual they support, as well as the potential for musculoskeletal disorders (MSDs). The operation of lifting individuals presents significant risks for both the supporter and the person being lifted in various social settings, including hospitals, care homes, leisure, and education. Poor lifting techniques and the use of incorrect equipment can exaggerate existing conditions for both parties, sometimes instantly. We offer an affordable alternative to training, with access to the latest techniques and equipment to assist you in your everyday working with individuals, aiming in providing best practice solutions to any hinderances you may come across.

Awareness of first aid for mental health: What will you learn? You’ll be surprised by how much you enjoy the 4-hour session. I always make sure the learning process is engaging, interactive and stimulating — so you won’t be bored. Most importantly, it’s a fascinating insight into a subject that’s often brushed under the carpet. It’s a flexible course, and I’m always happy to tailor the content. If there’s an aspect of mental health or addiction you’d like to know more about, please just ask. Here’s the 4-hour course content: Defining mental health, and understanding the stigma surrounding it Factors which affect mental health Roles and responsibilities of a first aider Outline of advice — What to say (and not to say) to someone with a suspected mental health condition Listening without judgement Knowing when to contact the emergency services Identifying signs of stress, and how stress can be managed How to implement a positive mental health culture in the workplace Identifying signs and symptoms of depression, suicide, psychosis, anxiety, self-harm, eating disorders Do bear in mind, this course can’t teach you how to diagnose and treat a mental health condition. That’s the responsibility of a healthcare professional. However, you’ll know where to signpost an individual who needs professional help. You’ll leave with the knowledge and confidence to approach, reassure and support someone when they need it most.

Level 2 NVQ Certificate in Highways Maintenance - Kerbs and Channels