225 Courses in Coventry

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

Our 8 hour course will enable students to attain the knowledge and practical competencies needed to deal with a range of emergency first aid situations and/or take on the role of emergency first aider in the workplace. At Immerse Training we specialise in bespoke on-site courses, delivered at your premises, based on your industry. Qualification Information This qualification and learning outcomes are based on the recommendations of: The Resuscitation Council (UK) Skills for Health Assessment Principles for First Aid Qualifications Course Content Following this course students will: Understand the role and responsibilities of a first aider. Be able to assess an incident. Be able to manage an unresponsive casualty who is breathing normally. Be able to manage an unresponsive casualty who is not breathing normally. Be able to recognise and assist a casualty who is choking. Be able to manage a casualty with external bleeding. Be able to manage a casualty who is in shock. Be able to manage a casualty with a minor injury. Who should attend? This qualification is for people who deal with first aid at work enabling them to be workplace emergency first aiders under the Health and Safety (First Aid) Regulations 1981. This qualification is also for people who have a specific responsibility at work, or in voluntary and community activities, to provide basic first aid to people in a range of emergency first aid situations. Pre-requisites Students must be at least 14 years old on the first day of training. Assessment and Certifications Assessment of this course is continuous and also includes 1 theory/multiple choice question paper. Successful students will receive an Immerse Training Certificate, which is valid for three years. This certificate will be issued by Qualsafe, the awarding body for Immerse Training. Additional Information Completion of the Level 3 Award in Emergency First Aid at Work includes 1 credit at Level 3 of the Regulated Qualifications Framework (RQF). Workplace First Aid Courses First Aid courses for employers and employees. Our workplace courses are fully accredited, registered and meet Health and Safety Executive (HSE) guidelines. From 1 day Emergency First Aid at Work (previously appointed person) to 3 day First Aid at Work courses. We specialise in on-site courses at your workplace, tailored to the specific risks associated with your business.  All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

This short course will aid contracting, procurement and sales professionals in understanding the essential principles of terms and conditions that are the vital components of any contract.

Commission an original, traditional and quirky Portrait in oils, acrylics or digital sketches

Our 8 hour course will enable students to attain the knowledge and practical competencies needed to deal with a range of emergency first aid situations when looking after children. In addition to the topics covered on an emergency first aid at work course, this course covers treatment for a variety of injuries and medical conditions. For more information click on the tabs below, or get in touch, we’d be more than happy to answer any queries. At Immerse Training we pride ourselves on offering First Aid and Pre-Hospital Care Training that meets your specific needs. All our courses meet the requirements of the relevant awarding body. On top of that, we are more than happy to create bespoke elements that tailor each programme to suit your first aid or care responsibilities. Qualification Information Upon completion students will have developed the skills and knowledge needed to provide effective emergency first aid to children and babies. This qualification and learning outcomes are based on the recommendations of: The Resuscitation Council (UK) Skills for Health Assessment Principles for First Aid Qualifications Course Content Following this course students will be able to Understand the role and responsibilities of the paediatric first aider. Be able to provide first aid for an infant and a child who is choking. Be able to assess an emergency situation safely. Be able to provide first aid to an infant and a child with external bleeding. Be able to provide first aid for an infant and a child who is unresponsive and breathing normally. Be able to provide first aid to an infant and a child who is suffering from shock. Be able to provide first aid for an infant and a child who is unresponsive and not breathing normally. Understand how to administer first aid to an infant and a child with bites, stings and minor injuries. Who should attend? This qualification is for anyone who cares for children and babies; including parents, guardians, grandparents or people who have a professional involvement with children and babies. Pre-requisites Students must be at least 16 years old on the first day of training. Assessment and Certifications Assessment of this course is continuous and also includes 1 theory/multiple choice question paper. Successful students will receive an Immerse Training Certificate, which is valid for three years. This certificate will be issued by Qualsafe, the awarding body for Immerse Training. Additional Information Completion of the Level 3 Award in Emergency Paediatric First Aid at Work includes 1 credit at Level 2 of the Qualification Credit Framework (QCF). Paediatric First Aid Courses First Aid courses for individuals and workplaces who provide care to or work with children and young people. Our paediatric courses are fully accredited, registered and meet Health and Safety Executive (HSE) and OFSTED guidelines. From 1 day Emergency Paediatric First Aid to day Paediatric First Aid courses. We specialise in on-site courses at your workplace, tailored to the specific risks associated with your business. All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.

