Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Certificates Certificates Certificate of completion Digital certificate - Included
PgMP® Exam Prep: In-House Training This course is designed and developed by PgMP® certified consultants and instructors. Its aim is to prepare professionals who are familiar with the principles of program management for the Program Management Professional (PgMP)® Examination. The course is based on PMI's The Standard for Program Management, A Guide to the Project Management Body of Knowledge (PMBOK® Guide), and PMI's Program Management Professional (PgMP)® Examination Content Outline (current versions). Through this learning experience, you will explore: Program management from a PMI standard perspective, including the interdependencies between the five performance domains, the three program phases, and the ten supporting activities in this new and improved program management standard The difference between the five performance domains in the new program management standard and the five practice domains in the examination content outline The role and competencies of the program manager The difference between project managers and program managers - and their relationship in a program environment The difference between program managers and portfolio managers - and their relationship in a program environment How program managers align and manage benefits The best ways to engage and involve program stakeholder groups How to establish governance across the program life cycle What You Will Learn At the end of this course, you will be able to: Differentiate between the practice domains in the PMI PgMP® Examination Content Outline and the performance domains in The Standard for Program Management - Fourth Edition Name and describe the three phases in the program management life-cycle phases Describe the mapping of the life-cycle phases with the supporting program activities Identify the key outputs of the supporting program activities Articulate the interrelationships between the program management supporting processes and the mapping of processes to Knowledge Areas and Process Groups in the PMBOK® Guide - Sixth Edition Apply program management knowledge to answer foundation and scenario-based questions Summarize the process and eligibility criteria for earning the PgMP® credential Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Programs, projects, and portfolio definitions differences, and how they relate The definition of a component and how it relates to a program Representative program management life cycle Role of the program manager and the program office The difference between the program management practice and performance domains Program Register and Knowledge Asset Management Program registers, and how they are used to manage knowledge assets Knowledge asset management, beginning with the data, information, knowledge, and wisdom (DIKW) Model Knowledge assets and relationship to the performance domains The program manager as a knowledge asset manager Types of Programs Perspectives on programs to establish the 'right' perspective Categories of programs based on the program standard Scenario-based questions Program and Organization Strategy Alignment An overview of the Program Strategy Alignment performance domain Exploration of the elements of strategic alignment, i.e., the business case, program charter, and program roadmap Exploration of organization maturity and strategic alignment Scenario-based questions that reference both the Program Strategy Alignment performance domain and the Strategic Program Management practice domain Program Benefits An overview of the Program Benefits Management performance domain Exploration of each benefits management interaction with the representative program management life cycle: Benefits IdentificationBenefits Analysis and PlanningBenefits DeliveryBenefits TransitionBenefits SustainmentScenario-based questions that reference both the Program BenefitsManagement performance domain and the Benefits Management practice domain Program Stakeholder Engagement An overview of the Program Stakeholder Engagement performance domain Exploration of each stakeholder engagement performance domain activity: Program Stakeholder IdentificationProgram Stakeholder AnalysisProgram Stakeholder Engagement PlanningProgram Stakeholder EngagementProgram Stakeholder CommunicationsScenario-based questions that reference both the Program StakeholderEngagement performance domain and the Stakeholder Management practice domain Program Governance An overview of the Program Governance performance domain Exploration of each program governance performance domain activity: Program governance practicesProgram governance roles and responsibilitiesProgram governance design and implementationGovernance relationship within programsScenario-based questions that reference both the Program Governance performance domain and the Governance practice domain Program Life Cycle Management An overview of the Program Life Cycle Management performance domain Exploration of the three phases in the representative program life cycle: Program DefinitionProgram DeliveryProgram ClosureExploration of the interaction between program activities and integration managementScenario-based questions that reference both the Program Life CycleManagement performance domain and the Program Life Cycle practice domain Program Management Supporting Activities - Part 1 An overview of the program management supporting activities Exploration of 5 of 10 supporting activities: Program change managementProgram communications managementProgram financial managementProgram information managementProgram procurement managementScenario-based question(s) presented after each supporting activity Program Management Supporting Activities - Part 2 Exploration of the remaining 6 of 10 supporting activities: Program quality managementProgram resource managementProgram risk managementProgram schedule managementProgram scope managementScenario-based question(s) presented after each supporting activity Program Management Professional (PgMP®) Examination Application process and timeline General and special eligibility criteria International Institute's Online Learning Tool - access to sample examination questions Program Management Professional (PgMP®) Examination breakdown of domains and subdomains Terms and conditions of the exam PgMP® Professional Code of Conduct
PMI-ACP® Exam Prep: Virtual In-House Training This course builds on the candidates' practical experience of Agile in the workplace to equip them with the broad range of knowledge and skills required for the PMI® Agile Certification exam. It will follow the PMI® requirements and reference the suggested reading list, including the Agile Practice Guide, but will not be limited to those areas. Within the profession and discipline of project management, Agile continues to develop as a significant and important aspect of bringing change to an organization. Where the products of change must be delivered to the business 'on time,' Agile is often the chosen methodology. In addition to equipping candidates for the PMI® Agile Certification examination, this course will also support candidates in taking a more informed and effective role in Agile projects. It will also enable them to take a significant role in encouraging and enabling the organization to become or develop as an Agile environment. What you will Learn You will learn how to: Appreciate the wider aspects of Agile project management tools and techniques Integrate various disciplines within Agile Tailor / customize Agile to suit the needs of different projects Prepare yourself for the PMI® Agile Certification examination Getting Started Introductions Agenda Expectations Foundation Concepts Defining 'Traditional' Project Management Project management parameters The 'traditional' approach to the parameters Strengths and weaknesses of the traditional approach Defining 'Agile' Project Management Project management parameters revisited The 'agile' approach to the parameters Strengths and weaknesses of agile Managing projects with traditional and agile methods Can the two approaches co-exist? Leveraging the benefits of both methods Options for using both methods on a project Avoiding the elephant traps Key aspects of the PMI® Agile Certified Practitioner (PMI-ACP)® Handbook Overview Eligibility requirements Exam information Exam Blueprint Continuing certification requirements Key aspects of the PMI Agile Certification Examination Content Outline Introduction Agile exam content outline Tools and techniques Knowledge and skills Domains and tasks (not examined) An Introduction to Agile and Implementing Agile Definable work vs. high-uncertainty work Project factors that influence tailoring The Agile Manifesto and 12 Principles Agile mindset Agile domains and tasks Agile Tools and Techniques Related to PM 'Hard Skills' Planning, monitoring, and adapting The need for planning, monitoring, and adapting The Agile approach to planning and plans The Agile planning tools and techniques The Agile monitoring tools and techniques The Agile approach to adapting Product quality A definition of 'product quality' Setting the standard for product quality Agile tools and techniques for achieving product quality Risk management A definition of 'risk' What is 'at risk'? The acceptability of risks The Agile tools and techniques for managing risks Agile Tools and Techniques Related to PM 'Soft Skills' The difference between PM 'hard and soft' skills Communications The importance of communications Forms of agile communications Communications within the project Communications from the project Communications to the project Making communications the cultural norm Interpersonal Skills Defining and understanding management Defining and understanding leadership Defining and understanding servant leadership Delegating vs. empowering Playing to people's strengths Overcoming the roadblocks Core Agile Tools and Techniques The philosophy of core Agile tools and techniques Agile estimation Will traditional forms of estimating work for agile? The relationship between estimating and guessing The relationship between estimating and sizing The where, who, and how of agile estimating Agile analysis and design Product analysis and design from a user point of view Product analysis and design from a supplier point of view Product analysis and design from an agile project point of view Value-Based Agile Tools and Techniques The role of value-based tools and techniques in bridging traditional PM with Agile Value-based prioritization Value-based prioritization and agile projects Investment appraisal methods Regulatory driven Customer driven Ranking methods (MMF, MoSCoW) Metrics What should we measure / track? Methods of measuring / tracking Adding value with metrics Process Improvement Value-stream analysis Value-stream mapping Agile Knowledge and Skills Context of Agile Knowledge and Skills vis-Ã -vis Agile Tools and Techniques Agile Knowledge and Skills Process focused People focused Product focused Project focused Exam Preparation and Course Closure The application process - where are you now? The 'Exam-Focused Journal' - what you still have to do Further preparation - self-study schedule Exam topic review Practice exam Practice exam debrief Course closure
Duration 1 Days 6 CPD hours This course is intended for This course is intended for customer service professionals with any level of experience who want to expand their knowledge, improve their skill set, and increase the understanding of customer benefits. Overview In this course, you will develop the skills to coach for results. You will: Describe the benefits of customer service, identify internal customers, identify the benefits to you of giving good customer service, and identify how you can help your company to excel. Identify the major trends in customer service today and the combination of criteria required for customer satisfaction. Identify the benefits of bringing respect, emotional support, and a personal touch to customer interactions, and apply the personal touch to customer interactions. Identify the six categories of face-to-face communication, the critical success factors in face-to-face communication, and the benefits of actively listening to your customers. Identify remote customer service communication channels and apply remote customer service best practices. Identify guidelines for handling unreasonable customers, explore ways to handle angry customers, and identify guidelines for handling unhelpful colleagues. Take action to increase the loyalty of the customers you serve. You will also identify guidelines for dealing with moments of truth, identify the benefits of customer complaints, identify the steps in the service recovery process, and analyze the moments of truth in a real-life situation. As a customer service representative, you are expected to handle customer interactions in the best way possible. The expectations of both your company and your customers hinge on your ability to provide the right service in the right way. In this course, you will explore the background and techniques of customer interactions.Providing quality customer care ensures that every single contact with your company is a positive experience. Customers can range from external consumers to internal employees in other departments. Knowing how to provide the same level of service to all customers will enrich your time spent at work by establishing positive business relationships. Recognizing crucial points throughout customer interactions increases your ability to solve problems and offer affirmative solutions. Applying this knowledge to trends in service and consumer desires allows you to contribute to the company?s bottom line and make a customer?s life a little easier. Understanding Customer Service Describe Customer Service Benefits Recognize the Importance of Internal Customer Service Identify How Customer Service Benefits You Excel with Customer Service Identifying How Customers Define the Success of Your Company Recognize Trends in Customer Service Identify Criteria for Customer Satisfaction Increasing Customer Satisfaction Identify Characteristics of the Personal Touch Create Lasting Positive Impressions on Your Customers Providing Face-to-Face Customer Service Identify Categories of Face-to-Face Contact Understand the Critical Success Factors in Face-to-Face Customer Service Identify the Characteristics of Active Listening Providing Remote Customer Service Identify Remote Customer Service Communication Channels Apply Remote Customer Service Best Practices Engaging Difficult Customers Serve Difficult Customers Manage Angry Customers Deal with Difficult or Unhelpful Colleagues Increasing Customer Loyalty Optimize Moments of Truth Recognize the Value of Customer Complaints Identify the Stages of the Service Recovery Process
Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of the Level 5 Diploma in Accounting and Business (fast track) qualification accredited by OTHM is to provide learners with the knowledge and skills required by a middle manager in an organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. Level 5 Diploma in Accounting and Business (Fast track mode) Key Highlights of fast track Level 5 Diploma in Accounting and Business qualification are: Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme LSBR Alumni Status No Cost EMI Option This fast track Level 5 Diploma in Accounting and Business qualification will help you get knowledge and skills required by a middle manager in an organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. You can look forward to middle management role in organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. Upon successful completion of this fast track Level 5 Diploma in Accounting and Business programme, you will also become eligible to gain direct entry into Final Year of a three-year UK Bachelor's degree programme. Who is this course for? Working Professionals, A-Level / Level 4 / Year 1 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression. A formal undergraduate qualification leading to award of degrees in future. Requirements Open Entry. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. For others, the learners should have relevant NQF / QCF / RQF Level 4 Award / Diploma or at the level of GCE / GCSE or equivalent qualification. Please speak to the Admission Counsellors for waiver information. Career path After completion of your fast track Level 5 Diploma in Accounting and Business, you can progress to Year 3 of a Three-year UK Bachelor's degree Completion of your fast track Level 5 Diploma in Accounting and Business qualification will meet the University standard academic entry requirements.
About this Virtual Instructor Led Training (VILT) This 4 half-day Virtual Instructor Led Training (VILT) course will address a variety of contract and loan structuring issues associated with geothermal energy projects as well as comparison with solar, wind and battery storage. The course is designed to investigate how various project finance techniques and contract structures can be used to achieve a competitive power prices while maintaining a satisfactory equity return. Distinctive project finance features of power facilities that depend on geothermal, wind, hydro or solar resources will be evaluated with financial models. The course will cover economic analysis of exploration and development of geothermal facilities and how to incorporate probability of failure and success into an IRR framework. Subsequent sessions will address the theory underlying liquidated damages for delay, and performance as well as design of other incentives that is inherent in different contract structures. Nuanced project finance issues associated with structuring debt for renewable projects will be discussed including under what conditions the DSCR drives debt capacity and when the debt to capital ratio is instrumental. The course will be taught with a combination of theoretical discussions, term sheet review and focused financial models. Training Objectives Evaluation of the economic risks that arise from uncertainty associated with drilling exploration wells and development wells for geothermal projects. Analyse the theoretical issues with computing LCOE for geothermal projects compared to other renewable and non-renewable resources and the importance of cost of capital for renewable projects; Understand differences in contract structures for renewable projects and dispatchable projects and how a single price structure can distort incentives for efficient construction and operation; Understand components of financing that influence the bid price required to meet a required rate of return on equity and can result in relatively low prices with reasonable returns. Understand the importance of debt sizing constraints and what strategies are relevant when the debt to capital constraint applies relative to when the debt service coverage ratio drives the debt size; Understand how to compute P50, P90 and P99 for different projects driven by resource risk; Understand the difference between mean reverting resource variation and estimation mistakes that do not correct as the basis for 1-year P90 and 10-year P90. Understand under what conditions debt sculpting can affect returns and how synthetic sculpting can be used to increase returns when the DSCR constraint applies. Understand the theory of credit spreads, variable rate debt and interest rates in different currencies and compute the implied probability of default that in inherent in credit spreads. Understand how to evaluate the costs to equity investors and the benefits to lenders for various credit enhancements including DSRA accounts, cash flow sweeps and covenants. Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day, including time for lectures, discussion, quizzes and short classroom exercises. Trainer Your expert course leader provides financial and economic consulting services to a variety of clients, he teaches professional development courses in an assortment of modelling topics (project finance, M&A, and energy). He is passionate about teaching in Africa, South America, Asia and Europe. Many of the unique analytical concepts and modelling techniques he has developed have arisen from discussion with participants in his courses. He has taught customized courses for MIT's Sloan Business School, Bank Paribas, Shell Oil, Society General, General Electric, HSBC, GDF Suez, Citibank, CIMB, Lind Lakers, Saudi Aramco and many other energy and industrial clients. His consulting activities include developing complex project finance, corporate and simulation models, providing expert testimony on financial and economic issues before energy regulatory agencies, and advisory services to support merger and acquisition projects. Our key course expert has written a textbook titled Corporate and Project Finance Modelling, Theory and Practice published by Wiley Finance. The book introduces unique modelling techniques that address many complex issues that are not typically used by even the most experienced financial analysts. For example, it describes how to build user-defined functions to solve circular logic without cumbersome copy and paste macros; how to write function that derives the ratio of EV/EBITDA accounting for asset life, historical growth, taxes, return on investment, and cost of capital; and how to efficiently solve many project finance issues related to debt structuring. He is in the process of writing a second book that describes a series of valuation and analytical mistakes made in finance. This book uses many case studies from Harvard Business School that were thought to represent effective business strategies and later turned into valuation nightmares. Over the course of his career our key course expert has been involved in formulating significant government policy related to electricity deregulation; he has prepared models and analyses for many clients around the world; he has evaluated energy purchasing decisions for many corporations; and, he has provided advice on corporate strategy. His projects include development of a biomass plant, analysis and advisory work for purchase of electricity generation, distribution and transmission assets by the City of Chicago, formulation of rate policy for major metro systems and street lighting networks, advocacy testimony on behalf of low income consumers, risk analysis for toll roads, and evaluation of solar and wind projects. He has constructed many advisory analyses for project finance and merger and acquisition transactions. Lastly, our key course expert was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He received an MBA specializing in econometrics (with honours) from the University of Chicago and a BSc in Finance from the University of Illinois (with highest university honours). 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
Anxiety and Self-Love Journey This group coaching package is for you if you feel: constantly anxious and worried not good enough worried about the future, changes, uncertainty stuck in the same cycle of thoughts that you can’t get out of like you are not living your best life
Obtain The Assessor's Qualification through our comprehensive teaching and assessing courses at Kleek Training. Develop the skills and knowledge needed to effectively assess learners. Enquire today!
The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.