995 Courses delivered Live Online

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

About this Virtual Instructor Led Training (VILT)  Accredited by the United Kingdom Lubricants Association (UKLA), this 4 half-day Virtual Instructor Led Training (VILT) course will provide an in-depth understanding of the principles, economics and flexibility of lubricant blending plants and how to operate a lubricants blending plant efficiently and economically. The latest developments and trends in lubricant blending and the advantages and disadvantages of lubricant blending equipment, facilities and operations will be discussed. The importance of testing components and products for each blend, lubricant blend quality control and product quality management will also be explained. The VILT course will also clarify the importance of lubricant product filling, packaging and warehouse storage, strategies for optimising existing lubricant blending plant facilities and how to avoid or minimise problems with lubricant blending and product quality. The VILT course is recognised under the UKLA Continuing Professional Development (CPD) scheme for Registered Lubricant Professional. *There will be an examination for this VILT.   Training Objectives This VILT course will enable you to: Learn about Mineral Oil Base Oils; API Groups I, II and III: Properties and Characteristics Acquire the knowledge about Synthetic Base Oils; API Groups IV and V: Properties and Characteristics Learn about Lubricant Additives: Properties and Characteristics Know the Lubricant Formulation and Ease of Blending Explore the Blending Plant Design: Grassroots Plants and Upgrading Existing Plants Learn about Blending Plant Equipment and Facilities and Their Operation Understand the Lubricant Blending Issues: Avoiding Problems Test and Analyse Base Oils and Additives Test and Analyse Blended Lubricants Explore the importance of Product Quality Control Understand the process of Lubricant Packaging and Filling Understand the process of Lubricant Storage Learn about Product Quality Management Target Audience This VILT course will be useful and applicable for: Middle and Senior managers to understand how and why to design and operate an efficient and profitable lubricant blending plant. Blending plant operators and specialists to improve and optimise current blending plant operations. Manufacturers of lubricants will understand how and why high quality components and effective testing during the entire blending process are important to final lubricant product quality and performance. Lubricant formulators will understand the importance of close communication and co-operation with blending plant managers and operators to minimise blending costs and to thereby maximise product profitability. Course Level Intermediate Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader (CChem, MRC) has worked as Sales, Technical Marketing Manager and Company Director with over 50 years of broad experience in the lubricants, fuels, petroleum additives, with four leading companies Chevron, Ethyl Petroleum Additives Ltd, Texaco Limited and Kuwait Petroleum (GB) Ltd. His major recent responsibilities have been concerned with leading the Oil Industry Association United Kingdom Lubricants Association, and acting in an advisory capacity as Technical Director to the Association. He has acquired a wide experience in technical, marketing and sales within the oil industry. The related experience gained with the oil additives industry has provided him with special additional insights. He has also led the Certificate of Lubricant Competence course for the United Kingdom Lubricants Association (UKLA) for 11 years. He is a Chartered Chemist and a Member of the Royal Society of Chemistry. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

What is NLP? Join proactivenlp.com on this virtual workshop and find out how NLP can start changing your life by saying goodbye to the negatives and welcoming in all the positives you want.

