1646 Courses in Cardiff delivered Online

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 Excel Basics Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Formats 00:08:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Essential Formulas Basic Formula Operations 00:13:00 Mathematical Functions 00:19:00 Textual Functions 00:17:00 Logical Functions 00:11:00 Date-Time Functions 00:07:00 Lookup Functions ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools Data Tools 00:19:00 Formatting data and tables Formatting data and tables 00:18:00 Pivot Tables Pivot Tables 00:08:00 Excel Charts Excel Charts - Categories of messages that can be conveyed 00:04:00 Elements of charts 00:05:00 The Easy way of creating charts 00:03:00 Bar and column charts 00:12:00 Formating charts 00:15:00 Line Charts 00:09:00 Area Charts 00:06:00 Pie and Doughnut Charts 00:13:00 Why we should avoid Pie charts 00:04:00 Scatter plot or XY chart 00:16:00 Frequency Distribution and Histograms 00:13:00 Waterfall Charts 00:12:00 Sparklines 00:05:00 Pivot Charts Pivot Charts 00:07:00 Named Ranges Named Ranges 00:10:00 Indirect Function 00:05:00 Excel Shortcuts Shortcuts 00:12:00 Macros Macros 00:10:00 Advanced Excel Advanced Excel: Analytics in Excel 00:15:00 Final Assessment Assessment - Microsoft Excel For Beginners 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Discover the art of shaping cities and communities with our insightful course, 'Town Planning.' This educational journey is designed to immerse you in the nuances of urban development and the strategies employed to create harmonious, efficient urban spaces. Picture yourself as a key player in moulding the future of towns and cities, understanding the delicate balance between aesthetics, functionality, and sustainability. The course commences with an introduction to the field of town planning, setting a solid foundation for more advanced concepts. Each module, from the dynamics of residential building design to the intricacies of utility management, is crafted to provide a thorough understanding of the many facets of urban design. Venture deeper into the realm of town planning and discover the vital role of green spaces and recreational areas in fostering healthy, vibrant communities. This course is more than a series of lectures; it's a gateway to envisioning and influencing the urban landscapes of tomorrow. Tailored for those who aspire to shape the built environment, whether as planners, architects, or passionate individuals, this course offers the tools and insights needed to make a meaningful impact in the field of urban development. Learning Outcomes Gain a solid understanding of town planning basics and objectives. Acquire detailed knowledge of urban development and design processes. Learn to effectively design residential areas, focusing on community needs and aesthetic values. Master the planning of functional street layouts and essential utility infrastructures. Appreciate the significance of integrating parks and open spaces in urban layouts for community health and well-being. Why choose this Town Planning course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Town Planning course for? Individuals aspiring to become Town Planners, seeking foundational and advanced knowledge. Students of Urban Design, looking to broaden their understanding of town planning principles. Architects and Engineers wishing to enhance their urban planning and development skills. Government Officials involved in urban policy and planning, seeking deeper insights. Environmental Advocates interested in the sustainable development of urban spaces. Career path Urban Planner - £26,000 to £39,000 Design Consultant - £23,000 to £36,000 Environmental Planner - £21,000 to £33,000 City Development Officer - £29,000 to £44,000 Public Space Designer - £24,000 to £38,000 Infrastructure Coordinator - £25,000 to £37,000 Prerequisites This Town Planning does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Town Planning was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Town Planning Introduction to Town Planning 00:10:00 Module 2: Process of Town Planning Process of Town Planning 00:16:00 Module 3: Residential Buildings and Neighbourhood Planning Residential Buildings and Neighbourhood Planning 00:23:00 Module 4: Streets Streets 00:25:00 Module 5: Utilities Utilities 00:11:00 Module 6: Parks and Open Space Parks and Open Space 00:16:00 Assignment Assignment - Town Planning 00:00:00

The PMP course covers the latest trends, emerging practices, and core competencies that are required by a project management professional. Learners will also get an understanding of real-world scenarios through the case studies that are developed by the industry PMP-certified veterans.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

