4288 Courses in Liverpool delivered Online

Introduction Introduction 00:02:00 Geometry Lines and Angles (Basics) 00:07:00 Parallel lines (Basics) 00:06:00 Practice Problems 1 (Lines and Angles) 00:06:00 Triangles (Basics) 00:11:00 Practice Problems 2 (angle sum and exterior angle Property) 00:10:00 Pythagoras Theorem 00:13:00 Inequalities in Triangles 00:06:00 Sine and Cosine Rule 00:12:00 Median, Altitude, Angle bisector 00:06:00 Practice Problems 3 00:11:00 Properties of Medians 00:09:00 Practice Problems 4 00:07:00 Properties of Equilateral Triangles 00:04:00 Some special Quadrilaterals 00:08:00 Polygons-interior angles, diagonals etc. 00:08:00 Angle Bisector Theorem 00:07:00 Congruent Triangles 00:06:00 Similar Triangles 00:14:00 Practice Problems 5 00:10:00 Circle 00:10:00 Cyclic Quadrilateral _ Tangent to circle 00:07:00 Areas Areas of Parallelogram & Triangle 1 00:10:00 Areas of Parallelogram _ Triangle 2 00:10:00 Practice Problems based on Areas 1 00:05:00 Practice Problems based on Areas 2 00:12:00 Mensuration of 2 dimensional figures Mensuration Formulae 00:07:00 Practice problems on 2-d figures 00:11:00 Assignment (Video) on 2 - d figure 00:02:00 Areas related to the circle 00:05:00 Practice questions on areas related to circle 00:10:00 Practice Test (Check your knowledge of Geometry) Practice Test (Geometry) 00:02:00 Concept of Unit Digit Lecture 32 What is Unit Digit? 00:40:00 How to find unit digit of numbers with exponents 00:10:00 Practice Problems based on Unit Digit 00:08:00 Simplification Problems-1 Simplifications based on Percentages 00:11:00 Simplification based on Exponents 00:12:00 Fastest method of finding square roots 00:12:00 Fastest method of finding cube roots 00:03:00 Simplification based on square and cube roots 00:16:00 Lecture 40 Simplification Problems 00:50:00 Crack Simplification problems-2 Lecture 41 Simplification problems Type 1 00:10:00 Simplification problems Type 1 00:08:00 Simplification problems Type 2 00:08:00 Simplification problems Type 3 00:08:00 Simplification problems Type 4 00:07:00 Finding smallest and greatest from difficult exponents 00:08:00 Simplification using Digital sum What is Digital sum 00:05:00 Lecture 44 What is Digital sum? 00:10:00 How to apply Digital sum technique in different operations 00:14:00 Simplification problems using Digital sum -1 00:07:00 Simplification problems using Digital sum -2 00:06:00 Time and Work Lecture 49 Simplification problems using Digital sum -2 00:06:00 Lecture 50 Resources download 1 00:55:00 Problems based on persons, days, work and hours 00:12:00 Short cut formulas for most common problems 00:11:00 Problems based on Two Persons 00:06:00 Problems based on three Persons 00:10:00 Based on Efficiency 00:13:00 Complex problems on Efficiency 00:10:00 Fraction of work 00:07:00 Leaving and Joining - 1 00:06:00 Men, women and boys 00:05:00 Work and wages 00:11:00 Pipes and Cisterns Lecture 62 Resources download 1 00:25:00 Basics of pipes and cisterns 00:06:00 Pipes and cisterns - Type 1 00:07:00 Pipes and cisterns - Type 2 00:04:00 Pipes and cisterns - Type 3 00:07:00 Pipes and cisterns - Type 4 00:06:00 Pipes and cisterns - Type5 00:05:00 Speed , Distance and Time Lecture 69 Speed, Distance and Time Resources download 00:40:00 Basic Concepts and simple problems 00:10:00 Problems based on average speed 00:07:00 Problems of finding Distance 00:13:00 Practice Problems 1 00:10:00 Practice Problems 2 00:08:00 Practice Problems 3 00:07:00 Boats and Streams Lecture 76 Boats and Streams 00:30:00 Basics of Boats and streams 00:10:00 Finding speed of boat or stream 00:13:00 Problems based on finding Distance 00:06:00 Latest Problems on Boat and cisterns 00:11:00 Percentage Percentage Basics 1 00:10:00 Percentage Basics 2 00:04:00 Fractional Values of Percentages 00:09:00 Lecture 84 Simplification using fractional values of Percentages-1 00:06:00 Simplification problems of Percentage 2 00:05:00 Lecture 86 Article for Resources 00:30:00 Word Problems Lecture 87 Problems based on Marks in examination 00:15:00 Problems based on Price and Quantity 1 00:08:00 Problems based on Price and Quantity 2 00:08:00 Lecture 90 Word problems based on Income 00:08:00 Lecture 91 Resources for the section 'Word Problems' 00:35:00

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

