There is a common misconception that sharps injuries are only of concern to medical and care staff. However it is not uncommon for people in other industries such as waste disposal to come into contact with used sharps. In this course we'll start by looking at some statistics relating to discarded needles, then define 'sharps' and look at the different types that can be found in 'sharps litter', ranging from needles, syringes and scalpel blades to broken glass, knives, scissors and nails. It then covers the primary and secondary risks from sharps. It'll look at the responsibilities of employers and how they must use risk assessment to ensure workers safety, as much as possible. Then, the course will take a detailed look at Hepatitis B, Hepatitis C, HIV and Tetanus There'll be a section on the Chain of Infection, helping you to understand how an infection gets passed on, and what steps can be taken to break the chain and stop the process. It'll look at the probability of picking up an infection from a needlestick injury, and the factors that can affect this. It's important to always handle discarded sharps safely so the course will take you through the equipment you need, including litter pickers, forceps, disinfectant sprays and gloves, along with the correct techniques you should employ to avoid injury. This subject will be further expanded on by detailing the correct sharps handling procedures, including how to dispose of discarded sharps safely, how to remove disposable gloves to minimise cross-contamination, and correct hand washing procedures. Finally, it'll cover how to report discarded sharps and the correct procedures to follow if you're unlucky enough to receive a sharps injury.
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Accounting Essential for Business with Sage 50 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Accounting Essential for Business with Sage 50 Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Accounting Essential for Business with Sage 50 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Accounting Essential for Business with Sage 50 Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Accounting Essential for Business with Sage 50 ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Accounting Essential for Business with Sage 50 there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Accounting Essential for Business with Sage 50 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Accounting Essential for Business with Sage 50 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Accounting Essential for Business with Sage 50 was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Accounting Essential for Business with Sage 50 is a great way for you to gain multiple skills from the comfort of your home. Accounting Essential for Business with Sage 50 Chris Moore - 1. Introduction 00:03:00 Chris Moore - 2. First Transactions 00:05:00 Chris Moore - 3. T Accounts introduction 00:03:00 TASK 4 Fixed Assets 00:08:00 TASK 5 a and b Bank Payment and Transfer 00:31:00 TASK 5 c and d Supplier and Customer Payments and DD STO 00:18:00 TASK 6 Petty Cash 00:11:00 TASK 7 a Bank Reconnciliation Current Account 00:17:00 TASK 7 b Bank Reconciliation Petty Cash 00:09:00 TASK 7 c Reconciliation of Credit Card Account 00:16:00 TASK 8 Aged Reports 00:14:00 TASK 9 a Payroll 00:07:00 9 b Payroll Journal 00:10:00 TASK 10 Value Added Tax - Vat Return 00:12:00 Task 11 Entering opening balances on Sage 50 00:13:00 TASK 12 a Year end journals - Depre journal 00:05:00 TASK 12 b Prepayment and Deferred Income Journals 00:08:00 TASK 13 a Budget 00:05:00 TASK 13 b Intro to Cash flow and Sage Report Design 00:08:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced Diploma in Trauma Treatment of Complex PTSD Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced Diploma in Trauma Treatment of Complex PTSD Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Diploma in Trauma Treatment of Complex PTSD Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced Diploma in Trauma Treatment of Complex PTSD Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Diploma in Trauma Treatment of Complex PTSD? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD-accredited qualifications after course completion Receive one-to-one assistance 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 Advanced Diploma in Trauma Treatment of Complex PTSD there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced Diploma in Trauma Treatment of Complex PTSD course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced Diploma in Trauma Treatment of Complex PTSD does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Advanced Diploma in Trauma Treatment of Complex PTSD was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Advanced Diploma in Trauma Treatment of Complex PTSD is a great way for you to gain multiple skills from the comfort of your home. Advanced Diploma in Trauma Treatment of Complex PTSD Module 1: Introduction to Advanced Training for Trauma Treatment of Complex PTSD 00:55:00 Module 2: Foundation and Knowledge 01:00:00 Module 3: Symptoms of C-PTSD 01:00:00 Module 4: Neurobiology of C-PTSD 01:00:00 Module 5: Stress Response and Stages of Traumatic Response 01:01:00 Module 6: Deliberate Practice 01:00:00 Module 7: Self-Regulation and Co-Regulation 01:00:00 Module 8: Introduction to Active Ingredients 01:00:00 Module 9: Empowerment and Resilience Treatment Structure - Stage I: Preparation 01:00:00 Module 10: Empowerment and Resilience Treatment Structure - Stage II: Psychoeduc 01:00:00 Module 11: Graphic Timeline 01:00:00 Module 12: Skills Development - Relaxation 01:01:00 Module 13: Skills Development - Grounding 01:00:00 Module 14. Skills Development Conclusion and Regression 01:08:00 Module 15: Forward Facing Trauma Therapy (FFTT) 01:00:00 Module 16: Therapist Driven Treatments 01:04:00 Assignment Assignment - Advanced Diploma in Trauma Treatment of Complex PTSD 10:09:00 Order Your Certificate Order Your Certificate QLS
This course is designed to enable candidates to develop the knowledge of the terminology and basic concepts of TOGAF Standard, 10th Edition and principles of Enterprise Architecture. Candidates will also be able to analyze and apply knowledge of TOGAF Standard.
Register on the Advanced Arduino for Embedded Systems today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Advanced Arduino for Embedded Systems is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Advanced Arduino for Embedded Systems Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Advanced Arduino for Embedded Systems, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Unit 01: Introduction Module 01: Introduction 00:02:00 Unit 02: Introduction to Embedded System Module 01: Embedded System Lecture-1 00:09:00 Module 02: Embedded System Lecture-2 00:07:00 Module 03: Embedded System Lecture-3 00:07:00 Module 04: Embedded System Lecture-4 00:07:00 Module 05: Embedded System Lecture-5 Part 01 00:05:00 Module 06: Embedded System Lecture-5 Part 02 00:01:00 Unit 03: Introduction to Arduino Board Module 01: Introduction to Arduino Lecture 1 00:06:00 Module 02: Arduino LED Program Lecture 2 00:10:00 Module 03: Arduino Simulation Lecture 3 00:06:00 Unit 04: Difference between C Syntax of Arduino and C Coding Module 01: Arduino Vs C Differences 00:10:00 Module 02: C vs Arduino Differences 00:10:00 Unit 05: Breadboard Module 01: Breadboard 00:08:00 Unit 06: LED Interfacing Module 01: LED Chapter 1 00:08:00 Module 02: LED Chapter 2 00:06:00 Module 03: LED Chapter 3 00:01:00 Module 04: LED Chapter 4 00:05:00 Unit 07: Buzzer Module 01: Buzzer Chapter 1 00:04:00 Module 02: Buzzer Chapter 2 00:05:00 Unit 08: Switch Interfacing Module 01: Switch Interfacing Chapter-1 00:07:00 Module 02: Switch Interfacing Chapter-2 00:04:00 Module 03: Switch Interfacing Chapter-3 00:04:00 Module 04: Switch Interfacing Chapter-4 00:04:00 Unit 09: Serial Port Module 01: Serial Chapter 1 00:07:00 Module 02: Serial Chapter 2 00:04:00 Module 03: Serial Chapter 3 00:08:00 Module 04: Serial Chapter 4 00:07:00 Module 05: Serial Chapter 5 00:03:00 Module 06: Serial Chapter 6 00:08:00 Unit 10: LCD Interfacing Module 01: LCD Chapter 1 00:11:00 Module 02: LCD Chapter 2 00:08:00 Unit 11: Keypad Module 01: Concepts around keypad 00:10:00 Unit 12: Analog Input Module 01: Analog to Digital Converter Chapter 1 00:09:00 Module 02: Analog to Digital Converter Chapter 2 00:03:00 Module 03: Analog to Digital Converter Chapter 3 00:08:00 Module 04: Analog to Digital Converter Chapter 4 00:03:00 Module 05: Analog to Digital Converter Chapter 5 00:04:00 Unit 13: LDR Module 01: LDR Chapter 1 00:05:00 Module 02: LDR Chapter 2 00:02:00 Unit 14: Ultrasonic Distance Sensing Module 01: Ultrasonic Chapter 1 00:07:00 Module 02: Ultrasonic Chapter 2 00:08:00 Unit 15: DHT Sensor Module 01: DHDT Chapter 1 00:10:00 Unit 16: Relay Interfacing Module 01: Relay Interfacing Chapter 1 00:07:00 Module 02: Relay Interfacing Chapter 2 00:06:00 Module 03: Relay Interfacing Chapter 3 00:09:00 Unit 17: EEPROM Module 01: EEPROM 00:08:00 Unit 18: DC Motor Interfacing Module 01: DC Motor Interfacing Chapter 1 00:10:00 Module 02: DC Motor Interfacing Chapter 2 00:07:00 Unit 19: Servo Motor Interfacing Module 01: Servo Chapter 1 00:10:00 Module 02: Servo Chapter 2 00:09:00 Unit 20: PWM Module 01: PWM Chapter 1 00:06:00 Module 02: PWM Chapter 2 00:07:00 Module 03: PWM Chapter 3 00:04:00 Unit 21: I2C Module 01: I2C Chapter 1 00:10:00 Module 02: I2C Chapter 2 00:01:00 Module 03: I2C Chapter 3 00:04:00 Module 04: I2C Chapter 4 00:05:00 Unit 22: RTC Module 01: RTC Chapter 1 00:07:00 Module 02: RTC Chapter 2 00:10:00 Module 03: RTC Chapter 3 00:05:00 Module 04: RTC Chapter 4 00:10:00 Unit 23: SD Card Module 01: SD Chapter 1 00:06:00 Module 02: SD Chapter 2 00:07:00 Unit 24: Resources Module 01: File Download 00:00:00 Unit 25: Conclusion Module 01: Conclusion 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Redefine the limits of your skiing. Our Courchevel Performance & Adventure Courses bring together the industries leading coaches to provide expert support for aspiring Freeriders. Helping you transform from confident parallel skier to backcountry boss. Surrounded by a team of like-minded skiers, you will leave your mark on the mountain and make winter memories to last a lifetime. All of this while earning internationally recognised qualifications that will help you whatever you decide to do next. The experience gained on our Courchevel Performance & Adventure Course will help you progress outside of skiing.
The CILT(UK) Level 5 Professional Diploma in Logistics and Transport (QCF) is designed to enhance new and existing expertise in the supply chain, passenger transport, road freight or transport planning environments as well as developing core management skills.
Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included
Course Overview The early age of education is crucial for child development. Primary teachers help children to learn and develop in their early ages. If you love children and play a role in their development, then this Primary Teacher Training course will give you the proper guidelines. In this Primary Teacher Training course, you will learn about the roles and responsibilities of primary school teachers and how they can help children and how to help children to develop and learn. This course will teach you different teaching techniques, types of schools in the UK, special skills and the latest educational inventions. This is an ideal course for those who want to learn about teaching techniques and establish their career as a teacher. This Primary Teacher Training course will help you to understand new teaching techniques and developments through easily understandable bite-sized lessons. You will be able to familiarise yourself with different situations and learn new information easily. Learning Outcomes Learn about the roles and responsibilities of a primary teacher Be able to understand the students need Provide your pupils with a friendly and enjoyable learninf environment Inspire your students and improve the learninf system Familiarise with various teaching methods Learn about self-management and stress management techniques Be able to understand the needs of special education needs children Familiarise with EYFS teaching techniques Understand the importance of early years in development Who is this course for? This comprehensive Primary Teacher Training course is ideal for those who want to learn the roles and responsibilities of a primary teacher. You will learn how to communicate with children and teach them efficiently from this course. 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 recognized 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 Primary Teacher Training is a useful qualification to possess and would be beneficial for any related profession or industry such as: Primary Teachers Nursery Nurses SEN teachers Teaching Assistants Child support workers Childcarers Nannies Primary Teacher Training ( Updated Materials ) Primary Education in the UK 00:19:00 Responsibilities, Qualifications and Skills 00:18:00 Initial Teacher Training 00:25:00 Types of Schools in the UK 00:17:00 Importance of Early Years in Development 00:21:00 EYFS Teaching Techniques 00:16:00 Child Development 00:15:00 Teaching Primary English 00:31:00 Teaching Primary Mathematics 00:39:00 Teaching Primary Science, Design and Technology 00:32:00 Teaching Other Primary Subjects 00:30:00 Children Having Special Education Needs or Disabilities 00:18:00 EYFS Framework in 2021 00:14:00 Self-Management and Dealing with Stress 00:17:00 Primary Teacher Training ( Previous Materials ) ***Primary Education*** Structure of Primary Education in England 00:20:00 The Importance of Education in Early Childhood 00:05:00 Why is Education Important? 00:15:00 Key Benefits of Early Childhood Education 00:15:00 The Importance of Parent Involvement in Early Childhood Education 00:05:00 How education affects early childhood development? 00:15:00 Qualities of a Good Early Childhood Teacher 00:05:00 The Role of the Early Years Teacher 00:15:00 Working with Young Children 00:45:00 Teaching Kids Life Skills at an Early Age 00:15:00 Teach Preschool Kids to Count 00:15:00 Setting Up a Reward System for Children 00:15:00 Teach New Skills by Acting out Scenes 00:05:00 Teach Kids about their Feelings 00:05:00 Teaching Self-Care Skills to Children with Special Needs 00:15:00 Teach Your Kids Time Management Skills 00:30:00 Requirements, Qualifications and Useful Skills 00:05:00 The Early Years Framework 00:30:00 Understanding the EYFS Framework 00:05:00 A Fair and Flexible Framework 00:05:00 Regulation of Learning and Development 00:15:00 The Learning and Development Requirements 00:30:00 The Early Learning Goals 00:15:00 The Characteristics of Effective Learning 00:30:00 The EYFS Curriculum Design 00:05:00 Learning and Teaching Through Play 00:30:00 Playful Learning and Playful Teaching 00:15:00 Teaching Methods 00:15:00 Strategies for 21st Century Early Childhood Teachers 00:15:00 Creating an Enabling Environment 00:30:00 Innovative Ideas to Make Your Teaching Methods More Effective 00:15:00 ***Key Stage 1 & 2 Teaching*** **ENGLISH** Word Level Module 1: Early Phonics & Alphabet 00:30:00 Module 2: CVC 00:15:00 Module 3: Blends 01:00:00 Module 4: Vowel Phonemes 00:30:00 Module 5: Other Phonics 00:15:00 B. Spelling & Phonics (Part 2) Module 1: Prefixes 00:05:00 Module 2: Double Consonants 00:15:00 C. Spelling & Phonics (Part 3) Module 1: Plurals 00:30:00 Module 2: Compound Words 00:15:00 Module 3: Common Words 01:00:00 Module 4: Spelling and Rhyme 00:15:00 Module 5: Spelling Strategies 00:15:00 D. Alphabetical Order Alphabetical Order 00:30:00 E. Dictionary Skills Dictionary Skills 00:30:00 F. Synonyms & Thesaurus Work Module 1: Synonyms 00:30:00 Module 2: Thesaurus 00:15:00 G. Language Extension (Proverbs and Idioms) Module 1: Proverbs 00:15:00 Module 2: Idioms 00:15:00 Module 3: Metaphorical Expressions 00:15:00 Sentence Level A. Nouns & Adjectives Module 1: Nouns & Adjectives 01:00:00 B. Verbs & Adverbs Module 1: Verbs 00:15:00 Module 2: Adverbs 00:30:00 C. Writing Basic Sentences C. Writing Basic Sentences 00:30:00 D. Collective Nouns D. Collective Nouns 00:15:00 **MATHS** A. General Module 1: Miscellaneous 00:30:00 Module 2. Planning & Assessment 00:30:00 B. Numbers and the Number System Module 1: Counting 01:00:00 Module 2: Patterns & Number Sequences 00:15:00 Module 3: Ordering and Comparing Numbers 00:05:00 Module 4: Fractions, Decimals, and Percentages 01:00:00 Module 5: Properties of Numbers 01:00:00 Module 6: Place Value 00:30:00 Module 7: Rounding, Approximating & Estimating 00:15:00 Module 8: Ratio and Proportion 00:15:00 C. Calculations Module 1: Addition & Subtraction 01:00:00 Module 2: Doubling and Halving 00:05:00 Module 3: Using a Calculator 00:10:00 D. Solving Problems Module1: Word & Real Life Problems 00:10:00 Module 2: Money Problems 01:00:00 E. Measures, Shape & Space Module 1: Length or Distance 00:15:00 Module 2. Capacity or Volume 00:15:00 Module 3: 2D Shapes 00:05:00 Module 4: Position and Direction 00:15:00 Module 5: Time 00:30:00 **SCIENCE** A. Scientific Enquiry Module 1: Investigative Skills 00:15:00 B. Life Processes and Living Things Module 1: Life Processes - Worksheets 00:15:00 Module 2: Humans and other Animals 00:30:00 Module 3: Green Plants 00:30:00 Module 4: Variation and Classification 00:15:00 Module 5: Living Things in Their Environment 00:15:00 C. Materials and their Properties Module 1: Grouping and Classifying Materials 00:30:00 Module 2: Changing Materials 00:30:00 Module 3: Rocks and Soils 00:15:00 Module 4: Separating Mixtures of Materials 00:15:00 D. Physical Processes Module 1: Electricity 00:30:00 Module 2: Forces and Motion 00:15:00 Module 3: Light and Sound 00:30:00 Module 4: The Earth and beyond 00:15:00 **ICT** Module 1: General 00:15:00 Module 2: Word Processing, DTP and Graphics 00:15:00 Module 3: CD-ROMS, Internet & Email 00:15:00 **ART & DESIGN** ART & DESIGN 00:15:00 GEOGRAPHY Module 1: Maps and Plans 00:15:00 Module 2: Local Studies & Contrasting UK Locality 00:15:00 Module 3: Transport, Weather & Tourism 00:30:00 Module 4: Mountains and Rivers 00:30:00 Module 5: Around the World 00:15:00 **HISTORY** Module 1: Famous People 00:15:00 Module 2: The Tudors 00:15:00 Refer a Friend Refer a Friend and Claim One Course for FREE 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Duration 1 Days 6 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. Your training and experience using Microsoft© Access© has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Promoting Quality Data Input Topic A: Restrict Data Input Through Field Validation Topic B: Restrict Data Input Through Forms and Record Validation Lesson 2: Improving Efficiency and Data Integrity Topic A: Data Normalization Topic B: Associate Unrelated Tables Topic C: Enforce Referential Integrity Lesson 3: Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Lesson 4: Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Lesson 5: Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Lesson 6: Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report