• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1310 Scratch courses in Sheffield delivered On Demand

Access 2016 Intermediate

By iStudy UK

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

Access 2016 Intermediate
Delivered Online On Demand2 hours 7 minutes
£25

Site Management Safety Training

4.7(47)

By Academy for Health and Fitness

***Year-End Deals Are Here!*** The Site Management Safety Training Scheme gives you the skills to reach new heights in your profession. Spare time by avoiding bad training - investigate this Site Management Safety Training Scheme course Scheme and benefit from carefully developed training, full of value and readily available. This Diploma in Site Management Safety Training Scheme at QLS Level 5 programme is endorsed by The Quality Licence Scheme and accredited by CPD to make your skill development & career progression more accessible than ever! Use the Site Management Safety Training Scheme online training course to prepare yourself with the precise knowledge and abilities you need to flourish in your career field. Learning Outcomes of This Site Management Safety Training Scheme Course : Understand the principles of health & safety on a site Know how to set up a construction site and its facilities from scratch Gain an acute awareness of CDM regulations Learn how to perform accurate risk assessments and management Attain the ability to perform behavioural leadership Become able to mitigate risks when working with electricity and scaffolding Be able to inspect excavations and confined spaces for safety concerns Discover the most dangerous aspects of demolition work and be prepared Our Site Management Safety Training Scheme (SMSTS) course is designed into multiple detailed modules for you to have a convenient and detailed learning experience. The certificate you'll earn after completing this Site Management Safety Training Scheme course is your proof of skill growth and competency. You can enhance your employability by participating in this course and including these new abilities on your CV. Attaining your dreams and preparing for your perfect career is possible with the complete this Site Management Safety Training Scheme course. Students get the opportunity to benefit from an in-depth learning experience and progress at their own pace with the assistance of the Site Management Safety Training Scheme course. The entire range of capabilities you will need to move into your chosen career is covered in the Site Management Safety Training Scheme course. If you want to enhance your field of study, enrolling in this site's Management Safety Training course is the best option for you. Using the Site Management Safety Training Scheme curriculum, set yourself apart from other job candidates and train for the position you want. Take a step toward a brighter future! Why Prefer This Site Management Safety Training SchemeCourse? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPD Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. *** Course Curriculum *** Here is the curriculum breakdown of this Site Management Safety Training SchemeCourse: Module 01: Health and Safety at Work Module 02: Site Set-Up Module 03: Construction Design and Management (CDM) Regulations Module 04: Risk Identification, Assessment and Management Module 05: Behavioural Safety Module 06: Management of Occupational Health Module 07: Electricity Module 08: Working at Height Module 09: Scaffolding Module 10: Excavations and Confined Space Module 11: Demolition Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Diploma in Site Management Safety Training SchemeScheme at QLS Level 5 exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Site Management Safety Training course. This course is open to everybody. Please Note: This course is not affiliated with or approved by CITB. As a result, CITB will not recognise the certificate provided following successful completion of the course. Requirements You will not need any prior background or expertise to enrol in this course. Career path This Site Management Safety Training Scheme course is aimed primarily at those who work in the building industry and manage activities on an active site. As such, it covers the following associated careers and roles: Site Manager Project Manager Site Foreman Site Supervisor Site Security The annual pay in this industry will range between £15,000 to £50,000

Site Management Safety Training
Delivered Online On Demand3 weeks
£12

Cake Making Training Course

4.9(27)

By Apex Learning