Designed to help individuals and their organisations develop new products, services and ways of working to create sustainable value. The EFQM Innovation Leader Training is designed to help individuals and their organisations understand what innovation means for them and challenge them to focus on developing new products, services and ways of working to add new value. The training will focus on how to: Develop your understanding of innovation and how it can be successfully implemented using a structured innovation management approach Demonstrate the ability to effectively manage innovation activities to achieve the intended outcomes Course Content Overview of the EFQM Lens Concept Introduction to Innovation Lens Groupwork – Megatrends and how they impact on you Innovation Lens Framework – Structure and Content Groupwork – Completion of Innovation Questionnaire Discussion – Feedback on the Questionnaire and Outcomes How to manage the Innovation process Using Assess Base to baseline performance/conduct a gap analysis Pre-course Work Pre-reading on the new EFQM Model. Delivery The course is delivered through virtual trainer led live workshop. Upon registration, you will receive a link to the workshop. Cost £450 + VAT which includes the training course, the Innovation Lens e-book and your EFQM Innovation Leader Certificate. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Designed to help individuals and their organisations develop new products, services and ways of working to create sustainable value. The EFQM Innovation Leader Training is designed to help individuals and their organisations understand what innovation means for them and challenge them to focus on developing new products, services and ways of working to add new value. The training will focus on how to: Develop your understanding of innovation and how it can be successfully implemented using a structured innovation management approach Demonstrate the ability to effectively manage innovation activities to achieve the intended outcomes Course Content Overview of the EFQM Lens Concept Introduction to Innovation Lens Groupwork – Megatrends and how they impact on you Innovation Lens Framework – Structure and Content Groupwork – Completion of Innovation Questionnaire Discussion – Feedback on the Questionnaire and Outcomes How to manage the Innovation process Using Assess Base to baseline performance/conduct a gap analysis Pre-course Work Pre-reading on the new EFQM Model. Delivery The course is delivered through virtual trainer led live workshop. Upon registration, you will receive a link to the workshop. Cost £450 + VAT which includes the training course, the Innovation Lens e-book and your EFQM Innovation Leader Certificate. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

About this Training Course This course will provide a comprehensive, foundational content for a wide range of topics in power system operation and control. With the growing importance of grid integration of renewables and the interest in smart grid technologies, it is more important than ever to understand the fundamentals that underpin electrical power systems. Training Objectives Basic Terminology and Concepts of Electrical Systems: Gain an understanding of the basic terminology and concepts of electrical systems and the structure of a power system Transmission Line Parameters: Learn in detail all the transmission line parameters including line resistance, line inductance, transposition of transmission lines, and capacitance of transmission lines Insulators: Understand thoroughly all the various types of insulators, pin type insulators, suspension type or disc insulators, strain insulators, and testing of insulators High-Voltage Direct Current Transmission: Determine the advantages and disadvantages of high voltage direct current transmission, and gain an understanding of all the features of high-voltage direct current transmission Substations and Neutral Grounding: Gain a detailed understanding of all substation equipment, factors governing the layout of substations, station transformers, elements to be earthed in a substation, power system earthing, earthing transformers, bus bar arrangements and gas-insulated substations Distribution System: Learn about the effects of voltage on the conductor volume, distributor fed from one end, distributors fed from both ends at the same voltage, distributors fed from both ends at different voltages, and alternating current distribution Circuit Breakers: Learn about the classification of circuit breakers, plain-break oil circuit breakers, air break circuit breaker, air blast circuit breakers, vacuum circuit breakers, SF6 circuit breakers, rating and testing of circuit breakers Relaying and Protection: Learn all the requirements of relaying, zones of protection, primary and backup protection, classification of relays, electromagnetic relays, induction relays, feeder protection, phase fault protection, reactance relay, static overcurrent relay, differential protection, transformer protection, Buchholz relays, alternator protection restricted earth fault protection, rotor earth fault protection, and negative-sequence protection Economic Operation of Power Systems: Gain an understanding of steam power plants, heat rate characteristics and characteristics of hydro plants Load Frequency Control: Learn about speed governing mechanism, speed governor, steady state speed regulations and adjustment of governor characteristics Voltage and Reactive Power Control: Gain an understanding of impedance and reactive power, system voltage and reactive power, voltage regulation and power transfer Renewable Energy Sources: Learn about solar power, wind power, geothermal energy, biomass and tidal power Restructuring of Electrical Power Systems: Gain an understanding of smart grids, smart grid components, smart grid benefits, and open smart grid protocol Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

