17828 Courses in Leicester delivered Online

Tai Chi Progressive Course for Beginners, Intermediate and Advanced students and all those interested in Tai Chi and QiGong

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 2019 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course. Access 2019 Intermediate Module 01: Introduction to the Course 00:02:00 Module 02: Reviewing Table Design Principles 00:11:00 Module 03: Setting Field Size, Formats and Captions 00:09:00 Module 04: Setting Default Values and Required Fields 00:06:00 Module 05: Restricting Data Entry-Validation Rules 00:06:00 Module 06: Restricting Data Entry-Input Masks 00:07:00 Module 07: Exploring Tables and Queries to Excel 00:04:00 Module 08: Exporting Data to a SharePoint List 00:02:00 Module 09: Importing Data from Excel 00:06:00 Module 10: Importing Data from a Sharepoint List 00:02:00 Module 11: Linking External Data Sources 00:06:00 Module 12: Using Word Merge 00:07:00 Module 13: What are Action Queries 00:03:00 Module 14: Creating an Update Query 00:06:00 Module 15: Creating an Append Query 00:04:00 Module 16: Creating a Delete Query 00:05:00 Module 17: Creating a Make Table Query 00:04:00 Module 18: Changing Start Number of an Auto Number Field 00:04:00 Module 19: Modifying Query Joins 00:09:00 Module 20: Using Self Joins to Combine Data 00:06:00 Module 21: Creating Find Unmatched and Find Duplicate Queries 00:09:00 Module 22: Creating Parameter Queries 00:07:00 Module 23: Creating a Top X Query 00:03:00 Module 24: Reviewing Calculated Query Fields 00:05:00 Module 25: Summarising Query Data with Totals 00:05:00 Module 26: Creating a Crosstab Query 00:07:00 Module 27: Understanding Macro Basics 00:14:00 Module 28: Creating Macros to Open Forms by Record 00:08:00 Module 29: Validating Data Entry with Macros 00:09:00 Module 30: Creating a Macro to Automate Data Entry 00:08:00 Module 31: Advanced Data Entry Using Macros and DLOOKUP Functions 00:09:00 Module 32: Using Conditional Formatting 00:04:00 Module 33: Working with the New Label Name Property 00:02:00 Module 34: Organising Form Fields with Tab Controls 00:05:00 Module 35: Creating an Option Group Control 00:06:00 Module 36: Creating a Combo Box Control 00:05:00 Module 37: Configuring a Combo Box Control to Show Search Results 00:04:00 Module 38: Using a Subform to Show Data from a Related Table 00:05:00 Module 39: Inserting a Chart on a Report 00:07:00 Module 40: Showing Data in Columns 00:08:00 Module 41: Inserting a Subreport 00:04:00 Module 42: Configuring Reports with Parameter Queries 00:05:00 Module 43: Sending Reports 00:02:00