Introduction to Baking | Baking and Cake Decorating | Macarons Mastery | The Real and Only New York Cheesecake | Floral Buttercream Cakes | Bake a Layer Cake | Buttercream Cake Decorating | Artisan Pastry & Desserts | Sourdough Breads & Pastries Mastery | Food Safety Supervising in Catering Want to master the art of Cake Making and turn your passion into a profession? Well, look no further. With a single payment, you will gain access to our premium Cake Making Masterclass and take your cake decorating skills to a whole new level. With an understanding of the essence of cake decoration and ultimate baking, the course reveals the secrets and tricks master bakers follow to prepare delicious treats. You'll be familiar with various decorating tools, different baking styles, and ultimate cake decoration techniques to make the products even more beautiful. You'll also learn to spot the difference between a wide variety of cakes and desserts for various occasions and amaze your customers, meeting their expectations. Besides Cake Making, the course also focuses on the subject matter you need to run your own bakery business. You'll know how to start your bakery, create effective marketing strategies, and attract more customers to uplift your sales and revenue for your baking business. Finally, the course will teach you about the pastry business's ultimate food safety and personal hygiene protocols. This premium Cake Making Bundle consists of the following courses Course 01: Introduction to Baking Course 02: Cake Making Level 2 Course 03: Macarons Mastery Course Course 04: The Real and Only New York Cheesecake Course 05: Baking & Cake Decorating Online Diploma Course Course 06: Bake a Layer Cake Course 07: Artisan Pastry & Desserts - Essential Beginner Baking Course Course 08: Sourdough Breads & Pastries Mastery Course Course 09: Food Safety Supervising in Catering Diploma Course Course 10: Personal Hygiene Course 11: Complete Communication Skills Master Class for Life Gain the skills to emulate your favourite celebrity chef and make delicious cakes that delight and thrill everyone. Highlights of the Cake Making: learn how to bake cakes for different special occasions Learn how to get mix ingredients to achieve the perfect texture and colour Familiarise with various supplies and raw materials needed to bake a perfect cake Learn the basics of decorating a cake with fondant icing Get a solid understanding of hand decoration techniques Understand the process involved in transporting ordered cakes Explore presentation techniques and learn how to serve cakes professionally Understand the ins and outs of running a successful cake business Learn to make macarons from scratch, with no fancy ingredients & simple step-by-step guidance Bake French macarons with a crunchy exterior and weightless interior at home Gain a better understanding of the technical aspect of tricky macaron shells Explore experts' tips and tricks to mix, dry and bake the shells and much more Explore a wide range of design concepts, pattern designs and colour themes for creating window-display-worthy cakes Learn how to create striking flowers, stems and leaves, enhance your cake designs Understand personal hygiene and food safety policies in the UK Promote cake decorating business with effective marketing strategies Experienced tutors and mentors will be there for you whenever you need them and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Cake Making: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum of Cake Making Course 01: Introduction to Baking Welcome to the Course Reading a Recipe Mise en Place Choosing Ingredients Equipment Toolkit Special Notes for High Altitude What is a Butter Cake- History of Butter Cakes Important Considerations for Butter Cakes Creaming Method- Almond Butter Cake Reverse Creaming Method- Vanilla Butter Cake What is an Oil Based Cake- History of Oil Based Cakes Important Considerations for Oil Cakes Blended Method- Chocolate Olive Oil Cake Blended Method- Carrot Cake What is a Sponge Cake- History of Sponge Cakes Sponge Cake Mise en Place American Sponge Cakes American Sponge Method- Classic American Sponge European Sponge Cakes European Sponge Method- Genoise What is Simple Syrup Simple Syrup Method CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Whether you're an existing practitioner or aspiring professional, this Cake Making course will enhance your expertise and boost your CV with key skills. There is no experience or previous qualifications required for enrolment on this Cake Making course. It is available to all students, of all academic backgrounds. Requirements Our Cake Makingis fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Cake Making course has been designed to be fully compatible with tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this Cake Makingcourse, it can be studied in your own time at your own pace. Career path The Cake Making course is a useful CPD certificate to possess, especially to people with careers in: Baking Expert Cake Decoration Business Owner Cake Decorator Cake Stylists Confectionery Baker Pastry Chef Professional Cake Maker Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Introduction to Baking) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included

Cake Making Training Course
Delivered Online On Demand
£53

Dynamic Color Transitions: Mastering After Effects

By Compete High

