11119 Courses

Microsoft Access training course description A hands on course providing a solid grounding in Microsoft Access. What will you learn Use and customise the Microsoft Access environment. Select, use and customise queries. Define tables. Design forms and reports. Recognise the use of macros. Microsoft Access training course details Who will benefit: Anyone wishing to work with Microsoft Access. Prerequisites: Database fundamentals Duration 3 days Microsoft Access training course contents Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. Macros Introduction to macros.

Learn the safe and precise technique of microsuctioning for earwax and foreign object removal with our comprehensive course for healthcare professionals.

An introduction course is a great way to learn about the amazing craft of blacksmithing, the course will teach you the basics of forging and making decorative work for your home and you will have something you have made to take home with you and enjoy.  On the course we will make a twisted and scrolled fire poker and a hook to hang it, if we have time we may also make another small item such as a bottle opener or key ring Courses are £150 Per person per day  I run a strict cancellation policy. If you cannot attend the date you have booked please contact me within three weeks and I will rebook your course for free, If you contact me after this deadline you will lose your place. Refunds are not available. No under 18s  If you have a physical gift voucher it must be presented on the first day of a course. *Gift vouchers are valid for one year from date of purchase

Acquire in-depth knowledge of heat exchanger design and cost-saving management with EnergyEdge's TEM & HTRI course. Join our virtual instructor-led training to stay ahead in the industry.

About this Training Course In context of trade, seamless supply chains and dependence on international resources, world is becoming one single market. Even though because of internet and widespread access to legal resources, business managers tend to share the common legal principles, but unfortunately, the legal framework and national laws of different countries still maintain a certain degree of uniqueness and protectionism. Thus, the success of an international contract will depend on the 'know how' in identifying the differences in legal regimes, diversity of legislature, scoping, contract drafting, negotiation and execution competencies in each context. It is getting not only important but crucial to consider risks from remote and unforeseen events, sanctions, and proxy wars. As a contract gets bigger in monetary value and wider in scope, more attention is needed in drafting and interpreting terms and conditions of any contract before signing on the last page or accepting it online. This 2 full-day course endeavours to enable the participants gain an understanding of the essential ingredients of contracts and mastering the international contracting principles. This course will equip participants to identify vague and ambiguous clauses, avoid dangerous and often hidden terms, and better understand the controlling position in a project. The participants will learn from the Case Law Reports and analysis to take home lessons learned from bitter experiences of peers in the industry. It is designed to help those who need a solution to manage current contractual issues or those who execute international contracts regularly and want to be more proficient in managing their contracts and projects, with changing contexts. Training Objectives On completion of this course, the participants will have learnt: Project management strictly in accordance with the contract and the corporate strategies How to ensure that Variations Order claims are appropriately managed in turnkey and lump-sum contracts Manage contemporary challenges and market factors with direct or indirect impact on the contracts Managing all members of the Supply Chain from vendors to logistics services providers Cost Engineering and Performance Management How to manage Consortium Partners, Contractors and Owners representatives When and how to obtain / grant extension of time (EOT) and costs Ability to identify rights and obligations of each party to a contract instead of making subjective decisions Ability to be firm in negotiations without violating the terms of the agreements Ability to spot different legal systems, contract laws and arbitration rules Ability to negotiate and avoid disputes and resolution in an amicable manner, in accordance with the provisions of the contract Competency in developing and maintaining documentary evidence and traceability for all works executed during the project Target Audience This course is intended for professionals from the Oil & Gas Industry, Heavy Engineering & Construction Industries, Terminals, Shipping and Maritime Logistics Services Providers. This course is not to be missed by, especially those who are involved in Contract Management and with roles related to Contracts e.g. Commercial Managers, Engineers, Procurement Managers and Finance Managers, with a non-legal background and Para-legal executives. Course Level Intermediate Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. 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