Duration 3.5 Days 21 CPD hours This course is intended for This course is aimed at students new to the language who may or may not have experience with other programming languages. Overview Learn how Python works and what it's good for. Understand Python's place in the world of programming languages Learn to work with and manipulate strings in Python. Learn to perform math operations with Python. Learn to work with Python sequences: lists, arrays, dictionaries, and sets. Learn to collect user input and output results. Learn flow control processing in Python. Learn to write to and read from files using Python. Learn to write functions in Python. Learn to handle exceptions in Python. Learn to work with dates and times in Python. In this Python training course by Webucator, Inc, students learn to program in Python. Python Basics Running Python Hello, World! Literals Python Comments Data Types Variables Writing a Python Module print() Function Named Arguments Collecting User Input Getting Help Functions and Modules Defining Functions Variable Scope Global Variables Function Parameters Returning Values Importing Modules Math Arithmetic Operators Modulus and Floor Division Assignment Operators Built-in Math Functions The math Module The random Module Seeding Python Strings Quotation Marks and Special Characters String Indexing Slicing Strings Concatenation and Repetition Common String Methods String Formatting Built-in String Functions Iterables: Sequences, Dictionaries, and Sets Definitions Sequences Unpacking Sequences Dictionaries The len() Function Sets *args and **kwargs Flow Control Conditional Statements The is and is not Operators Python's Ternary Operator Loops in Python The enumerate() Function Generators List Comprehensions File Processing Opening Files The os and os.path Modules Exception Handling Wildcard except Clauses Getting Information on Exceptions The else Clause The finally Clause Using Exceptions for Flow Control Exception Hierarchy Dates and Times Understanding Time The time Module The datetime Module Running Python Scripts from the Command Line The sys Module sys.argv

Operation Management Diploma is one of our best selling and most popular course. The Operation Management Diploma is organised into 7 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students.  If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock exams Multiple-choice assessment Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? This Operation Management Diploma Course is perfect for any individual who is just starting to work with company finances in the administration or accounting department of a large firm, or any type of organisation. It may also be used as a refresher course for existing accountants, or those that may need to use a trusted form of financial management.

Level 2 QLS Endorsed Diploma | 100 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

The truck Maintenance Course is suitable for anyone aspiring to or already working in this field or simply want to learn deeper into truck maintenance. You will be able to add this qualification to your CV by downloading your certificate instantly without any cost. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into a bite-size module for your convenience. As a result, you can study at your own pace or become accredited within hours! If you require support, our experienced tutors are always available to help. Throughout the comprehensive syllabus of this course and answer all your queries through email. What will you get from this Truck Maintenance Course? This Truck Maintenance Course will prepare you to inspect, analyze, and repair heavy-duty trucks and equipment. The course covers everything from basic diesel engine operations to computerized truck management systems. You will explore how to work effectively and safely in a heavy vehicle environment, carry out routine maintenance, and develop knowledge of materials, engine mechanical, cooling and exhaust systems. You'll understand how to efficiently diagnose, adjust, repair, or overhaul buses and trucks, or maintain and repair any type of diesel engine. You'll also learn about heating and air conditioning systems, brake systems, starting and charging systems, fuel systems, steering and suspension systems, engine systems. Who is this Truck Maintenance Course for? Truck Maintenance Course is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Truck Maintenance Course is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with the required skills to become successful. You will be able to add our qualifications to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Truck Mechanic ICE and Engine Maintenance 00:30:00 Diesel Truck Maintenance 00:30:00 Truck Drive Train Maintenance 00:30:00 Electrical System 00:15:00 Cooling System Maintenance 00:30:00 Air and Fuel Filler Service 00:15:00 Tire Maintenance and Safety 00:15:00 Break Maintenance 00:30:00 Windshield Maintenance 00:30:00 Mock Exam Mock Exam - Truck Maintenance Course 00:20:00 Final Exam Final Exam - Truck Maintenance Course 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Supercharge your career with our comprehensive RPA UiPath developer course and dive into real projects to master UiPath, gain unwavering confidence, and pave your way to success. Elevate your career prospects with access to an extensive resource of 100+ RPA UiPath interview questions and become a highly proficient RPA expert today.

