36230 Courses in Cardiff delivered Online

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Life coaching package 3 Months relationship guidance (Relationship analysis ascertaining problem areas) Relationship training programme Confidence and Styling / Beauty /Body confidence training 3 Gym sessions per week (1 hour PT session) (The personal trainer will put together a bespoke package for individual this part of the package is optional) M.D.D Whats app Service inclusive in this package. (Includes teeth whitening with celebrity dentist and 2x Harley Street beauty treatments) Get fit and healthy Overhaul your beauty regime Work on improving you and moving On to a new improved you. Learn how to be better in relationships and become a better partner. Find out what your wants and needs are in a relationship. Price on application https://relationshipsmdd.com/product/m-d-d-v-i-p-private-coaching-package/

LAN training course description A concise overview course covering Local Area Networks with particular emphasis on the use of Ethernet and Wireless LANS. As well as explaining buzzwords we cover how the technology works at a simple level. After defining LANs the course moves onto Ethernet and switching also covering VLANs. WiFi is then covered, with coverage of 802.11 standards and frequencies along with integrating WiFi with Ethernet. The course then covers routers and their role in connecting networks and the course finishes with a comparison of Ethernet vs WiFi and when to use them. What will you learn Describe how Ethernet works (in simple terms) and when to use Ethernet. Explain the difference between a switch and a router. Describe how WiFi works (in simple terms). Describe the role of Access points. Evaluate wireless technologies and when to use them. List the speeds of various LAN technologies. LAN training course details Who will benefit: Sales staff, managers and other non technical staff. Prerequisites: None. Duration 1 day LAN training course contents LANS What is a LAN? LAN standards, LAN choices, choosing the media, copper, UTP, cat5e, fibre, RF, bandwidth speeds, link aggregation, Full/half duplex. Ethernet What is Ethernet? 802.3, parts of Ethernet, Ethernet evolution, MAC addresses, frames, broadcasts. Ethernet switches What are switches, switches versus hubs, how switches work, ways to configure switches, Loops, STP. VLANs What are VLANs? Why have VLANs, impact of VLANs, Tagging (aka trunking), 802.1Q Wireless LANS Type of wireless LAN, RF frequencies, 2.4GHz, 5GHz, others, interference, standards, 802.11 and variants, CSMA/CA. Wireless LANS NICs, Access points, integration with Ethernet, multiple access points, mesh networks, WiFi security. Interconnecting LANs Routers, connecting networks, interconnecting VLANs, IP addressing, Layer 3 switches. Summary WiFi vs Ethernet.

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 Level 6 Diploma in Accounting and Business qualification (accredited by Othm) is to provide learners with the knowledge and skills required by a middle or senior manager in an organisation, and who may be involved in managing organisational finances, investment and risk, audit and assurance, or research. Many accountants occupy key managerial positions in business, yet few are qualified managers. In the increasingly complex modern business environment, there is a high demand for skilled professionals who can work flexibly in teams across business boundaries. Key Highlights Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 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 Who is this course for? Working Professionals, Level 5 / Year 2 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.

If you’re interested in becoming a fully qualified Teaching Assistant, but don’t know where to start your learning journey, then the Teaching Assistant Level 3 Diploma training course could be the perfect option for you. Learn the skills and knowledge needed to succeed! The Teaching Assistant Level 3 Diploma course has been designed by our team of teaching experts to provide you with a complete overview of what is needed to become a successful TA. Enrol on the Teaching Assistant Level 3 Diploma course today and kickstart a new and exciting career helping children reach their full potential.

Project Management Fundamentals for IT Projects: Virtual In-House Training A number of factors impact the new project manager's role within IT - for instance, the need to fully integrate IT into the business improvement process and the advent of distributed technology and Business Process Reengineering. As a result, the range of activities required of a new project manager has greatly increased, as well as the range of people with whom he or she interacts. This workshop enables you to minimize the problems inherent in managing a systems development project. What You Will Learn You'll learn how to: Articulate the benefit of using a project management methodology, processes, and various life cycles for IT projects Articulate on various standards and maturity models that provide benefits to performing organizations that manage IT projects Describe governance, gating, and the processes required for project origination Conduct a stakeholder analysis and describe its benefits throughout the project life cycle Gather good requirements, develop a work breakdown structure (WBS), and establish a baseline project plan Execute against the baseline project plan while managing change and configuration items Monitor and control the project activities using the baseline project plan and earned value management concepts Close the project by conducting scope verification, procurement audits, gathering lessons learned, archiving project records, and releasing resources Getting Started Course goal Course structure Course goals and objectives Foundation Concepts Key definitions and concepts Methodologies, processes, and project life cycles Project success factors and the benefits of standards and models Project Originating and Initiating Originating projects Initiating projects Planning Stakeholder Engagement and Resource Management Planning stakeholder engagement Planning human resources management Developing effective leadership skills Planning Scope and Quality Management Planning project scope Planning project quality Planning Schedule Management Planning project time Identifying schedule activities Sequencing schedule activities Estimating activity resources and time Developing project schedule Optimizing the project schedule Planning Risk and Cost Management Planning for project risks Planning project costs Estimating project costs Developing a project budget Planning Communication and Procurement Management Planning project communications Planning project procurements Project Executing, Monitoring and Controlling, and Closing Project executing Project monitoring and controlling Project closing