About this Virtual instructor Led Training (VILT)  The Subsea Production Engineering Virtual instructor Led Training (VILT) course provides an overview of all of the functionalities and key interfaces of subsea equipment. The VILT course will refer to relevant industry engineering standards for subsea equipment, subsea tie-backs and critical operational requirements. The sessions will cover challenges associated with equipment design and installability, as well as a new module on subsea tie-backs. The primary learning objectives for this VILT course are met through a combination of interactive presentations, discussion and exercises. Training Objectives By the end of this VILT course, participants will be able to: Apply the requirements of related industry standards (API 6A/ 17D, API 17A etc.) engineering standards Understand the barrier and qualification requirements Identify the barriers in place given a specific mode of operation Evaluate and select which tree alternatives are valid based on the key design drivers Identify and describe the key design drivers Explain the importance of well kill rate Describe which tree alternatives are valid for certain scenarios based on an evaluation of the key tree design requirements Examine what effects subsurface requirements may have on tree design Understand the challenges associated with designing equipment for manufacturability and installability Recognise the implications of design changes to specific components and the effects on transportation and installation (such as what type of vessels, lifting equipment, and tools to use and the logistical requirements) Recognise the implication of design changes on manufacturability of subsea equipment Target Audience This VILT course provides a comprehensive understanding of the equipment used in subsea production systems. It is designed for petroleum engineers, production engineers, subsea project engineers and is also highly suitable for cost, planning, offshore installation and offshore operations engineers. Anyone directly or indirectly involved with subsea equipment will benefit from attending this VILT course - from engineers installing the equipment to procurement staff looking to understand more. 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 Most of his working life, your expert course leader has been in a role that has enabled him to pass on skills and knowledge to others. A full-time role in Training and Development came about in 1996 with the offer to take up a full-time teaching post at Aberdeen College. In 1998, he was recruited by Kvaerner Oilfield Products, an Oil & Gas industry company, specialising in Subsea Control Systems, to develop and implement a Training & Competence program acceptable for its staff of over 600 and their client companies - a challenge he could not resist. In 2003, he broadened his horizons and became an independent Training & Development consultant. Building a reputation for delivering training and development to the Oil & Gas industry to the highest standards, he later joined Jee Ltd, a leading subsea engineering and training company based in Aberdeen. He was tasked with a wide portfolio of training, coaching & mentoring to achieve high levels of competence for the client's staff and customers. He is also a Science and Engineering Ambassador (Scotland), promoting the need for engineers and technicians for Scotland's industries, a frequent consultant to the European Economic & Social Committee for standardising Vocational Skills training and competence throughout the EU. He holds memberships in the Society of Operations Engineers, Chartered Institute of Personnel & Development and Society of Underwater Technologies. 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