🌈 Unleash Your Creativity with 'Dynamic Color Transitions: Mastering After Effects' 🌈 Are you ready to elevate your motion design game and captivate your audience with mesmerizing color transitions? Welcome to our transformative online course - your gateway to becoming a maestro of motion graphics with Adobe After Effects!   🚀 Course Overview: Module 1: Create Modern Gradient Animation Dive into the world of modern gradients! Learn to infuse life into your projects with captivating gradient animations that breathe vibrancy and dynamism into your compositions. Module 2: After Effects Introduction Master the fundamentals of After Effects with a comprehensive introduction. From the basics to advanced techniques, get ready to navigate the After Effects interface with confidence. Module 3: Color Schemes With Adobe Unlock the secrets of color schemes using Adobe's powerful tools. Discover how to create harmonious and visually stunning color palettes that enhance the impact of your designs. Module 4: Using Color Schemes Learn to implement color schemes effectively in your projects. Understand the psychology behind color choices and elevate your storytelling through the strategic use of color. Module 5: Using Shapes To Create Gradients Explore the versatility of shapes in After Effects! Discover how to leverage shapes to craft seamless and captivating gradient transitions that add depth and dimension to your animations. Module 6: Create A Gradient Composition Put your skills to the test as you create a stunning gradient composition from scratch. Learn the art of composition, balance, and harmony to produce visuals that leave a lasting impression. Module 7: Animate Gradient Design Take your animations to the next level! Unleash your creativity as you learn advanced techniques to animate gradient designs, bringing your visuals to life with smooth transitions and eye-catching effects.   🎓 What's Included: Access to 7 comprehensive modules with video tutorials. Downloadable project files for hands-on practice. Quizzes and assignments to reinforce your learning. Exclusive community access for networking and collaboration. Lifetime access, so you can revisit the course at your own pace.   🌟 Why Choose 'Dynamic Color Transitions: Mastering After Effects'? Taught by industry experts with years of experience in motion design. Practical, hands-on learning that ensures real-world application. Elevate your portfolio with stunning, professionally crafted animations. Join a community of like-minded creatives for ongoing support and inspiration.   Don't miss your chance to become a master of color transitions in After Effects! Enroll now and embark on a journey of creativity, skill-building, and artistic expression. 🎨 Transform Your Designs, Transform Your Career! Enroll Today! 🎨 Course Curriculum Module 1: Create Modern Gradient Animation Create Modern Gradient Animation 00:00 Module 2: After Effects Introduction After Effects Introduction 00:00 Module 3: Color Schemes With Adobe Color Schemes With Adobe 00:00 Module 4: Using Color Schemes Using Color Schemes 00:00 Module 5: Using Shapes To Create Gradients Using Shapes To Create Gradients 00:00 Module 6: Create A Gradient Composition Create A Gradient Composition 00:00 Module 7: Animate Gradient Design Animate Gradient Design 00:00

Dynamic Color Transitions: Mastering After Effects
Delivered Online On Demand7 hours
£4.99

Montessori Education for Early Childhood

5.0(2)

By Institute of Beauty & Makeup

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Montessori Education for Early Childhood
Delivered Online On Demand1 hour
£12

Financial Analysis & Financial Reporting

5.0(2)

By Institute of Beauty & Makeup

Discounted Course | Premium Audio-Visual Training by Expert Professionals | CPD Accredited Course | 24x7 Tutor Support

Financial Analysis & Financial Reporting
Delivered Online On Demand1 hour
£12

Learn Italian Language: Italian Course For Intermediate

By iStudy UK