Course Overview: The Diploma in Social Work Studies Level 5 provides learners with an in-depth understanding of social work, covering key theories, methods, and practices within the field. Designed to enhance knowledge of both theoretical and practical aspects, this course equips students with the skills to navigate the complexities of social care. Learners will gain a broad understanding of working with vulnerable populations, professional conduct, and various intervention models. Upon completion, students will be well-prepared to contribute to the social work sector, providing essential support to individuals and communities. Course Description: This course explores a range of core topics within social work, including the foundational theories, casework processes, and the diverse contexts in which social work practice occurs. Students will delve into the different models of intervention and the role of social workers within multidisciplinary teams. The programme offers insight into working with adults, understanding the principles of conduct, and the professional responsibilities of a social care worker. Throughout the course, learners will develop critical skills in managing casework and applying relevant theories to real-world situations. The course is structured to provide learners with a comprehensive understanding of social work principles, preparing them for future careers in this essential field. Course Modules: Module 01: An Overview of Social Work Module 02: Social Work Basics Module 03: Theories of Social Work and Sociology Module 04: Casework Process and Teamwork Module 05: Dimensions of Social Work / Models of Intervention Module 06: Practice Contexts and Application Module 07: Working with Adults Module 08: Principles of Conduct and Role as Social Care Worker (See full curriculum) Who is this course for? Individuals seeking to pursue a career in social work Professionals aiming to advance in the social care sector Beginners with an interest in social work and sociology Anyone wanting to understand the role of social workers in society Career Path Social Worker Social Care Practitioner Adult Social Care Worker Community Support Worker Social Care Team Leader

Managing and Leading Projects Across Organizational Boundaries - Achieving Project Success in Complex Environments Through Collaborative Skills: On-Demand Significant projects today are performed by teams of people from multiple organization units and, often, multiple companies. When project managers, team leaders or technical professionals seek collaborative relationships across organizational boundaries, they often encounter a daunting array of challenges. These challenges must be dealt with effectively across business, political, team, interpersonal and personal levels to successfully meet project objectives. The goal of this course is to provide participants with a framework for improving project performance by successfully navigating through the turbulence of organizational cultures. What You Will Learn You'll learn how to: Assess an organizational culture's challenges and adapt your interpersonal skills and political acumen to meet them Apply basic tools and techniques for building relationships and gaining influence across organizational boundaries Plan a tailored, systematic approach for gaining support, resources and collaboration from individuals in organizations where you have no formal influence Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Overview of key course concepts Managing and leading: the balance and evolution Managing and leading projects versus ongoing work Organizations defined and a project manager's outlook across the structures The Path to Competency in Managing and Leading Projects Across Organizational Boundaries (MLPAOB) Organizational Cultures and Behaviors Overview of organizational culture and behaviors Organizations and change Organizational grassroots changes Political Acumen Overview of role and impact of political acumen Role of politics in organizations Political behaviors How to improve your political acumen skills Building Relationships Strategies for building relationships Balance emotion with reason "Try to understand" Inquire, consult and listen Reliability and building trust Gaining Influence Overview of gaining influence Step 1: Determine influence needs Step 2: Assess influence assets Step 3: Plan approach Step 4: Implement plan Step 5: Manage progress Planning and Implementing Your Approach Overview of Implementation Approach and Continuous Improvement (IA&CI) Enhancing Primary MLPAOB skills through: Identifying and sampling auxiliary MLPAO skills Practicing MLPAOB skills Self-reflection: developing a personal action plan (optional - time permitting) Summary What did we learn, and how can we implement this in our work environments?