EFT Tapping Course NE38 7SA – Your Level 1 EFT Workshop – FREE 6 months email support – Fully Experiential Class

Small Class Sizes – EFT Tapping Course Online on Zoom – Every Therapist, Hypnotherapist, Counsellor, Parent, and Teacher needs to learn EFT Tapping – Or For Your Own Self-Development – Dip your toe in the water with just Level 1, or go for the whole thing, scroll down for details and amazing Early Bird Rate

Course Details: The level 1, 2 & 3 hybrid and electric vehicle mechanic courses include; Classroom based theory session Workshop practice session Examination and assessment Course Fees: Level 1 £160 + VAT per candidate Level 2 £396 + VAT per candidate Level 3 £659 + VAT per candidate Electric & Hybrid Course Information: IMI LEVEL 1 AWARD IN EV AWARENESS This programme is designed for individuals who may encounter electric/hybrid (all variations) vehicles and require safety awareness. It is suitable for non-technical people working in roles such as: Valeters Parts Sales and aftersales It is also suitable for individuals working in roles such as: Vehicle recovery Vehicle dismantlers Vehicle damage assessors Electric/hybrid professional vehicle drivers.   LEVEL 2 AWARD IN ELECTRIC/HYBRID VEHICLE ROUTINE MAINTENANCE ACTIVITIES  This award is designed for technicians who maintain and repair electric/hybrid vehicles. It contains the skills and knowledge required to work safely around a vehicle’s high & low voltage electrical system and electric drive train system, whilst carrying out repairs or maintenance. As a result, learners successfully completing this qualification will acquire significant core knowledge and skills and the ability to work safely around and maintain Electric/Hybrid vehicles.   LEVEL 3 AWARD IN ELECTRIC/HYBRID VEHICLE REPAIR AND REPLACEMENT The content of this qualification has been designed to give the learners the knowledge and skills required to work safely on Electric/Hybrid vehicles whilst carrying out diagnostic, testing and repair activities. This may include vehicles that may have or had damage to their high energy/electrical system. As a result, learners successfully completing this qualification will acquire significant core knowledge and skills, and the ability to remove and replace Electric/Hybrid vehicle high voltage components Entry Requirements The selection criteria for entry should take into account each applicants existing academic/vocational qualifications and experience. Level 1 EV awareness There is no eligibility requirement. Level 2 electric & hybrid vehicle training course Individuals will already have vehicle maintenance and repair knowledge and skills at level 2. Level 3 electric & hybrid vehicle training course Individuals will already have vehicle maintenance and repair knowledge and skills at level 3. Candidates who already hold the EV Level 2 qualification can do a one-day Level 3   Assessment In order to pass these qualifications, learners must demonstrate its learning outcomes by following and achieving its assessment components: a. IMI External Testing (online) b. IMI Practical Assessment What’s included: Support from fully qualified and experienced trainers Course training material Registration with the awarding body Examinations Fees and Certification To find out more, please use the live chat function, visit our contact page or call us on 024 76325880   Get up to speed with industry changes The automotive industry is constantly changing, but more so than ever before. The shift to electric vehicles is only going to continue to grow as environmental and consumer needs change. As hybrid and electric vehicles become more and more mainstream, mechanics/technicians must have the right skills and knowledge to keep up with new technologies and the demand for their maintenance and repair. This course is designed to teach you how to safely and effectively work on hybrid and electric vehicles as well as keep up with the constantly evolving technology. Upon completion of this electric vehicle training course, technicians will be able to demonstrate they have the skills and knowledge needed for repairing vehicles with high voltage hybrid and electrical technologies. Future-proofed skills As more consumers make the shift to hybrid and electric vehicles, the demand for knowledgeable mechanics is increasing exponentially. This new market is ideal to expand your customer base and grow your business. Safety is always the number one priority for any vehicle technician, this course will teach you how to approach an electric vehicle and work on it safely. Our experienced instructors will teach you invaluable skills such as disengaging battery cells and the different hazards associated with high-energy electricals. Electric vehicles are quickly becoming a common sight on UK roads and will soon be the new normal, ensuring you get ahead of the trend with our electric car mechanic course means you will be ready for when the vast majority of your customers are in these types of cars.