Do you want to start a career in manual handling? Are you looking for training to improve your knowledge in this area? If you answered yes, you've come to the right place because our well-designed course will get you ready! With one of our most rigorous coursework, your current skills or abilities in Manual Handling Course can be strengthened. You won't regret it, we assure you. It is thought that one of the leading causes of work-related musculoskeletal diseases is a lack of manual handling knowledge. It is also to blame for more than one-third of all workplace injuries. This course will teach you how to operate in accordance with UK health and safety laws, from ensuring proper control measures to handling techniques and risk assessment. This course is particularly beneficial for warehouse and manufacturing workers, manual labourers, delivery drivers, construction workers, and farmhands. Our training program covers all of the latest and most cutting-edge aspects of manual handling careers. This excellent education program will broaden your knowledge and skills by covering topics ranging from basic to advanced bundle manual handling course. After completing our course, we guarantee you to be more impactful in this field. The Top 5 Manual Handling Principles for Injury Prevention that we refer to are as follows: Plan- thoroughly plan your lift. Position- correctly centre the body and feet. Pick - lift item with proper posture. Proceed - move towards the targeted position. Place- set the object down safely. Learning Outcomes After completing bundle Manual Handling Course successfully, you will be able to - Recognise the various types of work equipment and the associated risks. Recognise the most prevalent manual handling hazards. Know the guidelines put forth by MHOR's legal rules. Make a list of all the information you will use for a report on an accident or event. Reduce occupational risks. Recognise the most effective postures and the heaviest weights available in the surroundings. Why Choose Manual Handling Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Manual Handling Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. *****Course Included***** Main Course: Manual Handling Course **Free Courses** Course 01: Level 2 Fire Safety Course 02: Level 3 HACCP Training Course ***Others*** Free 3 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Manual Handling Course] This bundle course will teach you all five of them. You'll also learn about jobs that require heavy lifting or transportation of heavy goods, as well as jobs that require manual handling. You will also be introduced to advanced manual handling techniques, which will equip you with the knowledge and skills needed to maintain safe handling attitudes and use mechanical aids to help the process. Also, in our course, the learner is going to acquire an adequate understanding of manual handling of loads, the musculature, and rheumatic conditions, identify hazards, perform risk assessment related to this sector, and gain insight into risk contributing elements. This Manual Handling course helps businesses make sure that both their employees and themselves have received the necessary instruction in the principles and techniques of safe manual handling. Identifying experts who are at risk of damage, comprehending the basic principles of human movement, using the proper lifting techniques, and guidance on avoiding dangers are all covered in our Manual Handling course. This Manual Handling course is designed to provide a thorough comprehension of the nature of the related sector and the key roles that exist within it. It teaches all of the most relevant topics and changes to help you progress in the job market and be a better fit for your chosen Manual career. The training materials for this course are available online, allowing you to learn at your own pace and advance your career with ease. So, what's holding you back from earning your manual handling course certification and becoming the world's best manual handler right now? Enrol today to start your rewarding career in this field! Course Curriculum of *** Manual Handling Course *** Module 01: Introduction and Legislation What is Manual Handling? Injuries and Health Risk Benefits of Controlling Risks The Manual Handling Operations Regulations Employer Duties Employee Duties HSE Guidance Module 02: Manual Handling Injuries Types of Injury Immediate Injuries Musculoskeletal Disorders Module 03: Risk Assessments for Safe Manual Handling What is a Risk Assessment? Who Should Carry Out a Risk Assessment? Identifying Hazards Factors That Increase the Risk of Harm Deciding Who May be Harmed and How Occupations Most at Risk Evaluating Risks Recording the Significant Findings Reviewing and Updating Results of Your Risk Assessment Module 04: Avoiding and Controlling the Risks Employer Duties Avoiding Manual Handling LITE Reducing the Risk Team Handling Mechanical and Automation Precautions Personal Protective Equipment Module 05: Safe Manual Handling Techniques Lifting and Lowering Techniques Safe Weights for Lifting and Lowering Carrying Risk Assessments and HSE Tools Pushing and Pulling Assessment Method After completing each module of the Manual Handling Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for Manual Handling course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This bundle Manual Handling Course is ideal for - Warehouse Worker Factory Worker Construction Worker Office Worker Shop Assistant Delivery Driver Requirements Students who intend to enrol in Manual Handling Course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This Manual Handling course will open doors and lead you to a range of job opportunities in a variety of industries. Here are a few possibilities: £16,000 - £24,000 per year for a Warehouse Employee £15,000 - £23,000 for a factory worker £17,000 - £34,000 for a construction worker £16,000 - £25,000 for an office worker £12,000 - £21,000 as a Shop Assistant Certificates Certificate of completion Digital certificate - Included