The Learn Italian Language: Italian Course For Intermediate reflects your personal needs, whether you are an absolute beginner learning Italian from scratch or you are a fluent speaker and simply want to refresh your knowledge of Italian. The course will develop your comprehension of the language, extend your vocabulary and enhance your understanding of grammatical structures. Learn the basics of the Italian language and culture through videos, podcasts, interviews, and much more. Through the course, you will learn the four basic skills (speaking, listening, reading and writing) in the context of major themes in Italian culture. By the end of the course, you will be able to describe people, events and situations, both in the present and the past, and you will have acquired the necessary vocabulary to communicate about everyday situations. What you'll learn The #1 Italian Course for Intermediate. At the end of this course, you will have a deep knowledge of Italian - Intermediate Level. Speaking real, grammatically correct Italian fluently, effortlessly and confidently. Hold a complex conversation in Italian. Learn the intermediate Italian grammar and vocabulary. Understand and use familiar everyday expressions. Reach your Italian language goals now and in the future, increasing your opportunities for both personal and professional success. The interactive board and the included .pdf materials help the visual learners and the immersion method used for teaching accelerates the learning speed, the comprehension of the spoken Italian and the fluency. Improve your listening and comprehension skills with Italian through ear training. Be confident regarding your Italian skills (B1 level, intermediate Italian) by lots of practice after every lesson. Requirements Beginner Level of Italian is required. Videos are in Italian. Native Level Teacher. Free Demo Lessons and included .pdf materials. Introduction Italian Course For Intermediate - I pronomi diretti oggetto 00:16:00 Italian Course For Intermediate - Utensili 00:06:00 Italian Course For Intermediate - I pronomi indiretti 00:16:00 Italian Course For Intermediate - Esercizi. I mestieri 00:07:00 Italian Course For Intermediate - Il pronome partitivo ne 00:09:00 Italian Course For Intermediate - Dettato 00:08:00 Italian Course For Intermediate - I pronomi diretti e indiretti con verbi modali 00:09:00 Italian Course For Intermediate - La formazione di verbi a partire da aggettivi 00:07:00 Italian For Intermediate - I pronomi diretti e indiretti con il passato prossimo 00:16:00 Italian Course For Intermediate - Altri usi della particella ne 00:05:00 Italian Course For Intermediate - Gli usi di ci 00:08:00 Italian Course For Intermediate - Ce n'è/ce ne sono 00:06:00 Italian Course For Intermediate - Il futuro composto 00:09:00 talian Course For Intermediate - Dettato 2 00:08:00 Italian Course For Intermediate - Gradi di comparazione dell'aggett 00:11:00 Italian Course For Intermediate - L'imperfetto 00:09:00 Italian Course For Intermediate - Ripasso imperfetto e passato prossimo 00:07:00 Italian Course For Intermediate - Il trapassato prossimo 00:06:00 Italian Course For Intermediate - La struttura stare + gerundio 00:06:00 Italian Course For Intermediate - Dettato 3 00:08:00 Italian Course For Intermediate - Gli aggettivi bello e quello 00:07:00 Italian Course For Intermediate - Il pronome relativo cui 00:12:00 Italian Course For Intermediate - Alcuni verbi pronominali 00:06:00 Italian Course For Intermediate - Dialogo. Gli avverbi di modo 00:06:00 Italian Course For Intermediate - Il condizionale semplice 1 00:12:00 Italian Course For Intermediate - Il condizionale semplice 2 00:12:00 Italian Course For Intermediate - Il condizionale composto 1 00:08:00 Italian Course For Intermediate - Il condizionale composto 2 00:11:00 Italian Course For Intermediate - Computer e internet. Vocabolario 00:05:00 Italian Course For Intermediate - Dettato 4 00:09:00 Italian Course For Intermediate - L'imperativo 1 00:14:00 Italian Course For Intermediate - L'imperativo 2 00:12:00 Italian Course For Intermediate - Dialogo 00:04:00 Italian Course For Intermediate - Dettato 5 00:09:00 Italian Course For Intermediate - Ripasso 00:30:00 Course Certification

Learn Italian Language: Italian Course For Intermediate
Delivered Online On Demand5 hours 34 minutes
£25

Carpentry and Joinery

By Compliance Central