***Empower Yourself: A Comprehensive Guide to End of Life Care and Planning*** According to a recent Age UK report, nearly a third of people in the UK die in hospitals, even though most would prefer to be at home. End of Life Care and Planning empowers you to navigate this important aspect of life, ensuring your wishes are met and supporting those you love during a difficult time. This course provides a comprehensive exploration of End of Life Care and Planning, equipping you with the knowledge and confidence to make informed decisions. Learning Outcomes By the end of this End of Life Care and Planning course, you will be able to: Define End of Life Care and Planning and its core principles. Identify the different services available for End of Life Care and Planning. Comprehend the importance of Advance Care Planning and create an effective plan. Articulate the goals of End of Life Care and ensure they are aligned with your wishes. Explore the specific considerations for End of Life Care related to physical and neurological illnesses. Recognize the importance of quality care at the end of life and advocate for yourself or loved ones. End of Life Care and Planning delves into a range of crucial topics. You'll gain a strong understanding of the services available to support you and your loved ones during this sensitive time. The course emphasizes the significance of Advance Care Planning, empowering you to make your wishes known and ensure they are respected. We'll explore the goals of End of Life Care, focusing on ensuring these goals are met and reflect your values. End of Life Care and Planning also addresses the specific considerations for those facing physical and neurological illnesses. Finally, the course highlights the importance of quality care and communication at the end of life. This course equips you with the knowledge and confidence to navigate End of Life Care and Planning, promoting peace of mind for yourself and your family. Course Curriculum of End of Life Care and Planning Includes: Module 01: Introduction to End of Life Care Module 02: Availability of Services Module 03: Advance Care Planning Module 04: Goals of Care Module 05: Physical Illness Module 06: Neurological Illness Module 07: Quality Care at the End of Life Care Module 08: Communication During the End of Life Care Module 09: Palliative Care Holistic Assessment Module 10: Spiritual and Psychosocial Care Module 11: Care After Death Module 12: Further Support, Training, and Development Module 13: Legal Aspects CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This End of Life Care and Planning course is ideal for: Individuals who want to take charge of their End of Life Care and Planning. Those who care for loved ones nearing the end of life. Healthcare professionals seeking to enhance their understanding of End of Life Care. Social workers, counselors, and spiritual caregivers who support individuals facing end-of-life issues. Anyone interested in gaining a deeper understanding of death, dying, and End of Life Care. Requirements There are no prerequisites for this End of Life Care and Planning course. All learners with an interest in End of Life Care and Planning are welcome. Career path Upon completion of the End of Life Care and Planning course, you will be able to: Palliative care specialist Hospice care worker Bereavement counselor Social worker End-of-life doula Funeral director Policy and advocacy roles in End of Life Care and Planning This End of Life Care and Planning course is a valuable first step towards a fulfilling career in this important field. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Description: Do you love art? Want to know the techniques of Pencil art and sketch? Then enrol the Pencil Art and Sketching Diploma course and explore the techniques of pencil art and sketching. The course is divided into two parts - at first, you will learn about the techniques and skills of art and painting such as how to paint, types of brush, choose the right brush, etc. Then the course teaches you how to draw sketches. After finishing the course, it is hoped that you will be able to art using [pencil and able to do sketches. Who is the course for? Artists or painters who want home paintings as a business. People who have an interest in professional painting Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Pencil Drawing INTRODUCTION 01:00:00 BRIEF HISTORY OF PENCIL DRAWING 00:15:00 GETTING STARTED 01:00:00 LEARNING THE BASICS OF DRAWING AND SKETCHING 01:00:00 Basic Perspectives on Drawing 01:00:00 Basic Elements of Light, Shadows, and Shading 01:00:00 Different Shading Techniques 00:15:00 How to Add Tones and Values? 00:30:00 FINISHING TOUCHES 00:30:00 MIXED MEDIA APPLICATIONS 01:00:00 Drawing with Pencils in Oil Painting 01:00:00 CONCLUSION 00:15:00 Sketch Drawing Starting With Pencil Drawing and the Great Tips 00:30:00 A Good Drawing Artist and the Qualities 00:30:00 How to Become a Professional Drawing Artist 00:30:00 Drawing Artist 00:30:00 Different Techniques Used by Drawing Artist 00:30:00 Business Start Your Own Art Business 00:15:00 Steps to Creating a Successful Business from Your Art 01:00:00 How to Write an Artist Business Plan 00:30:00 Mock Exam Mock Exam- Pencil Art and Sketching Diploma 00:30:00 Final Exam Final Exam- Pencil Art and Sketching Diploma 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Develop the crucial skills to support others on their journey to emotional well-being with the Counselling Skills Training Diploma. Learn active listening, empathy building, and effective communication techniques to empower individuals and navigate challenging situations. This diploma equips you with a strong foundation for personal growth and potential career paths in helping professions.

Discover the thrilling world of artificial intelligence with the 'Machine Learning Course with Python'. Immerse yourself in a voyage from foundational concepts, unveiling the mysteries behind algorithms, to diving deep into the cores of preprocessing, regression, and classification. Crafted meticulously, this course introduces Python as the catalyst, opening doors to data-driven decision-making and predictive analysis, empowering your journey in the ever-evolving field of machine learning. Learning Outcomes Grasp the foundational knowledge of various machine learning algorithms. Attain proficiency in preprocessing data for optimal outcomes. Master the nuances of regression analysis using Python. Delve into the intricacies of classification techniques. Enhance problem-solving abilities with practical Python-driven machine learning applications. Why choose this Machine Learning Course with Python course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Machine Learning Course with Python Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Machine Learning Course with Python course for? Aspiring data scientists eager to harness the power of machine learning. Python enthusiasts aiming to delve into its applications in AI. Professionals in the tech industry seeking a transition into data roles. Academics and researchers wanting to employ machine learning in their work. Business analysts aiming to leverage predictive analytics for better insights. Career path Data Scientist: £40,000 - £70,000 Machine Learning Engineer: £50,000 - £80,000 AI Researcher: £45,000 - £75,000 Data Analyst: £30,000 - £50,000 Python Developer: £35,000 - £65,000 Business Intelligence Developer: £40,000 - £60,000 Prerequisites This Machine Learning Course with Python does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Machine Learning Course with Python was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Machine Learning Algorithms Introduction to types of ML algorithm 00:02:00 Module 02: Preprocessing Importing a dataset in python 00:02:00 Resolving Missing Values 00:06:00 Managing Category Variables 00:04:00 Training and Testing Datasets 00:07:00 Normalizing Variables 00:02:00 Normalizing Variables - Python Code 00:03:00 Summary 00:01:00 Module 03: Regression Simple Linear Regression - How it works? 00:04:00 Simple Linear Regreesion - Python Implementation 00:07:00 Multiple Linear Regression - How it works? 00:01:00 Multiple Linear Regression - Python Implementation 00:09:00 Decision Trees - How it works? 00:05:00 Random Forest - How it works? 00:03:00 Decision Trees and Random Forest - Python Implementation 00:04:00 Module 04: Classification kNN - How it works? 00:02:00 kNN - Python Implementation 00:10:00 Decision Tree Classifier and Random Forest Classifier in Python 00:10:00 SVM - How it works? 00:04:00 SVM - Python Implementation 00:06:00 Assignment Assignment - Machine Learning Course with Python 00:00:00

Overview Learn the key to successful project management and how to implement PRINCE2 methodology, with this complete Project and Operation Management! The Project and Operation Management is ideal for aspiring professionals preparing for their PMP exam and anyone looking to kickstart a career in this field. You will learn up-to-date industry knowledge to drive your career forward, including techniques and strategies used by experienced professionals.  This qualification is industry-recognised to ensure you get the best out of your learning experience. Get certified online and take with you a new set of skills to add to your CV! Why buy this Project and Operation Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Project and Operation Management you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Project and Operation Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Project and Operation Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Project and Operation Management is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Introduction & Overview Introduction & Overview 00:16:00 Tools You Need 00:19:00 Module 02: Teams & Leadership Teams & Leadership 00:35:00 Teams 00:33:00 Conflict 00:35:00 Module 03: Project Communication Project Communication 00:25:00 Didactic Communications 00:22:00 Basic Meeting Rules 00:21:00 Module 04: Stakeholder Management Stakeholder Management 00:19:00 Module 05: The Basics of Project Management The Basics of Project Management 00:19:00 Project Needs 00:21:00 Module 06: Scope and Requirements Scope and Requirements 00:28:00 Work Breakdown Structures 00:27:00 Displayed Thinking 00:31:00 Module 07: Developmental Methodologies Developmental Methodologies 00:25:00 Methodology Types 00:26:00 Selecting a Methodology 00:22:00 Module 08: Effective Budgets & Schedules Effective Budgets & Schedules 00:25:00 Resource Estimating 00:26:00 Estimating Techniques 00:26:00 Module 09: Project Performance Project Performance 00:25:00 The Keys to Success 00:23:00 Project Performance Key Values 00:24:00 Module 10: Change Management Change Management 00:16:00 Mock Exam Mock Exam - Project and Operation Management 00:20:00 Final Exam Final Exam - Project and Operation Management 00:20:00