Overview This comprehensive course on Logistics Management Training: From Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Logistics Management Training: From Beginner to Advanced 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 Logistics Management Training: From Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our Logistics Management Training: From Beginner to Advanced 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 17 sections • 75 lectures • 10:48:00 total length •Value Chain Model: 00:06:00 •Logistics Function In An Organisation: 00:09:00 •Logistics and Logistics Functions: 00:09:00 •General Information In Logistics: 00:12:00 •Logistics Functions Explanation: 00:09:00 •Logistic Functions Explanation Continues: 00:09:00 •General Introduction Of Logistics: 00:13:00 •How Logistics Can Be Applied To Business: 00:03:00 •Business EXCELLENCE Through Logistics Management: 00:08:00 •Role Of Outsourcing: 00:07:00 •Logistics Management For Business Excellence: 00:10:00 •Understanding Transportation Strategy: 00:12:00 •Objectives of Transportation: 00:02:00 •Transportation Functionality: 00:07:00 •Factors Influencing Transportation Cos: 00:11:00 •Containerization and Its Role: 00:06:00 •Understanding Role Of Inventory: 00:09:00 •Inventory Functions: 00:05:00 •Cost of Inventory: 00:06:00 •Other Types Of Inventory: 00:11:00 •Basics Of Inventory Management: 00:12:00 •Basics Of Inventory Management Continues: 00:08:00 •KANBAN: 00:02:00 •Inventory Policy Guidelines: 00:05:00 •Warehouse Management Introduction: 00:04:00 •Warehouse And Its Design: 00:05:00 •Warehouse And Its Design Continues: 00:08:00 •Warehouse Operating Principle: 00:05:00 •Strategic Decisions In Warehousing: 00:10:00 •Warehousing Strategies: 00:09:00 •Warehousing Performance Measures: 00:11:00 •Logistics Information System Introduction: 00:04:00 •Need For Logistics Information System: 00:03:00 •Information Functionality: 00:04:00 •Evaluating Logistics Information System: 00:06:00 •Application of Logistics Information System: 00:10:00 •Designing of Logistics Information System: 00:08:00 •Designing of Logistics Information System Continues: 00:07:00 •Benefits of Logistics Outsourcing: 00:18:00 •Types of Logistics Providers: 00:07:00 •Outsourcing Value Proposition: 00:07:00 •Outsourcing Management Selection Criteria: 00:07:00 •Contract Terms and Conditions: 00:04:00 •Material Handling Part 1: 00:07:00 •Material Handling Part 1 Continued: 00:08:00 •Material Handling Part 2: 00:09:00 •Material Handling Part 2 Continued: 00:05:00 •Material Storage Principles: 00:03:00 •Material Storage Methods: 00:10:00 •Material Storage System Unit Load Storage: 00:11:00 •Design of Storage system: 00:09:00 •Storage System Design Continued: 00:05:00 •Scope and Objectives Of Reverse Logistics: 00:15:00 •Design Considerations: 00:13:00 •Automatic Identification Technology: 00:15:00 •EDI standards Application and Benefits: 00:04:00 •Automated Material Handling System: 00:14:00 •Satellite Tracking ERPDRP and AITS: 00:15:00 •Objectives of E-commerce: 00:05:00 •Classes of E-commerce Applications: 00:10:00 •E-logistics In E-commerce: 00:11:00 •E-Logistics Structure and Operations: 00:04:00 •Logistics Performance Measures and Controls: 00:08:00 •Logistics Performance Measures and Controls Continued: 00:14:00 •Characteristics Of A Successful Logistical Organization: 00:14:00 •Evolution Of Logistics And Organization: 00:06:00 •Learning Approaches To Logistical Organization: 00:11:00 •Drivers Of Logistical Organization: 00:09:00 •Drivers Of Logistical Organization Continued: 00:09:00 •Scope and Scale of Global Logi: 00:10:00 •Operational Factors and Challenges in Global Logistics: 00:16:00 •CrossBorder Goods Movement: 00:12:00 •Logistics Competitive Framework: 00:16:00 •Logistics strategies Across The Product Life Cycle: 00:17:00 •Conclusion: 00:05:00