About this Training Course This intensive 5 full-day has been designed as a separately bookable course comprising 3 days of Well Integrity (Basic) and 2 days of Advanced Well Integrity. The intensive 3 full-day course will equip the participants with a thorough knowledge of well integrity management and risk assessment in producing assets. Based on the regulatory requirements and using real examples and exercises from around the world, this represents best practice integrity management within the oil and gas industry. When to take action with a well is a critical decision, both from a safety and economic perspective. A consistent approach to decision-making provides certainty within the organisation, focusing effort, and spending wisely. The decision-making steps will be set out to ensure all critical aspects are captured consistently. Risk analysis approaches used by different organisations and examples of risk management and risk-ranking methods will be discussed. The 2 full-day course will deepen the participants' knowledge of well integrity management, and skills for designing, operating, and maintaining well equipment. The ultimate goal is to optimise productivity at the lowest Unit Operating Cost (UOC) and to maintain mechanical integrity throughout well life cycle. Well Integrity management is looked at in three distinct stages. The first stage is during the well design which includes material selection, engineering design, cement design, coating and inhibitors and cathodic protection. The second stage is monitoring the well during the life of the well, locating possible leaks and / or loss of metal. The last stage is to manage and control any well integrity issues using specialised products, services and techniques. Training Objectives 1. Well Integrity Training: Upon completion of this course, the participants will be able to: Define the building blocks of a successful well integrity management system Develop an approach to risk management, understand risk analysis and methods applied across the industry How do we 'Make Wells Safer', learn about emerging technologies for well integrity problem diagnosis and new techniques available to 'repair' the issues Execute the basic elements of well integrity management training for field operators Evaluate well design elements that enhance or hinder well integrity status definition during the operating phase of the well life-cycle Gain the demonstrable benefits of well integrity management from field experience Review cases studies and discuss them to enhance knowledge and take on board lessons learned 2. Advanced Well Integrity: Define well integrity well categorization based on compliance to the barrier policy outlined in the regulations and develop an approach to risk management Discuss well-completion design and construction to create a 'integer' well with the lowest life cycle maintenance cost from a WIM perspective Monitoring and surveillance of well integrity, focusing on barrier competence such as cementing and corrosion Investigate and manage well integrity issues, causes & potential solutions Understand repairs needed to address 'Loss of Well Operating Envelope' Gain an overview understanding of Well Suspension & Well Abandonment Discuss further case studies as well as conduct a post course test Target Audience Invaluable for production, operations, and integrity professionals involved in implementing & managing well integrity and seeking to improve performance. It is also essential for those who need to develop and implement such systems, or who have a general need to know and understand more about well integrity management. The course will also provide a fresh approach for senior professionals and managers. Designed for professionals in the oil and gas industry who are involved in the design, construction and operation of wells from the following disciplines: Production Maintenance Production Operations Drilling Engineering Safety engineering Well Intervention Well Integrity Engineering Asset Management Course Level Intermediate Advanced Trainer Gordon Duncan has over 40 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (completions, slickline & workovers), he joined Shell as a well service supervisor. He was responsible for the day-to-day supervision of all well intervention work on Shell's Persian/Arabian Gulf platforms. This included completion running, coil tubing, e-line, slickline, hydraulic workovers, well testing and stimulation operations. An office-based role as a senior well engineer followed. He was responsible for planning, programming and organising of all the well engineering and intervention work on a number of fields in the Middle East. He had a brief spell as a Site Representative for Santos in Australia before joining Petro-Canada as Completions Superintendent in Syria, then moved to Australia as Completions Operations Superintendent for Santos, before returning to Shell as Field Supervisor Completions and Well Interventions in Iraq where he carried out the first ever formal abandonment of a well in the Majnoon Field. While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting & Planning courses all over the world. In 2014, he started to focus 100% on training and became the Technical Director for PetroEDGE. Since commencing delivering training courses in 2008, he has taught over 300 courses in 31 cities in 16 countries to in excess of 3,500 participants. 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 NVQ Level 3 Diploma in Formwork provides a nationally recognised qualification for those working in the construction and the built environment sector in the specialise in handling, erecting, striking, constructing, maintaining and repairing complex and non-complex formwork to demonstrate their competence and become eligible for the Gold CSCS Card. Our team will discuss the qualification process with you prior to signing up in order to ensure that you will be able to complete the qualification. Upon completion of the qualification, you will be awarded the NVQ Level 3 Diploma in Formwork. CSCS Cards We can provide CSCS tests and CSCS Cards alongside the qualifications without the need to attend the test centre. Just ask for more information.

The NVQ Level 3 Diploma in Insulation and Building Treatments provides a nationally recognised qualification for those working in the construction and the built environment sector and specialise in one or more of the following categories: External Wall Insulation Room in the Roof Park Homes Hybrid Wall Insulations Insulating Framed Sections The qualification modules will be discussed and agreed upon with each individual candidate to ensure that the qualification will be suited to your job role and will be achievable in order to demonstrate their competence and become eligible for the Gold CSCS Card. Each candidate will be allocated a designated and qualified assessor to provide support throughout the qualification and provide information, advice and guidance to candidates in order that they can achieve the qualification. If you require further information or are looking to undertake this qualification, please contact us. CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for various qualifications. The red card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. On completion of the qualification, you will receive a full advanced craft, 5 year, CSCS card.

The aim of the Level 3 NVQ Diploma in Wood Occupations (Construction) qualification is to recognise the knowledge, skills and competence of individuals who specialise in a wood based occupation in the construction industry eligible for the Gold CSCS Card. Upon completion of the qualification, you will be awarded the NVQ Level 3 Diploma in Wood Occupations. The qualification modules will be discussed and agreed upon with each individual candidate to ensure that the qualification will be suited to your job role. Each candidate will be allocated a designated and qualified assessor to provide support throughout the qualification and provide information, advice and guidance to candidates in order that they can achieve the qualification. If you require further information or are looking to undertake this qualification, please contact us. CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for various qualifications. The red card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. On completion of the qualification, candidates can upgrade or renew their CSCS Card card to the full 5 year card.