Overview This comprehensive course on Microsoft Access Tables and Queries will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Access Tables and Queries comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Access Tables and Queries. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Access Tables and Queries is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 20 lectures • 03:32:00 total length •Tour of the screen: 00:11:00 •Using Design view to create and edit tables: 00:45:00 •Using the lookup wizard: 00:09:00 •Importing data from Other Data Sources into Access: 00:18:00 •Linking Tables from Other data Sources into Access: 00:10:00 •Exporting data from Access to other data types: 00:03:00 •Creating and Managing Table Relationships: 00:10:00 •Database Tools: 00:05:00 •Sort and Filter a Table: 00:06:00 •Basic Queries: 00:22:00 •Prompting the user for the criteria: 00:05:00 •Creating Calculated Fields in a Query: 00:10:00 •Creating Totals Queries: 00:08:00 •Multiple table Queries: 00:12:00 •Viewing the SQL code for an Access Query: 00:06:00 •Using the Query Wizards: 00:09:00 •Creating Subqueries: 00:03:00 •Creating Make Table, Append, Update and Delete Queries: 00:19:00 •Displaying a certain number of records: 00:01:00 •Assignment - Microsoft Access Tables and Queries: 00:00:00
Overview Get ready to bake, and become skilled enough to create cakes that aren't just delicious but are also works of art. This Sophisticated Baking and Cake Decorating Level 2 course will take your baking skills to the next level and train you to design and serve immaculately decorated treats. You will receive the expert tuition that you'll need to successfully choose a design that fits the event, make the icing and fondant, produce stunning decorations, and assemble everything into a show-stopping centrepiece. Make creative cakes that will bring celebrations and parties to life, and cement your reputation as a star baker. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Sophisticated Baking and Cake Decorating Level 2. It is available to all students, of all academic backgrounds. Requirements Our Sophisticated Baking and Cake Decorating Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 6 lectures • 01:11:00 total length •Module 01: Sophisticated Baking & Cake Design: 00:13:00 •Module 02: Icing: 00:15:00 •Module 03: Fondant Making: 00:12:00 •Module 04: Decorating with Fondant: 00:13:00 •Module 05: Everything in Brief: 00:13:00 •Assignment - Sophisticated Baking and Cake Decorating Level 2: 00:05:00
QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support
Overview This comprehensive course on AutoCAD Programming using VB.NET with Windows Forms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming using VB.NET with Windows Forms comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this AutoCAD Programming using VB.NET with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using VB.NET with Windows Forms is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 61 lectures • 09:51:00 total length •Module 01: Course Outline: 00:03:00 •Module 02: Introduction: 00:05:00 •Module 03: Who is this course for?: 00:04:00 •Module 04: Tools Needed for this Course: 00:01:00 •Module 01: What will you learn from this Course - Overview: 00:06:00 •Module 01: Windows Form and Controls - Overview: 00:04:00 •Module 02: ControlsDemo Project - Overview: 00:03:00 •Module 03: ControlsDemo Project - Creating the Project: 00:04:00 •Module 04: Controls Demo Project - Designing the Form: 00:19:00 •Module 05: ControlsDemo Project - Creating the Utility Class: 00:10:00 •Module 06: ControlsDemo Project - Coding the Combobox Control: 00:15:00 •Module 07: ControlsDemo Project - Coding the Textbox Control: 00:10:00 •Module 08: ControlsDemo Project - Coding the Radiobutton Control: 00:08:00 •Module 09: ControlsDemo Project - Coding the Checkbox Control: 00:17:00 •Module 01: Draw Rectangle Project - Overview: 00:03:00 •Module 02: Creating the DrawRectangle Project: 00:04:00 •Module 03: DrawRectangle Project - Creating the Utility Class: 00:20:00 •Module 04: DrawRectangle Project - Designing the Form: 00:15:00 •Module 05: DrawRectangle Project - Coding the User Interface Part 1: 00:24:00 •Module 06: DrawRectangle Project - Coding the User Interface Part 2: 00:18:00 •Module 07: DrawRectangle Project - Running the Program: 00:06:00 •Module 08: Automate Update Layer Project - Overview: 00:02:00 •Module 09: Creating the AutomateUpdateLayer Project: 00:03:00 •Module 10: Automate Update Layer Project - Creating the Utility Class: 00:17:00 •Module 11: AutomateUpdateLayer Project - Designing the User Interface: 00:07:00 •Module 12: AutomateUpdateLayer Project - Coding the Form: 00:18:00 •Module 13: AutomateUpdateLayer Project - Running the Program: 00:07:00 •Module 14: Automatic Block Extractor Project - Overview: 00:03:00 •Module 15: AutomaticBlockExtractor Project - Creating the Project: 00:03:00 •Module 16: AutomaticBlockExtractor Project - Creating the User Interface: 00:09:00 •Module 17: AutomaticBlockExtractor Project - Coding the Form: 00:27:00 •Module 18: AutomaticBlockExtractor Project - Creating the Utility Class: 00:27:00 •Module 19: AutomaticBlockExtractor Project - Running the Program: 00:10:00 •Module 20: AutomateUpdateTextStyles Project - Overview: 00:03:00 •Module 21: AutomateUpdateTextStyle Project - Creating the Project: 00:02:00 •Module 22: AutomateUpdateTextStyle Project - Creating the User Interface: 00:09:00 •Module 23: AutomateUpdateTextStyle Project - Coding the Form: 00:20:00 •Module 24: AutomateUpdateTextStyle Project - Coding the Utility Class: 00:16:00 •Module 25: AutomateUpdateTextStyle Project - Running the Program: 00:08:00 •Module 26: Multiple Plot DWG to PDF Project - Overview: 00:03:00 •Module 27: MultiplePlotDWGtoPDF Project - Creating the Project: 00:04:00 •Module 28: MultiplePlotDWGtoPDF Project - Creating the User Interface: 00:09:00 •Module 29: MultiplePlotDWGtoPDF Project - Coding the Form: 00:20:00 •Module 30: MultiplePlotDWGtoPDF Project - Creating the Utility Class: 00:30:00 •Module 31: MultiplePlotDWGtoPDF Project - Running the Program: 00:13:00 •Module 32: Multiple Object Extractor Project - Overview: 00:03:00 •Module 33: MultipleObjectExtractor Project - Creating the Project: 00:02:00 •Module 34: MultipleObjectExtractor Project - Creating the User Interface: 00:15:00 •Module 35: MultipleObjectExtractor Project - Coding the Form Load Event: 00:05:00 •Module 36: MultipleObjectExtractor Project - Coding the Browse Buttons: 00:10:00 •Module 37: MultipleObjectExtractor Project - Coding the Extract Button: 00:20:00 •Module 38: MultipleObjectExtractor Project - Coding the ProcessDrawing Method: 00:09:00 •Module 39: MultipleObjectExtractor Project - Coding the ProcessObjectExtraction Method: 00:11:00 •Module 40: MultipleObjectExtractor Project - Coding the ExtractLine Method: 00:09:00 •Module 41: MultipleObjectExtractor Project - Coding the ExtractCircle Method: 00:03:00 •Module 42: MultipleObjectExtractor Project - Coding the ExtractPolyline Method: 00:09:00 •Module 43: MultipleObjectExtractor Project - Coding the ExtractMText Method: 00:05:00 •Module 44: MultipleObjectExtractor Project - Coding the ExtractBlock Method: 00:05:00 •Module 45: MultipleObjectExtractor Project - Running the Program: 00:15:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming using VB.NET with Windows Forms: 00:00:00
Overview This comprehensive course on Fraud Awareness and Prevention Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Fraud Awareness and Prevention Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Fraud Awareness and Prevention Training. It is available to all students, of all academic backgrounds. Requirements Our Fraud Awareness and Prevention Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 6 lectures • 01:16:00 total length •Becoming a Fraud Investigator: 00:11:00 •Managing Risk and Identifying Fraud: 00:16:00 •The Principles of Fraud Prevention: 00:11:00 •Detecting Fraud and Finding Evidence: 00:14:00 •Fraud Investigation and Response: 00:11:00 •UK Laws and Legislation Regarding Fraud: 00:13:00
Overview This comprehensive course on Inspirational Leadership Skills: Practical Motivational Leadership will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Inspirational Leadership Skills: Practical Motivational Leadership comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Inspirational Leadership Skills: Practical Motivational Leadership. It is available to all students, of all academic backgrounds. Requirements Our Inspirational Leadership Skills: Practical Motivational Leadership is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 8 lectures • 02:39:00 total length •Module 01: Developing the Leader Within You: 00:21:00 •Module 02: Emotional Intelligence in Leadership: 00:17:00 •Module 03: Communication Skills: 00:26:00 •Module 04: Public Speaking: 00:30:00 •Module 05: Critical Thinking in Problem-Solving and Decision Making: 00:23:00 •Module 06: Motivation and Counselling: 00:16:00 •Module 07: Management and Leadership: 00:26:00 •Assignment - Inspirational Leadership Skills: Practical Motivational Leadership: 00:00:00
Overview This comprehensive course on Higher Technician in Cooking and Gastronomy will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector.This Higher Technician in Cooking and Gastronomy comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Higher Technician in Cooking and Gastronomy. It is available to all students, of all academic backgrounds. Requirements Our Higher Technician in Cooking and Gastronomy is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 9 lectures • 03:32:00 total length •Module 01: An Introduction to Gastronomy: 00:17:00 •Module 02: Gastronomic Concepts: 00:23:00 •Module 03: Thermal Processing of Food: 00:29:00 •Module 04: Meat Preservation and Processing: 00:36:00 •Module 05: Preservation and Processing of Fish: 00:25:00 •Module 06: Culinary Techniques- Meat Preparation: 00:22:00 •Module 07: Culinary Techniques-Fish Preparation: 00:18:00 •Module 08: Physical, Chemical and Allergenic Hazards: 00:28:00 •Module 09: Reopening and Adapting Your Food Business during COVID-19: 00:14:00
Overview This comprehensive course on CPR (Cardiopulmonary Resuscitation) Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CPR (Cardiopulmonary Resuscitation) Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this CPR (Cardiopulmonary Resuscitation) Training. It is available to all students, of all academic backgrounds. Requirements Our CPR (Cardiopulmonary Resuscitation) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 7 lectures • 01:17:00 total length •Introduction to CPR: 00:04:00 •Procedure for CPR: 00:04:00 •Dealing with Unconsciousness and Providing CPR: 00:06:00 •Breathing Problems and Aid: 00:05:00 •Workbook - CPR (Cardiopulmonary Resuscitation) Training: 00:46:00 •Additional Video Materials - CPR (Cardiopulmonary Resuscitation) Training: 00:00:00 •Additional Reading Materials - CPR (Cardiopulmonary Resuscitation) Training: 00:12:00
Become a skilled Lab Technician with our Lab Technician Online Course. Master essential skills, laboratory techniques, and equipment operation to excel in medical lab services. Enrol now for hands-on training and earn a globally recognised CPD certificate!
Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00