Description: This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing the project statistics, coping with delays and conflicts, and overall, learning to customise projects. In fact, through executing the project server 2010, you will gain knowledge of communicating the project information as well as combining the project data with the other relevant office applications in general. Moreover, the learners who are basically the information workers and those who want to learn the elementary level of the Access 2010 skills properly match with the very design of the course. Apart from that,the Microsoft Office 2010 Access Intermediate- Complete Video Course is basically based on the skills and ideas learned from the Access 2010.This particular course helps you learn the items such as: the relational databases, related tables,complex queries, reports and printing, charts and pivot tables and also pivot charts. The fundamental topics that have been discussed in the particular course include: learning about querying with SQL, the advanced queries, Macros, the Advanced Macros and so on. 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? Level 3 Diploma in Microsoft Access 2010 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 Level 3 Diploma in Microsoft Access 2010 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. Module 01: Beginner Getting Started Database Concepts FREE 00:04:00 Exploring the Access Environment 00:11:00 Getting Help 00:02:00 Databases and Tables Planning and Designing Databases 00:12:00 Exploring Tables 00:11:00 Creating Tables 00:33:00 Fields and Records Changing the Design of a Table 00:15:00 Finding and Editing Records 00:06:00 Organizing Records 00:16:00 Data Entry Rules Setting Field Properties 00:14:00 Working with Input Masks 00:07:00 Setting Validation Rules 00:06:00 Basic Queries Creating and Using Queries 00:13:00 Modifying Query Results and Queries 00:05:00 Performing Operations in Queries 00:17:00 Using Forms Creating Forms 00:11:00 Using Design View 00:14:00 Sorting and Filtering Records 00:04:00 Working with Reports Creating Reports 00:10:00 Modifying and Printing Reports 00:16:00 Module 02: Intermediate Relational Databases Database Normalization 00:14:00 Table Relationships 00:13:00 Referential Integrity 00:12:00 Related Tables Creating Lookup Fields 00:11:00 Modifying Lookup Fields 00:06:00 Using Subdatasheets 00:04:00 Complex Queries Joining Tables in Queries 00:26:00 Using Calculated Fields 00:09:00 Summarizing and Grouping Values 00:08:00 Advanced Form Design Adding Unbound Controls 00:08:00 Adding Graphics 00:04:00 Adding Calculated Values 00:06:00 Adding Combo Boxes 00:04:00 Advanced Form Types 00:10:00 Reports and Printing Customized Headers and Footers 00:17:00 Calculated Values 00:08:00 Calculated Values 00:08:00 Printing 00:03:00 Labels 00:05:00 Charts Charts in Forms 00:08:00 Charts in Reports 00:06:00 PivotTables and PivotCharts PivotTables 00:05:00 Modifying PivotTables 00:07:00 PivotCharts 00:04:00 PivotTable Forms 00:01:00 Module 03: Advanced Querying with SQL SQL and Access FREE 00:06:00 Writing SQL Statements 00:18:00 Attaching SQL Queries to Controls 00:06:00 Advanced Queries Creating Crosstab Queries 00:05:00 Creating Parameter Queries 00:11:00 Using Action Queries 00:17:00 Macros Creating, Running, and Modifying Macros 00:08:00 Attaching Macros to the Events of Database Objects 00:05:00 Advanced Macros Creating Macros to Provide User Interaction 00:20:00 Creating Macros that Require User Input 00:04:00 Creating AutoKeys and AutoExec Macros 00:07:00 Creating Macros for Data Transfer 00:07:00 Importing, Exporting, and Linking Importing Objects 00:14:00 Exporting Objects 00:06:00 Working with XML Documents 00:13:00 Linking Access Objects 00:13:00 Using Hyperlink Fields 00:06:00 Database Management Optimizing Resources 00:16:00 Protecting Databases 00:05:00 Setting Options and Properties 00:06:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00