The Alternative Energy Technology Course is a practically based alternative energy course designed to give participants an understanding of alternative energy options and provide them with that practical knowledge and skills to build solar to electric and wind to electric systems at a foundation level. The course is designed to be of benefit to people either working or intending to work as:- Alternative Energy Installers or anyone just wishing to gain practical knowledge of Practical Alternative Energy Systems

  Delivered in either Live Online (4 days) or in our Classroom (5 days), the ISO/IEC 27001 Lead Auditor training enables you to develop the necessary expertise to support an organization in establishing, implementing, managing and maintaining an Information Security Management System (ISMS) based on ISO 27001. During this training course, you will acquire the knowledge and skills to plan and carry out internal and external audits in compliance with ISO 19011 and ISO/IEC 17021-1 certification process. About This Course   Based on practical exercises, you will be able to master audit techniques and become competent to manage an audit program, audit team, communication with customers, and conflict resolution. After acquiring the necessary expertise to perform this audit, you can sit for the exam and gain the "ISO/IEC 27001 Lead Auditor' credential. By holding this Lead Auditor Certificate, you will demonstrate that you have the capabilities and competencies to` audit organizations based on best practices.   The training course is based on both theory and best practices used in ISMS audits Lecture sessions are illustrated with examples based on case studies Practical exercises are based on a case study which includes role playing and discussions Practice tests are similar to the Certification Exam   The course is delivered both as a Live Online or Classroom environment, as follows; Day 1: Introduction to Information Security Management Systems (ISMS) and ISO/IEC 27001 Day 2: Audit principles, preparation and launching of an audit Day 3: On-site audit activities Day 4: Closing the audit and Examination   Learning Objectives Understand the operations of an Information Security Management System based on ISO/IEC 27001 Acknowledge the correlation between ISO/IEC 27001, ISO/IEC 27002 and other standards and regulatory frameworks Understand an auditor's role to: plan, lead and follow-up on a management system audit in accordance with ISO 19011 Learn how to lead an audit and audit team Learn how to interpret the requirements of ISO/IEC 27001 in the context of an ISMS audit Acquire the competencies of an auditor to: plan an audit, lead an audit, draft reports, and follow-up on an audit in compliance with ISO 19011   The exam covers the following competency domains:   Domain 1: Fundamental principles and concepts of an Information Security Management System (ISMS) Domain 2: Information Security Management System controls and best practices based on ISO/IEC 27002 Domain 3: Planning an ISMS implementation based on ISO/IEC 27001 Domain 4: Implementing an ISMS based on ISO/IEC 27001 Domain 5: Performance evaluation, monitoring and measurement of an ISMS based on ISO/IEC 27001 Domain 6: Continual improvement of an ISMS based on ISO/IEC 27001 Domain 7: Preparing for an ISMS certification audit Prerequisites   A foundational understanding of ISO/IEC 27001 and knowledge of audit principles.    What's Included?   Refreshments & Lunch (Classroom only) Course Slide Deck Official Study Materials CPD Certificate The Exam   Who Should Attend?   Auditors seeking to perform and lead Information Security Management System (ISMS) certification audits Managers or consultants seeking to master an Information Security Management System audit process Individuals responsible for maintaining conformance with Information Security Management System requirements Technical experts seeking to prepare for an Information Security Management System audit Expert advisors in Information Security Management Our Guarantee   We are an approved IECB Training Partner for all of our courses. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training and exam retake offered Accreditation Assessment     Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question, essay type exam on Day 4 of the course. The overall passing score is 70%, to be achieved within the 240 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success.   Provided by   This course is Accredited by NACS and Administered by the IECB

This 2 hour digital training session is CPD accredited. It utilises lived experience and a filmed version of our acclaimed theatre production MOCKINGBIRD HIGH - a compelling and lyrical account of the devastating impact of domestic abuse on two teenage children and their mother. Plus interactive activities, group discussion to explore the relevance to your work practice and a support pdf.

Elevate Your Learning Journey with HRB Education - Where Potential Meets Excellence