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.
Five half-day Leadership modules with mini work placed projects to bring the learning into action in the workplace.
Gain expertise in IFRS accounting for the oil and gas sector with our industry-focused training course. Enroll today with EnergyEdge.
About this Training Course In our pursuit to discover oil & gas in deeper horizons, wells are often drilled in a HPHT environment. To be considered a HPHT well, the downhole conditions will have pressures in excess of 10,000 psi (69 MPa) and 300° F (150° C). To drill these usually expensive wells successfully, the planning and execution phase has to be of an exceptionally high standard. Therefore, both operator and drilling/service contractor staff must be seamlessly aligned and work as a coherent team to reach and then harness the well objectives. This is particularly important when speciality services such as Managed Pressure Drilling (MPD) are being applied with crews and/or supervisors who are not intricately familiar with complicated well control incidents. As we seek to prevent costly non-productive time, attention will also be paid to enabling technologies like expandable solid tubulars, mud coolers and specialty mud. The 3 full-day course will explain the key characteristics and challenges of HPHT Planning and Well Control. This includes: Differences between HPHT and standard (conventional) wells and what this entails for well design. The challenges unique to HPHT and the impact of Pore Pressure Prediction (PPP). Static and Dynamic Equivalent Mud Density and the factors that influence the ultimate Bottom Hole Pressure (BHP). Control practices such as 'fingerprinting' to identify what's happening downhole. HPHT shut-in procedures and practices. Specific HPHT equipment and drilling tool requirements and advantages of Managed Pressure Drilling (MPD). Well control on/off bottom, bull-heading and dealing with kick-loss situations. Mud management, tolerance on mud properties and challenges in cementing. Case history on emergency control. Drills, team effort, checklists, human factor and 'getting everybody on board'. Training Objectives By the end of this course, participants will be able to: Recognize the main differences in planning/design between HPHT and standard (conventional) wells as well as the challenges that will have to be faced. Explain drilling and tripping operational challenges and practices as well as how to manage these effectively. Identify wellbore breathing (a.k.a. ballooning) and how to safely deal with this within the narrow window for mud density selection. Apply practices of consistent fingerprinting and how to develop procedures for this to benefit the rig team. Measure and understand bottom hole pressure and the effect of influencing factors such as temperature, rotation and flow rate. Understand the critical mud properties to alleviate barite sag, general mud density control techniques and specify the essentials in cementing. Manage losses and low fracture gradients with well bore strengthening methods. Execute sound HPHT shut-in procedures. Understand how MPD can assist in the safe and efficient drilling and hole cleaning of HPHT wells. Understand the use of MPD Influx Management Envelopes. Identify critical Early Kick Detection Systems (EKDS) and HPHT well control equipment. Execute safe secondary well control practices in a H2S environment, bull-heading, on and off bottom and handling of gas at surface, using MGS and hydrate mitigation measures. Target Audience The course is intended for: Office-based staff engaged in HPHT well planning and day-to-day operations Field-based rig staff working as front-line supervisors - from Assistant Drillers to Senior Toolpushers Field-based rig staff working for service companies supporting the execution of HPHT wells (MPD, mud and mudlogging services etc.) Trainer Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. 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
Disciplined Agile Scrum Master (DASM) Is your team treading water using waterfall? Do you feel trapped in an agile framework? Would you like to find solutions to the problems you've been wrestling with? Are you looking for ways to enhance your team's agility? Break free from your old ways by choosing a way of working that fits your team's context. Find strategies to improve your processes and strengthen your team with the Disciplined Agile® tool kit. Disciplined Agile Scrum Master is a nine-lesson, instructor-led course that shows you how to use Disciplined Agile (DA™) to improve your team's way of working. In just two days, you will become familiar with foundational agile and lean practices that DA supports, practice using the tool kit to solve problems, and learn how to build high-performance teams. Filled with activities, animations, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Scrum Master (DASM) exam and, equally important, start using Disciplined Agile immediately. #BBD0E0 » What You Will Learn After the completion of this course, you will be able to: Apply foundational agile and lean practices in your own team setting Describe what business agility is and how it is core to value proposition of Disciplined Agile® Describe the significance of the Disciplined Agile mindset Define the DA™ principles, promises, and guidelines and how they set Disciplined Agile apart from other frameworks Explain how people are organized into DA teams Define the primary DA roles and how they each are key to the success of a self-organizing agile team Explain how to help your team work well together using the Lean principle of 'respect people' Analyze your team's context to make better process-related decisions Select the best-fit DA life cycles for your teams Apply the five DA steps of choosing your team's way of working (WoW) Apply the relevant agile and lean techniques to successfully initiate your team Apply the relevant agile and lean techniques to support your team producing business value Apply the relevant agile and lean techniques to support your team releasing their work into production Apply the relevant agile and lean techniques to support your team on an ongoing basis Recognize when to be resilient List and define the principles of Lean Significance of the Disciplined Agile® Mindset Business agility and how it is core to value proposition of Disciplined Agile Eight DA principles and how they are core to what sets Disciplined Agile apart from other agile frameworks Which situations each of the DA™ life cycles is best applied DA Practice of choosing a team's way of working (WoW) Foundations of Agile How people are organized into DA teams Primary DA roles and how they each are key to the success of a self-organizing agile team Help your team work well together (Lean principle 'Respect people') Inception phase and why it is important DA tool kit to tailor your way of working within a select phase according to context Agile techniques and ceremonies relevant to Inception Construction phase and why it is important Agile techniques and ceremonies that take place during Construction Eliminate Waste and Build Quality (Lean principles) Deliver Value Quickly (Lean principle) Transition phase and why it is important Ongoing phase and why it is important Learn Pragmatically (Lean principle) Elements of the process blade (onion) diagram Principles of Lean When to be resilient Benefits of explicit workflow Kaizen loops and PDSA techniques for continuous improvement Options for cross-team learning: "community of practice" and "center of excellence"
How to improve dating success Learning emotional intelligence Improve social awareness Training on emotional resilience Motivation and Patience training Learn Communication Skills Enhance Patience and Introspection Coping mechanisms for stress Learn how to understand people better Learn Assertive communication Improve observation skills Improve mental and physical attraction Are you tired of going on endless dates with no results? Do you struggle to communicate effectively with potential partners or build the confidence needed to succeed in the dating world? If so, Miss Date Doctor UK’s Dating Coach Course is here to help! Our comprehensive course is designed to provide individuals with the tools and knowledge needed to improve their dating skills and find meaningful relationships. Our expert coaches will guide you every step of the way, from developing your personal brand and building confidence to mastering communication skills and navigating online dating. The Dating Coach Course at Miss Date Doctor UK is ideal for anyone looking to enhance their dating experience, whether you’re single and searching for the right partner, or simply looking to improve your current relationship. Our course is tailored to meet the unique needs of each individual, and our coaches are dedicated to providing personalized support and guidance to help you achieve your goals. At Miss Date Doctor UK, we believe that finding love should be a fun and enjoyable experience. That’s why our Dating Coach Course is designed to help you approach dating with a positive and confident mindset, and to give you the skills and knowledge needed to make informed decisions about your dating life. Our course covers a wide range of topics, including building self-esteem, overcoming fears and anxieties, mastering communication skills, and navigating online dating platforms. Whether you’re looking to improve your social skills, build your confidence, or simply learn more about the dating world, Miss Date Doctor UK’s Dating Coach Course has everything you need to succeed. Our course is packed with the key pillars of improving your dating “personal development”, “relationship advice”, “self-improvement”, “emotional intelligence”, “interpersonal skills”, “communication techniques”, “love coaching”, “dating tips”, “online dating”, “dating apps”, and more! So why wait? Sign up for the Dating Coach Course at Miss Date Doctor UK today and start your journey towards a happier, healthier dating life! https://relationshipsmdd.com/product/dating-coaching-course/
Black CSCS Card NVQ Level 6 Diploma in Occupational Health and Safety Practice This qualification is aimed at health and safety managers who are responsible for developing and applying health and safety procedures day-to-day in their organisation. They may be a staff member, supervisor or manager looking to improve their knowledge and skills. Furthermore, once you have completed this NVQ you will be able to apply for GRADIOSH status. Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor you'll get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.
Black CSCS Card NVQ Level 6 in Construction Site Management This qualification is for site managers who are responsible for leading projects, controlling resources, and overseeing quality standards. You are expected to be employed in site management, ideally overseeing, or starting to oversee, projects or sites. You will be responsible for leading teams, maintaining, and improving the standards of work. You may work across one or more of the following pathways: Building and Civil Engineering Highways Maintenance Residential Development Conservation Demolition Furthermore, this NVQ provides your recognition as a Construction Site Manager and offers you a route to professional memberships such as MCIOB. Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor you will decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be claimed. To download our PDF for this course then please click here.
Disciplined Agile Senior Scrum Master (DASSM) Do you want to take Disciplined Agile® to a new level? Are you looking for tools to solve complex problems and enhance your organization's agility? Do you want to learn how to lead your team to excellence? Expand your knowledge and build practical skills around Disciplined Agile®, business agility, leadership, and team development. Disciplined Agile Senior Scrum Master is a nine-lesson, instructor-led course that shows you how to use the Disciplined Agile tool kit to solve a variety of advanced problems, work with allies within your organization, and optimize how teams work. You will gain knowledge in planning, reporting and metrics, and coordinating activities, as well as how to meet challenges in these areas. And you'll develop the skills you need to foster emotional intelligence, resolve conflicts, and lead high-performance teams at any stage of development. Filled with activities, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Senior Scrum Master (DASSM) exam and, equally important, start using Disciplined Agile immediately within your leadership role. What You Will Learn After the completion of this course, you will be able to: Accelerate your ability to lead high-profile initiatives that are critical to enterprise success Take a deep dive into the Disciplined Agile® tool kit to develop a comprehensive understanding of the hundreds of practices and strategies it contains and the trade-offs of applying them Apply the Disciplined Agile tool kit in hands-on exercises to guide your team in choosing and evolving your best way of working (WoW) in real-life situations Use the tool kit to solve complex challenges commonly encountered in development and operational teams, the value stream, and at the enterprise level Learn how to design and implement metrics that measure your improvements in areas where your teams are struggling Understand how to nurture emotional intelligence Feel confident empowering others on your team(s) Learn how to lead your teams in any situation to improve value delivery for your customers Apply the Disciplined Agile tool kit to guide your team in choosing and evolving the best way of working (WoW) in the situation you face Be prepared to take the Disciplined Agile® Senior Scrum Master (DASSM) exam and earn a valuable, credible certification Roles and responsibilities of DASSM Tuckman Team Development Model Emotional intelligence and why it is essential to team performance Business agility Tactical scaling factors in more complex situations Disciplined DevOps layer 'Test-first' method as it relates to the quality of requirements Scope and purpose of the value stream layer Coordinate activities process goal and why it is important Value creation structure of teams DA™ tool kit to optimize the flow of work and solve challenges related to coordinating and collaborating across teams, or within a larger team of teams Thomas-Kilmann Conflict Resolution Planning Five levels of scope Metrics
Disciplined Agile Senior Scrum Master (DASSM): In-House Training Do you want to take Disciplined Agile® to a new level? Are you looking for tools to solve complex problems and enhance your organization's agility? Do you want to learn how to lead your team to excellence? Expand your knowledge and build practical skills around Disciplined Agile®, business agility, leadership, and team development. Disciplined Agile Senior Scrum Master is a nine-lesson, instructor-led course that shows you how to use the Disciplined Agile tool kit to solve a variety of advanced problems, work with allies within your organization, and optimize how teams work. You will gain knowledge in planning, reporting and metrics, and coordinating activities, as well as how to meet challenges in these areas. And you'll develop the skills you need to foster emotional intelligence, resolve conflicts, and lead high-performance teams at any stage of development. Filled with activities, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Senior Scrum Master (DASSM) exam and, equally important, start using Disciplined Agile immediately within your leadership role. What You Will Learn After the completion of this course, you will be able to: Accelerate your ability to lead high-profile initiatives that are critical to enterprise success Take a deep dive into the Disciplined Agile® tool kit to develop a comprehensive understanding of the hundreds of practices and strategies it contains and the trade-offs of applying them Apply the Disciplined Agile tool kit in hands-on exercises to guide your team in choosing and evolving your best way of working (WoW) in real-life situations Use the tool kit to solve complex challenges commonly encountered in development and operational teams, the value stream, and at the enterprise level Learn how to design and implement metrics that measure your improvements in areas where your teams are struggling Understand how to nurture emotional intelligence Feel confident empowering others on your team(s) Learn how to lead your teams in any situation to improve value delivery for your customers Apply the Disciplined Agile tool kit to guide your team in choosing and evolving the best way of working (WoW) in the situation you face Be prepared to take the Disciplined Agile® Senior Scrum Master (DASSM) exam and earn a valuable, credible certification Roles and responsibilities of DASSM Tuckman Team Development Model Emotional intelligence and why it is essential to team performance Business agility Tactical scaling factors in more complex situations Disciplined DevOps layer 'Test-first' method as it relates to the quality of requirements Scope and purpose of the value stream layer Coordinate activities process goal and why it is important Value creation structure of teams DA™ tool kit to optimize the flow of work and solve challenges related to coordinating and collaborating across teams, or within a larger team of teams Thomas-Kilmann Conflict Resolution Planning Five levels of scope Metrics