Overview This comprehensive course on jQuery: JavaScript and AJAX Coding Bible will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This jQuery: JavaScript and AJAX Coding Bible 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 jQuery: JavaScript and AJAX Coding Bible. It is available to all students, of all academic backgrounds. Requirements Our jQuery: JavaScript and AJAX Coding Bible 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 10 sections • 86 lectures • 05:06:00 total length •Introduction To This Course: 00:02:00 •Setup on Windows: 00:03:00 •Setup on Mac OS X: 00:03:00 •Setup on Linux: 00:05:00 •Online Code IDE: 00:02:00 •Uncompressed vs Minified vs Slim vs Slim Minified: 00:05:00 •Document Ready: 00:03:00 •Elements: 00:03:00 •All Elements: 00:02:00 •This Keyword: 00:03:00 •ID: 00:02:00 •Class: 00:02:00 •Multiple Items: 00:03:00 •First Element: 00:02:00 •Odd/Even: 00:06:00 •Element and Class: 00:02:00 •Children: 00:04:00 •Attributes: 00:03:00 •Type: 00:04:00 •Contains: 00:03:00 •Get Attribute: 00:02:00 •Set Attribute: 00:03:00 •Set Attribute With Callback Function: 00:03:00 •Set Multiple Attributes: 00:03:00 •Remove: 00:02:00 •Text Attribute: 00:02:00 •Data Attribute: 00:03:00 •Value: 00:03:00 •HTML Value: 00:02:00 •Class: 00:02:00 •Binding & Unbinding: 00:07:00 •Attributes: 00:03:00 •Propagation: 00:05:00 •Prevent Default Behaviour: 00:05:00 •Mouse Single Click: 00:02:00 •Mouse Double Click: 00:02:00 •Mouse Enter Element: 00:04:00 •Mouse Leave Element: 00:04:00 •Mouse Hover: 00:04:00 •Mouse Down: 00:03:00 •Mouse Up: 00:02:00 •Keyboard Down: 00:03:00 •Keyboard Press: 00:01:00 •Keyboard Up: 00:01:00 •Form Submit: 00:03:00 •Form Change: 00:03:00 •Form Focus: 00:04:00 •Form Blur: 00:02:00 •Document/Window Scroll: 00:03:00 •Document/Window Resize: 00:02:00 •Combining Multiple Events Using A Single Selector: 00:05:00 •Get and Set CSS Property: 00:03:00 •Set Multiple CSS Properties: 00:02:00 •Add, Remove and Toggle CSS Classes: 00:06:00 •Get and Set Element Dimensions: 00:12:00 •Adding Elements Using Append, Prepend, After and Before: 00:05:00 •Removing Elements Using Remove and Empty: 00:06:00 •Elements By Index: 00:03:00 •Child Elements: 00:03:00 •Parent Element: 00:03:00 •Sibling Elements: 00:03:00 •Filtering Elements: 00:06:00 •Show, Hide and Toggle: 00:11:00 •Fading Using FadeIn, FadeOut, FadeToggle and FadeTo: 00:06:00 •Sliding Using SlideDown, SlideUp and SlideToggle: 00:06:00 •Animate: 00:09:00 •Stop Effects and Animations: 00:03:00 •Function Callback: 00:03:00 •Action and Method Chaining: 00:05:00 •Load: 00:05:00 •Get JSON: 00:04:00 •GET Data: 00:04:00 •POST Data: 00:05:00 •Trim String: 00:03:00 •Extend: 00:03:00 •Extend Function: 00:07:00 •In Array: 00:04:00 •Each: 00:03:00 •Data Function: 00:05:00 •Proxy Function: 00:03:00 •Is Window Function: 00:01:00 •Now/Epoch Time Method: 00:02:00 •Number Check (isNumeric): 00:02:00 •Dequeue: 00:03:00 •Global Evaluation: 00:02:00 •Resource: 00:00:00