Unlock abundant opportunities in the UK's Carpentry and Joinery sector. Experience a thriving field with competitive salaries averaging £30,000+. Expect 10% industry growth by 2025, ensuring a stable and prosperous career path. Embrace the craftsmanship and reap the rewards in this lucrative job market. What are we offering? This course begins with the fundamentals of carpentry and joinery and continues to more advanced subjects. This pattern of lesson plans in this Carpentry and Joinery course makes each lesson simple to learn and logical. This training programme will help you develop your carpentry abilities and turn you into a competent, responsible carpenter. Upon successful completion of this Carpentry course, you: Can provide services related to Carpentry with complete knowledge and confidence Be able to classify the various building materials used in Carpentry Learn how to build an interior and exterior wall Be able to classify the various building materials they use Can train up others and grow an efficient peer community in your locality and serve people Will be competent and proficient enough to start a Carpentry related business on your own Enrol in this Carpentry and Joinery course today to learn everything there is to know about this Carpentry and Joinery industry. The goal of this brief, online carpentry course is to teach formwork and joinery in a straightforward manner. Check out the course right away; by the conclusion of it, your career will have improved. The curriculum breakdown for this course will be as follows: Module 01: Introduction to Carpentry - In this module, you will study the brief introduction to carpentry and joinery. You will learn about the basic term used in the carpentry and joinery field. Module 02: Tool Checklist and Use - Here, you will explore the tools and their functionalities used in carpentry. Module 03: Building Materials - This module discusses the restoration materials used in carpentry. Module 04: Adhesives and Fasteners - This module will teach you about the techniques and functionalities of adhesives and fasteners of carpentry equipment. Module 05: Floor Systems - This module will explain the sequence involved in constructing a platform floor assembly Module 06: Wall Framing - In this module, you will study the different types of wall and framing procedures as well as learn their different components. You will also learn how to build and renovate interior walls and measure the details of building walls. Module 07: Roof Framing and Siding - This module will teach you the various terms associated with floor systems, wall, ceiling and roof framing Module 08: Windows and Exterior Doors - This module will educate you about the various types of windows and exterior doors used in residential construction and the kinds of glass used in window glazing. Module 09: Stair Construction - This module will cover stair construction and various stair designs, such as straight-run, platform, and spiral staircases. Next, you'll learn about the three different types of staircases, as well as the elements of a flight of stairs and interior stairways. Additionally, the course will cover the specifications, layout, and design of stairways, stairwells, and stair framing. Module 10: Concrete Construction - This module discusses the terms associated with concrete, concrete reinforcing materials and how to build a complete concrete structure from scratch. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anybody with a passion for carpentry can benefit from this useful training. No prerequisites are needed to take it. You can enrol on the course if you are a, Student, Enthusiast Employee/Employer Entrepreneur Business Professional Requirements To enrol in this Carpentry and Joinery course, all you need is a basic understanding of the English Language and an internet connection. Career path The course will add a valuable skill to your resume and enable you to get hired in Carpentry and Joinery related Trendy and Demanding jobs, such as, Carpenter (Salary: £20,000 to £38,000 per annum) Bench Joiner (Salary: £25,000 - £35,000 per annum) Furniture designer (Salary: £20,000 to £38,000 per annum) Furniture restorer (Salary: £19,000 to £28,000 per annum) Certificates Certificate of completion Digital certificate - Included Free CPD Accredited PDF Certificate.

Carpentry and Joinery
Delivered Online On Demand3 hours
£12

Architectural Studies : Interior & Exterior Design

5.0(2)

By Institute of Beauty & Makeup

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Architectural Studies : Interior & Exterior Design
Delivered Online On Demand1 hour
£12

Web Development: Software and Web Development Training - CPD Certified Diploma

4.8(9)

By Skill Up

CPD Certified | 19-in-1 Diploma Bundle | Free PDF & Transcript Certificate | New & Updated | 24/7 Learner Support

Web Development: Software and Web Development Training - CPD Certified Diploma
Delivered Online On Demand5 days
£101