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.
SCALP MICROPIGMENTATION (SMP) IS BECOMING ONE OF THE MOST SOUGHT-AFTER TREATMENTS IN THE HAIR LOSS INDUSTRY AND IS THE FASTEST GROWING SECTOR OF THE PERMANENT MAKEUP INDUSTRY.
The Gold Card Training Programme is the most comprehensive electrician course available. We offer weekday, weekend and evening delivery options. JIB ECS (Gold) Card is quickly becoming a necessity when seeking work on commercial sites, or sub-contracting to larger contractors.
DNS training course description This three-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course starts with the big picture of how DNS works, then client configuration. Primary and secondary servers are then configured, progressing to DDNS, subdomains and security issues. Hands on sessions follow all sections ensuring that troubleshooting techniques are used throughout the course. Students choose whether to use Windows or UNIX for the hands on sessions. What will you learn Describe the architecture of DNS. Explain how DNS works. Install, configure, maintain and troubleshoot DNS DNS training course details Who will benefit: Technical staff wanting to learn DNS including: Network personnel System administrators. Prerequisites: UNIX Fundamentals (or Windows knowledge). TCP/IP foundation for engineers. Duration 3 days DNS training course contents What is DNS? Hostnames, Name resolution, host files, host file problems, What is DNS? The DNS namespace, TLDs, gTLDs, registering domains, Nameservers, how DNS works. Hands on Testing DNS servers on the Internet. DNS clients Ways to use DNS, dynamic and static configuration, multiple nameservers, domain name, searchlist, resolution issues, testing the configuration. Hands on Client configuration. DNS server software Implementations, Microsoft, BIND, daemons and services, installation, starting and stopping servers. Hands on Setting up a DNS server. DNS zone files What is a zone, Zone file overview, Forward zones, Reverse zones, Resource records, A records, PTR, CNAME, Root hints, local zone file. BIND and Microsoft configuration. Hands on Server configuration files. NS and applications MX records, Mail server load balancing, SPF, SRV records, VoIP and SRV, Microsoft and SRV, NAPTR. Hands on Testing records with dig and nslookup. DNS slaves and other servers DNS server types, Server resilience, Slaves, Zone transfers, SOA records, Serial numbers, recommendations, polling based zone transfers, NOTIFY, AD integration, DNS caching, Negative caching, TTL, Caching only servers. Hands on Masters, slaves and zone transfers. The DNS protocol The DNS stack, DNS port numbers, DNS queries, The DNS header, header section format, question format, other section format. Hands on Troubleshooting DNS with Wireshark. Dynamic DNS DHCP, DDNS, IXFR, WINS integration. Hands on Dynamic DNS. Subdomains Root servers, root server selection, Authority, delegation, NS records, subdomain with and without delegation, reverse delegation. Hands on Delegation, setting up a subdomain server. DNS security Restricting queries, DNS and firewalls, Split DNS, forwarders, internal root servers, the use of proxy servers, DNSSEC, TSIG. Hands on Hardening a DNS server. DNS and IPv6 What is IPv6, IPv6 addressing, IPv6 DNS issues, AAAA, IPv6 reverse delegation. Troubleshooting DNS Problem solving, DNS troubleshooting, Zone file checking, Some common errors, Log files, tools, nslookup, dig, host, DNS design, performance, load balancing. Hands on Putting it all together. Summary Useful books, Internet sites, RFCs. Appendix: ENUM What is ENUM, How ENUM works, NAPTR.
About this Training Course The 3-day hands-on petroleum economics training course provides a comprehensive overview of the practices of exploration and development petroleum economics and its application in valuing oil and gas assets to aid corporate decisions. Participants will gain a thorough understanding of the principles of economic analysis as well as practical instruction in analytical techniques used in the industry. The participants will learn how to construct economic models, to include basic fiscal terms, production and cost profiles and project timing. The resulting model will provide insights of how the various inputs affect value. Example exercises will be used throughout the course. Training Objectives Upon completion of this course, participants will be able to: Understand and construct petroleum industry cash flow projections Calculate, understand and know how to apply economic indicators Learn and apply risk analysis to exploration and production investments Evaluate and model fiscal/PSC terms of countries worldwide Target Audience The following oil & gas company personnel will benefit from the knowledge shared in this course: Geologists Explorationists Reservoir Engineers Project Accountants Contract Negotiators Financial Analysts New Venture Planners Economists Course Level Basic or Foundation Intermediate Trainer Your expert trainer has over 40 years' experience as a petroleum economist in the upstream oil and gas industry. He has presented over 230 oil and gas industry short courses worldwide on petroleum economics, risk, production sharing contracts (PSC) and fiscal analysis. In over 120 international oil industry consulting assignments, he has advised companies and governments in the Asia Pacific region on petroleum PSC and fiscal terms. He has prepared many independent valuations of petroleum properties and companies for acquisition and sale, as well as economics research reports on the oil and gas industry and including commercial support for oil field operations and investments worldwide. He has been involved in projects on petroleum royalties, design of petroleum fiscal terms, divestment of petroleum assets, and economic evaluation of assets and discoveries since the early 1990s to date. He has been working on training, consultancy, research and also advisory works in many countries including USA, UK, Denmark, Switzerland, Australia, New Zealand, Indonesia, India, Iran, Malaysia, Thailand, Vietnam, Brunei, Egypt, Libya, and South Africa. 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
Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Very clearly explained Good pace. Lucy Tailor - ACER ' 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. 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
Change Management Foundation This course provides practical knowledge on Change Management techniques and the Foundation certification. You will examine various Change Management techniques and explore which could be effectively implemented in your organization. The structured approach helps you understand how you deal with change as an individual, as a member of a team or organization, and as a leader. The program design explores the impact that change has on these four major areas: Change and the Individual Change and the Organization Communications and Stakeholder Engagement Change Management Practice This course also prepares you for the APMG Change Management Foundation exam. Given that a primary course goal is to achieve the Foundation Certification, the course text will be provided in advance of the workshop so the participant may begin studying. In addition, daily homework assignments and practice exams will be provided. The Foundation-level exam is taken at the end of the third day of the Traditional Classroom course. Virtual Classroom participants must make separate arrangements to schedule their exam following course completion (See 'Important Note for Virtual Course Participants'). What You Will Learn You'll learn how to: Explain how individuals learn and why many may resist change Illustrate how to build an effective change team Describe the stakeholder engagement process and relate this to appropriate communication Differentiate various approaches to plan, implement, and sustain organizational change Demonstrate how to assess change impact and readiness, and deal with resistance Improve your ability to pass the APMG Change Management Foundation Certification exam Getting Started Introductions Course structure Course goals and objectives Change and the Individual How people learn Personality and change - introduction to MBTI Models of individual change - the Change Curve and Bridges' Transition Motivating individuals during change Change and the Organization Understanding organizational metaphors Organizational culture and change 3 models of change - Lewin, Kotter, and Senge Key roles in change Stakeholder Engagement Identifying and analyzing stakeholders Personas and empathy maps Influencing strategies Communication Feedback and communication approaches Communicating change - planning, factors, and barriers Communication biases and channels Change Impact Identifying and assessing change impact Stakeholder impact assessment Change severity assessment Change Readiness Building change agent networks and the change team How to make the organization ready for change Creating a change management plan Dealing with resistance to change APMG Change Management Foundation Exam Preparation Review of and practice with APMG sample questions and test papers APMG Change Management Foundation Exam Traditional Classroom: Paper-based exams will be taken on the last day of class Virtual Classroom: The exam is scheduled by the Participant and taken subsequent to the course
Change Management Foundation: In-House Training: In-House Training This course provides practical knowledge on Change Management techniques and the Foundation certification. You will examine various Change Management techniques and explore which could be effectively implemented in your organization. The structured approach helps you understand how you deal with change as an individual, as a member of a team or organization, and as a leader. The program design explores the impact that change has on these four major areas: Change and the Individual Change and the Organization Communications and Stakeholder Engagement Change Management Practice This course also prepares you for the APMG Change Management Foundation exam. Given that a primary course goal is to achieve the Foundation Certification, the course text will be provided in advance of the workshop so the participant may begin studying. In addition, daily homework assignments and practice exams will be provided. The Foundation-level exam is taken at the end of the third day of the Traditional Classroom course. Virtual Classroom participants must make separate arrangements to schedule their exam following course completion (See 'Important Note for Virtual Course Participants'). What You Will Learn You'll learn how to: Explain how individuals learn and why many may resist change Illustrate how to build an effective change team Describe the stakeholder engagement process and relate this to appropriate communication Differentiate various approaches to plan, implement, and sustain organizational change Demonstrate how to assess change impact and readiness, and deal with resistance Improve your ability to pass the APMG Change Management Foundation Certification exam Getting Started Introductions Course structure Course goals and objectives Change and the Individual How people learn Personality and change - introduction to MBTI Models of individual change - the Change Curve and Bridges' Transition Motivating individuals during change Change and the Organization Understanding organizational metaphors Organizational culture and change 3 models of change - Lewin, Kotter, and Senge Key roles in change Stakeholder Engagement Identifying and analyzing stakeholders Personas and empathy maps Influencing strategies Communication Feedback and communication approaches Communicating change - planning, factors, and barriers Communication biases and channels Change Impact Identifying and assessing change impact Stakeholder impact assessment Change severity assessment Change Readiness Building change agent networks and the change team How to make the organization ready for change Creating a change management plan Dealing with resistance to change APMG Change Management Foundation Exam Preparation Review of and practice with APMG sample questions and test papers APMG Change Management Foundation Exam Traditional Classroom: Paper-based exams will be taken on the last day of class Virtual Classroom: The exam is scheduled by the Participant and taken subsequent to the course
Elevate your expertise in LNG terminal operations safety through our classroom training course. Energyedge provides industry-leading expertise and guidance.