Overview This comprehensive course on jQuery: JavaScript and AJAX Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This jQuery: JavaScript and AJAX Coding 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 jQuery: JavaScript and AJAX Coding. It is available to all students, of all academic backgrounds. Requirements Our jQuery: JavaScript and AJAX Coding 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 11 sections • 87 lectures • 05:14:00 total length •Introduction To This Course: 00:02:00 •Setup on Windows: 00:03:00 •Setup on Mac OS X: 00:03:00 •Setup on Linux: 00:05:00 •Online Code IDE: 00:02:00 •Uncompressed vs Minified vs Slim vs Slim Minified: 00:05:00 •Document Ready: 00:03:00 •Elements: 00:03:00 •All Elements: 00:02:00 •This Keyword: 00:03:00 •ID: 00:02:00 •Class: 00:02:00 •Multiple Items: 00:03:00 •First Element: 00:02:00 •Odd/Even: 00:06:00 •Element and Class: 00:02:00 •Children: 00:04:00 •Attributes: 00:03:00 •Type: 00:04:00 •Contains: 00:03:00 •Get Attribute: 00:02:00 •Set Attribute: 00:03:00 •Set Attribute With Callback Function: 00:03:00 •Set Multiple Attributes: 00:03:00 •Remove: 00:02:00 •Text Attribute: 00:02:00 •Data Attribute: 00:03:00 •Value: 00:03:00 •HTML Value: 00:02:00 •Class: 00:09:00 •Binding & Unbindin: 00:07:00 •Attributes: 00:04:00 •Propagation: 00:05:00 •Prevent Default Behaviour: 00:05:00 •Mouse Single Click: 00:02:00 •Mouse Enter Element: 00:04:00 •Mouse Leave Element: 00:04:00 •Mouse Hover: 00:04:00 •Mouse Down: 00:03:00 •Mouse Up: 00:02:00 •Keyboard Down: 00:03:00 •Keyboard Press: 00:01:00 •Keyboard Up: 00:01:00 •Form Submit: 00:03:00 •Form Change: 00:03:00 •Form Focus: 00:04:00 •Form Blur: 00:02:00 •Document/Window Scroll: 00:03:00 •Document/Window Resize: 00:02:00 •Combining Multiple Events Using A Single Selector: 00:05:00 •Get and Set CSS Property: 00:03:00 •Set Multiple CSS Properties: 00:02:00 •Add, Remove and Toggle CSS Classes: 00:06:00 •Get and Set Element Dimensions: 00:12:00 •Adding Elements Using Append, Prepend, After and Before: 00:05:00 •Removing Elements Using Remove and Empty: 00:06:00 •Elements By Index: 00:03:00 •Child Elements: 00:03:00 •Parent Element: 00:03:00 •Sibling Elements: 00:03:00 •Filtering Elements: 00:06:00 •Show, Hide and Toggle: 00:11:00 •Fading Using FadeIn, FadeOut, FadeToggle and FadeTo: 00:06:00 •Sliding Using SlideDown, SlideUp and SlideToggle: 00:06:00 •Animate: 00:09:00 •Stop Effects and Animations: 00:03:00 •Function Callback: 00:03:00 •Action and Method Chaining: 00:05:00 •Load: 00:05:00 •Get JSON: 00:04:00 •GET Data: 00:04:00 •POST Data: 00:05:00 •Trim String: 00:03:00 •Extend: 00:03:00 •Extend Function: 00:07:00 •In Array: 00:04:00 •Each: 00:03:00 •Data Function: 00:05:00 •Proxy Function: 00:03:00 •Is Window Function: 00:01:00 •Now/Epoch Time Method: 00:02:00 •Number Check (isNumeric): 00:02:00 •Dequeue: 00:03:00 •Global Evaluation: 00:02:00 •Assignment - jQuery: JavaScript and AJAX Coding: 00:00:00 •Resource: 00:00:00 •Mouse Double Click: 00:02:00