Learn the processes, practices and principles of project management described in the PRINCE2® approach and prepare for the Foundation and Practitioner examinations on this accredited programme. Duration: 5 days (32.5 hours) Our PRINCE2® Foundation and Practitioner Qualification course is designed to teach the processes, practices and principles of project management described in the PRINCE2® approach and to prepare delegates for the Foundation and Practitioner examinations, held as part of the course. This course is designed for existing and potential Project and Team Managers who would like to gain a comprehensive understanding of the PRINCE2® method of managing projects and will provide those responsible for planning and managing projects with a structure that will help, without imposing inflexible processes or stifling creative thinking. The PRINCE2® Foundation and Practitioner Course is based on the “Managing Successful Projects with PRINCE2® 7th Edition”, which describes the structured project management method. These are intensive modules and require delegates to undertake some evening work in their own time. Objectives  By the end of the course you will be able to be: Describe the background, principles, structure and terminology used in the PRINCE2® 7th Edition project management method Prepare for and take both the PRINCE2® Foundation and Practitioner Exams Please note that examinations are the responsibility of the examination board, PEOPLECERT and must be organised separately by each person attending. Content Introduction Introduction to projects and project management Structure Of PRINCE2® 7th Edition The seven Principles –the basis of what defines a PRINCE2 project People – leading successful change, teams and communication The seven Practices – to be addressed throughout the project The seven Processes - the activities to direct, manage and deliver a project successfully Practices Business case – establishing mechanisms to decide whether project is desirable, viable and achievable Organizing – establishing accountabilities and responsibilities Quality – defining mechanisms to ensure that products are fit for purpose Plans – the product based approach to planning Risk – identifying, assessing and controlling uncertainty Issues – identifying, assessing and controlling changes to the baseline and other issues Progress – monitoring actual achievements against estimate and controlling deviations Processes Starting up a Project - is there a viable and worthwhile project Directing a Project – enabling key decision making by the Project Board Initiating a Project – establishing solid foundations Controlling a Stage –assigning and monitoring work and keeping within stage tolerance Managing Product Delivery – controlling the link between the Project Manager and Team Manager(s) Managing a Stage Boundary – current stage review and next stage planning Closing a Project – confirmation of acceptance and project review Tailoring PRINCE2® - to the project environment Foundation Examination and results Practitioner Workshop and Examination PRINCE2® Practitioner Examination Objectives and Guidance PRINCE2® Review PRINCE2® Practitioner Examination Workshops PRINCE2® Practitioner Examination PRINCE2® Foundation and Practitioner Examinations The PRINCE2® Foundation Exam is of 1 hour duration and consists of 60 multiple choice questions. A Pass is 36 correct answers, 60%. The PRINCE2® Practitioner Exam is a written paper of 2.5 hours duration. There are 70 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. The candidate must score 42/70 to be successful, 60%.   Presented in association with aims4change, a PEOPLECERT Accredited Training Organisation. PRINCE2® is a Registered Trade Mark of AXELOS Limited.

About this Training Course Wind has surpassed hydro-power generation in many countries recently. Wind energy offers many advantages, which explains why it's one of the fastest-growing energy sources in the world. The following are the advantages of wind power: Wind power is cost effective: Land-based utility-scale wind is one of the lowest-priced energy sources available today The fuel for wind power is free. This reduces the operation and maintenance cost of wind power plants significantly Wind is a clean source of power generation that does not pollute the air like power plants which rely on combustion of fossil fuel Wind power plants create jobs. Wind turbine technician is the fastest growing career in many countries Wind enables industry growth and competitiveness due to its low cost Wind power is a domestic source of energy. The wind supply is abundant and inexhaustible. The wind power generation capacity has become the largest source of renewable power in many countries Wind turbines can be built on existing farms and ranches. This greatly benefits the economy in rural areas, where most of the best wind sites are found. Wind power plant owners make rent payments to the farmers or ranchers for the use of their land, providing landowners with additional income This 5 half-day course covers all aspects of wind power plants including evaluation of a potential location for a wind power plant using wind data and using statistical distributions to approximate available wind energy at a wind power plant site. It provides also an in-depth understanding of all wind power plant equipment including wind turbines, generators, instrumentation and control systems, drive trains, gearboxes, doubly fed induction generators, synchronous generators, nacelles, towers, transformers, etc. The economics of a wind power plant including economic analysis of wind power generation, economic comparison between a large- and small-scale wind power plant, economic decision making, rate of return from a wind power plant, economic life and replacement of a wind power plant as well as the cost of electricity from wind power plants are covered in detail in this course. A thorough explanation of the design, operation and maintenance of on-shore and off-shore wind farms is presented in detail in this course as well as all the significant improvements that have been made to wind power generating plants during the last two decades. Training Objectives Evaluation of a Potential Location for a Wind Power Plant Using Wind Data: Learn how to evaluate the potential location for a wind turbine power plant using wind data. Using Statistical 'Rayleigh' Distribution to Approximate Available Power Generation from a Wind Turbine at a Specific Site: Learn how to use statistical 'Rayleigh' distribution to approximate available power generation from a wind turbine at a specific site. Calculate the Wind Energy Available at a Site: Gain an understanding on how to calculate the wind energy available at a site. Rated Capacity of a Wind Facility and Capacity Factor: Understand how to determine the rated capacity of a wind facility and its capacity factor. Designing a Wind Power Generating Plant: Learn how to design a wind power generating plant. Wind Power Plant Equipment Operation and Maintenance: Understand the operation and maintenance requirements for all wind power plant equipment including wind turbines, generators, nacelles, towers, transformers, etc. Wind Power Plant Instrumentation and Control Systems: Gain a thorough understanding about the latest instrumentation and control systems of wind power plants. Economics of Wind Power Plants: Gain a thorough understanding of the economics of wind power plants including economic analysis of wind power generation, economic comparison between a large- and small-scale wind power plant, comparison of alternatives, rate of return from a wind power plant, financial statements for a wind power plant, cost of electricity from a wind power plant, and levelized cost of wind energy.   Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a soft copy of the following materials written by the instructor: POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 (800 pages) Wind Power Generating Plant Manual (500 pages) 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