Persuasion skills are the essential element of being able to influence others to achieve your goals and objectives. Some people seem to be able to persuade effortlessly, whereas others fall back on the strength of their state to enforce what they desire. In reality, persuasion skills can be studied just like any other skills. The focus of this The Psychology of Persuasion and Influence with Phil Hesketh course is to improve your communication skills to succeed in both of your business and personal life. You'll grasp the abundance of theories that help you become a successful persuader. You'll also understand how to remain motivated and believe in yourself and your ideas. Understanding the fundamentals will enable you to be much more successful in persuading and influencing others. Upon successful completion of the course, you have the confidence and power to make people believe in what you're saying. What Will I Learn? A deeper understanding of psychological drivers A better understand how we form opinions How to understand body language How to deal with difficult interactions How to improve relationships Requirements A willingness to learn An open mind Who is the target audience? This course is ideal for anybody serious about upgrading the quality of their human interactions, whether at home or at work Anybody who is ambitious and would like to climb the career ladder Anybody who would like to become more influential and persuasive   Introduction What You Will Learn on This Course FREE 00:01:00 Who is Philip Hesketh? 00:01:00 Our Seven Fundamental Psychological Drivers Psychological Drivers: 1 - Love, 2 - Importance & 3 - Belonging 00:04:00 Psychological Drivers: 4 - Belief 00:03:00 Psychological Drivers: 5 - Certainty & Uncertainty 00:05:00 Psychological Driver: 6 - Need for Growth 00:03:00 Psychological Driver: 7 - Need for a Place 00:04:00 Why We Do What We Do and How We Form Opinions First Impressions ~ How They're Formed and How to Form a Good One 00:04:00 The 'Facts, Feelings and After Effects' of Every Conversation 00:06:00 How to Get People to Jump Through Hoops like a Dolphin 00:04:00 The Psychological Difference Between Persuasion and Influence 00:03:00 The Importance of Understanding How People Have Beliefs and How Placebos Work 00:04:00 Body Language: Reading It and Interpreting It How to Read Body Language and the 'Tells' 00:04:00 The Difference Between 'Intent' and 'Impact' 00:03:00 How to Work out What People Really Mean When They Say Certain Things 00:04:00 The Big Difference That Little Words Can Make 00:03:00 How to Tell When People Are Lying and What to Do About It 00:03:00 How to Handle Difficult People with a Smile How to Put Things Right When You've Put Things Wrong 00:04:00 The Principles of Objection Handling 00:03:00 The Importance of Being Part of the Solution 00:05:00 Constructive Criticism 00:03:00 How to Handle Difficult Situations During and After the Event 00:05:00 How to keep improving relationships How The Roman Empire, The Beatles, and the Titanic really failed 00:05:00 How and why all relationships and companies follow the same course 00:05:00 How to keep improving even the best relationships 00:05:00 How relationships develop and how to relate to people How to develop trust and how to measure it 00:05:00 How get on with everyone better 00:04:00 How to understand people better and the role of linear probing 00:04:00 How to improve all your relationships in the long term 00:03:00 Conclusion What we've covered so far 00:02:00 Next Steps 00:01:00 Course Certification

Description: Nowadays data management is absolutely crucial, and there's not much room for error. If you've already taken the basic Microsoft Access 2013 course, or know your way around the program already, then you're ready for this advanced level of Microsoft Access 2013. This Microsoft Office 2013 Access Advanced - Complete Video Course covers advanced functions and features of Access 2013. You will learn about implementing advanced form design, using data validation and using macros to improve user interfacer design. You will also learn how to use advanced database management, distribute and secure a database and manage switchboards. If you want to take your Microsoft Access 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Access Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Access Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. 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. Implementing Advanced Form Design Add Controls to Forms FREE 00:22:00 Create Subforms 00:03:00 Organize Information with Tabs Pages 00:05:00 Enhance Navigation of Forms 00:06:00 Apply Conditional Formatting 00:05:00 Using Data Validation Field and Record Validation 00:23:00 Form Validation 00:08:00 Using Macros to Improve User Interface Design Create a Macro 00:17:00 Restrict Records Using a Condition 00:05:00 Validate Data Using a Macro 00:06:00 Automate Data Entry Using a Macro 00:06:00 Convert a Macro to VBA 00:05:00 Using Advanced Database Management Link Tables to External Data Sources 00:05:00 Manage a Database 00:07:00 Determine Object Dependency 00:05:00 Document a Database 00:05:00 Analyze the Performance of a Database 00:05:00 Distributing and Securing a Database Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:09:00 Set Passwords 00:07:00 Convert an Access Database to an ACCDE File999 00:07:00 Analyze the Performance of a Database 00:04:00 Managing Switchboards Create a Database Switchboard 00:07:00 Modify a Database Switchboard 00:04:00 Set Startup Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Master Angular and Dart (AngularDart) and build high-performance, flexible, and dynamic web apps

Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!

https://www.instagram.com/masterpeacelondon/

Level 3 Award in Education and Training: Elevate your career as a certified educator! Gain essential teaching skills, curriculum expertise, and effective classroom management. Flexible study options with ongoing support. Enrol now to advance your teaching journey