353 Mask courses delivered Online

🌟 Unleash Your Creativity: Design & Enhance With Photoshop Online Course 🌟 Are you ready to transform your creative vision into stunning visual masterpieces? Dive into the world of endless possibilities with our exclusive online course: 'Design & Enhance With Photoshop.'   🎨 Unlock Your Creative Potential: Whether you're a seasoned designer or a beginner eager to explore the realm of digital artistry, this course is crafted just for you. From the basics to advanced techniques, we'll guide you through every facet of Adobe Photoshop, empowering you to create captivating designs that leave a lasting impression.   🚀 What You'll Learn: Master Photoshop Tools: From layers and masks to brushes and filters, become proficient in utilizing Photoshop's extensive toolkit. Design Principles: Learn the fundamental principles of design, color theory, and composition to create visually appealing graphics. Photo Editing Magic: Discover the secrets of professional photo editing, retouching, and enhancement for jaw-dropping results. Typography Mastery: Elevate your designs with impactful text, mastering the art of font selection, spacing, and alignment. Create Engaging Visual Content: Craft social media graphics, banners, posters, and more that stand out in the digital landscape.   🌐 Why Choose Our Course: Flexible Learning: Access the course anytime, anywhere, and at your own pace. Fit learning seamlessly into your busy schedule. Expert Guidance: Benefit from the expertise of seasoned design professionals who share real-world insights and tips. Hands-On Projects: Apply your skills through practical, hands-on projects that reinforce your learning and build your portfolio.   🎓 Who is This Course For? Graphic Designers Photographers Content Creators Social Media Managers Marketing Professionals Anyone Passionate About Visual Arts   🌈 Elevate Your Design Game Today! Don't miss out on the opportunity to enhance your creative journey. Join 'Design & Enhance With Photoshop' now and turn your imagination into captivating visual stories!   🔥 Enroll Now and Design Your Success! 🔥 Course Curriculum Basic Overview 00:00 Pricing and Licensing Options 00:00 Basic File Types and Options 00:00 Working with the Interface 00:00 Working with A Basic Canvas 00:00 Working with Layers 00:00 Working with the Move Tool 00:00 Working with Shapes 00:00 Working with the Marquee Tool 00:00 Working with Colors 00:00 Working with the Paintbucket 00:00 Working with the Eraser Tool 00:00 Working with the Text Tool 00:00 Working with Images 00:00 Working with Sizing 00:00 Working With Transparent Layers 00:00 Using the Crop Tool 00:00 Working with Layer Styles 00:00 Working with Rotation of Images and Layers 00:00 Conclusion 00:00 Advanced Overview 00:00 Having Graphic Designs Created 00:00 Making PSD Thumbnails Visible on Your PC 00:00 Creating A Simple Design - Part 1 00:00 Creating A Simple Design - Part 2 00:00 Changing the Backgrond Image 00:00 Changing the Font or Text 00:00 Working with Photoshop Actions 00:00 Sources for Photoshop Actions 00:00 Selecting Photoshop Actions 00:00 Producing Photoshop Actions - Part 1 00:00 Show Transform Controls 00:00 Producing Photshop Actions - Part 2 00:00 Creating a Multiple 3D Image Shot 00:00 Sizing of File Formats 00:00 Saving For Certain File Formats 00:00 Live Application - Part 1 00:00 Live Application - Part 2 00:00 Multiple Shot Live Application 00:00 Conclusion 00:00

🇮🇹 Unlock the Secrets of Authentic Italian Cooking with Our Italian Cooking Course! 🍝 Are you ready to embark on a culinary journey to the heart of Italy without leaving your kitchen? Look no further than our comprehensive Italian Cooking course, designed to ignite your passion for Italian cuisine and elevate your cooking skills to new heights!   Why Italian Cooking? 🍕 Italian cuisine is renowned worldwide for its rich flavors, vibrant colors, and emphasis on fresh, high-quality ingredients. From classic pasta dishes like spaghetti carbonara and lasagna to mouthwatering pizzas and decadent desserts like tiramisu, Italian cooking offers a symphony of tastes that will tantalize your taste buds and leave you craving for more. Our Italian Cooking course goes beyond just recipes; it delves into the essence of Italian culinary culture, teaching you the principles of flavor pairing, traditional cooking techniques, and the importance of simplicity in creating unforgettable dishes.   Benefits of Taking Our Course 🍅 👩‍🍳 Master Authentic Recipes: Learn to recreate beloved Italian classics with confidence, from homemade pasta to delectable sauces. 🌿 Embrace Fresh Ingredients: Discover the significance of using fresh, seasonal produce and quality ingredients to enhance the flavors of your dishes. 🔥 Hone Your Culinary Skills: Perfect your knife skills, master the art of sautéing, and explore various cooking methods to become a versatile home chef. 👩‍👧‍👦 Create Memorable Dining Experiences: Impress family and friends with your newfound cooking prowess as you host unforgettable Italian-themed gatherings. 🌍 Connect with Italian Culture: Immerse yourself in the rich culinary traditions of Italy and gain a deeper appreciation for its regional diversity and food heritage.   Who is this for? 🍷 Our Italian Cooking course is perfect for aspiring home cooks, culinary enthusiasts, and anyone eager to expand their culinary repertoire with authentic Italian flavors. Whether you're a novice in the kitchen or a seasoned cook looking to refine your skills, this course offers something for everyone.   Career Path 🍽️ Embarking on a journey into Italian cooking can open doors to a variety of exciting career opportunities in the culinary world. Graduates of our course may pursue: 👨‍🍳 Chef Positions: Hone your skills and expertise to work in professional kitchens specializing in Italian cuisine, from trattorias to fine dining establishments. 📚 Cooking Instructor: Share your passion for Italian cooking by teaching classes, hosting workshops, or creating online tutorials for aspiring cooks. 🍝 Catering and Personal Chef Services: Launch your own catering business or offer personalized chef services, bringing the flavors of Italy directly to clients' homes. 📸 Food Stylist and Blogger: Showcase your culinary creations on social media platforms, develop your own food blog, or work as a food stylist for magazines, cookbooks, and advertisements. Don't miss out on the opportunity to explore the artistry and flavors of Italian cooking with our immersive course. Enroll today and let your culinary journey begin! 🇮🇹🍴   FAQ (Frequently Asked Questions) - Italian Cooking Q1. What are some essential ingredients used in Italian cooking? Italian cuisine is known for its simplicity and emphasis on fresh, quality ingredients. Some essential ingredients you'll often find in Italian cooking include olive oil, tomatoes, garlic, basil, oregano, Parmesan cheese, and pasta. Additionally, staples like onions, peppers, and various herbs and spices are commonly used to add depth of flavor to dishes. Don't forget about staples like risotto rice, polenta, and different types of beans, which are also integral to many Italian recipes. Q2. What are some traditional Italian dishes that beginners can try making? For beginners in Italian cooking, starting with simpler dishes is a great way to get acquainted with the flavors and techniques. Classics like spaghetti carbonara, pasta primavera, Margherita pizza, bruschetta, and Caprese salad are relatively easy to make and showcase the essence of Italian cuisine. Risotto and gnocchi are also popular choices that offer room for creativity while still being approachable for those new to the kitchen. Q3. What cooking techniques are commonly used in Italian cuisine? Italian cooking relies heavily on techniques that enhance the natural flavors of ingredients rather than masking them. Some common techniques include sautéing, simmering, braising, and grilling. Italians also excel at techniques like making pasta from scratch, preparing risotto with patience and precision, and mastering the art of making sauces like marinara and Bolognese from scratch. It's also worth noting the importance of properly seasoning dishes throughout the cooking process to achieve balanced flavors. Q4. How important is authenticity in Italian cooking? Authenticity is highly valued in Italian cooking, as it reflects a respect for tradition and regional culinary heritage. While it's okay to put your own spin on classic recipes, maintaining the integrity of traditional flavors and techniques is key. Italians take pride in using locally sourced, seasonal ingredients and following time-honored methods passed down through generations. Embracing authenticity can deepen your appreciation for Italian cuisine and elevate your cooking skills. Q5. Are there any regional differences in Italian cuisine? Yes, Italian cuisine is incredibly diverse and varies significantly from region to region. Each area of Italy has its own unique culinary traditions, ingredients, and specialties. For example, Northern Italian cuisine is known for rich, creamy sauces, risottos, and hearty dishes featuring meats and dairy. In contrast, Southern Italian cuisine often incorporates fresh seafood, citrus, and olive oil, with simpler, lighter flavors. Exploring these regional differences can offer a fascinating journey through Italy's culinary landscape. Course Curriculum Module 01- Introduction Introduction 00:00 module 02 Italian Soups Italian Soups 00:00 Module 03 History of Pizza History of Pizza 00:00 Module 04 All About Pasta All About Pasta 00:00 Module 05 Pizza and Pasta Pizza and Pasta 00:00 Module 06 Pasta Recipes Pasta Recipes 00:00 Module 07 Famous Italian Food Drinks Famous Italian Food Drinks 00:00

🔒 Unlock the power to protect! Introducing our comprehensive course: 'Infection Control'! 🦠 In today's world, where global health concerns are at the forefront, there's never been a more crucial time to prioritize infection control. Our dynamic course equips you with the knowledge and skills needed to mitigate the spread of infectious diseases effectively. Whether you're a healthcare professional, caregiver, or simply passionate about safeguarding public health, this course is your gateway to becoming a proactive force against infections. 💪   🎓 Benefits of Taking 'Infection Control' Course: Stay Ahead of the Curve: With ever-evolving pathogens and infectious diseases, staying updated on best practices for infection control is essential. Our course provides you with the latest insights and strategies to tackle emerging threats head-on. Enhance Your Expertise: Gain a comprehensive understanding of infection control principles, protocols, and procedures. From hand hygiene to environmental cleaning, you'll acquire the expertise needed to maintain a safe and sterile environment in any setting. Protect Yourself and Others: By mastering infection control techniques, you not only safeguard your own well-being but also contribute to the health and safety of those around you. Empower yourself to be a frontline defender against infections in your community. Boost Professional Credentials: Whether you're seeking career advancement in healthcare or aiming to enhance your resume, completing our 'Infection Control' course demonstrates your commitment to excellence in infection prevention and control. Peace of Mind: Equip yourself with the knowledge and skills to navigate public health challenges with confidence. With our course, you'll gain peace of mind knowing that you're equipped to handle infection control scenarios effectively.   👩‍️ Who is this for? Healthcare Professionals: Nurses, doctors, pharmacists, and other healthcare professionals can benefit from reinforcing their infection control knowledge to provide optimal patient care. Caregivers: Whether you work in a nursing home, daycare, or home care setting, understanding infection control measures is crucial for protecting vulnerable populations. Students: Aspiring healthcare professionals and students pursuing degrees in health-related fields can gain a competitive edge by acquiring foundational knowledge in infection control early in their academic journey. Public Health Advocates: Individuals passionate about promoting public health and preventing the spread of infectious diseases will find our course instrumental in driving positive change in their communities.   🚀 Career Path: Healthcare Settings: Hospitals, clinics, long-term care facilities, and other healthcare settings prioritize infection control to ensure patient safety and prevent healthcare-associated infections. Completing our course can open doors to various roles, including infection control nurse, epidemiologist, or infection preventionist. Public Health Agencies: Governmental organizations and public health agencies rely on skilled professionals to develop and implement infection control policies and initiatives. Graduates of our course may pursue opportunities in public health departments, CDC, WHO, and other global health organizations. Research and Academia: For those interested in advancing the field of infection control through research and education, our course serves as a solid foundation for pursuing academic or research-oriented careers in universities, research institutes, or pharmaceutical companies.   Don't wait for the next outbreak to take action! Enroll in our 'Infection Control' course today and become a vital player in safeguarding public health. Together, let's combat infections and build a healthier, safer future! 💼🌍   FAQ (Frequently Asked Questions) - Infection Control Q1. What is infection control? Infection control refers to the measures and practices implemented to prevent the spread of infections in various settings, including healthcare facilities, workplaces, schools, and communities. These measures aim to reduce the risk of transmitting infectious agents, such as bacteria, viruses, fungi, and parasites, from one person to another. Infection control strategies include hand hygiene, proper use of personal protective equipment (PPE), cleaning and disinfection of surfaces, safe handling and disposal of medical waste, and adherence to standard precautions and protocols. Q2. Why is infection control important? Infection control is essential for maintaining public health and preventing the spread of infectious diseases. Effective infection control measures can reduce the incidence of healthcare-associated infections (HAIs), protect healthcare workers and patients, minimize the burden on healthcare systems, and contribute to overall well-being and productivity in various environments. By preventing the transmission of pathogens, infection control measures also play a crucial role in containing outbreaks and pandemics. Q3. How can I practice infection control in my daily life? You can practice infection control in your daily life by adopting simple yet effective habits. These include: Regular handwashing with soap and water or using alcohol-based hand sanitizers. Covering your mouth and nose with a tissue or your elbow when coughing or sneezing. Avoiding close contact with sick individuals. Keeping commonly touched surfaces clean and disinfected. Using personal protective equipment, such as masks or gloves, when necessary. Following recommended vaccination schedules. Adhering to public health guidelines and regulations, especially during outbreaks or pandemics. Q4. How does infection control apply in healthcare settings? In healthcare settings, infection control is particularly critical due to the high risk of transmitting infections between patients, healthcare workers, and visitors. In addition to standard infection control practices, healthcare facilities implement additional measures, such as: Isolation precautions for patients with contagious diseases. Strict adherence to hand hygiene protocols. Use of specialized equipment and environmental controls to prevent cross-contamination. Staff education and training on infection control guidelines and procedures. Surveillance and monitoring of healthcare-associated infections to identify and address potential risks.   By prioritizing infection control in healthcare settings, providers can ensure the safety and well-being of both patients and staff while maintaining the quality of care delivered. Course Curriculum Module 1-Introduction to Infection Introduction to Infection 00:00 Module 2-Chain of Infection Chain of Infection 00:00 Module 3- Foodborne & Waterborne infections Foodborne & Waterborne infections 00:00 Module 4- Skin Infection and Control Skin Infection and Control 00:00 Module 5-Bone Infection and it's control Bone Infection and it's control 00:00 Module 6-Nosocomial Infections and Control Nosocomial Infections and Control 00:00 Module 7-Infection prevention and control Infection prevention and control 00:00 Module 8-Good Hygiene Practices Good Hygiene Practices 00:00 Module 9-Maintaining personal hygiene Maintaining personal hygiene 00: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

Want to learn the A to Z of the versatile Inkspace program and apply the knowledge in design work or illustration? This Inkscape Training - Vector Graphics Design course will teach you everything you should know to work efficiently with the open source and free graphic design program Inkspace. If you require a detailed guide of how to use Inkspace, this Inkspace training course is for you.  Rather than solving the individual task, this comprehensive Inkscape Training - Vector Graphics Design course will give you a full tour of all the tools that you'll need to understand and use Inkspace on an amateur or professional level. In this course, you'll also be equipped with illustration tips and tricks to make smart and outstanding illustrations. What you'll learn As Inkscape is a very versatile program, and this course is taking you through from A to Z, the knowledge can be applied in amateur or professional design work, illustration or student work as well! Requirements To start the course, download Inkscape free from www.Inkscape.org! There is no necessary graphic design knowledge to start the course Who this course is for: Take the course if you need a detailed explanation of everything in Inkscape Introduction Introduction FREE 00:02:00 The user interface 00:05:00 Your first tools! Draw your first object 00:04:00 Saving your work and exporting 00:03:00 Select and transform objects 00:04:00 Dealing with multiple objects 00:07:00 Let's color it! - the basics of color usage 00:09:00 Shape and path 00:08:00 Groups and basic drawings 00:07:00 Learn more tools! Edit path by nodes 00:12:00 Another view on colors 00:06:00 Gradients 00:07:00 Going for the 3D look - gradients and blur 00:09:00 Clipping and masking 00:10:00 Working with text 00:11:00 Layers 00:05:00 Guidelines, rulers, align and distribute 00:06:00 Being a bit more creative! The spray tool 00:08:00 The pencil tool - create custom brushes 00:08:00 Sculpt tool 00:05:00 Pattern along path 00:05:00 Filters and extensions 00:04:00 Import photos and tracing FREE 00:08:00 How to create patterns 00:06:00 Blending modes 00:06:00 Put everything together! Create a Christmas card 00:04:00 Draw a funny elf character 00:18:00 Finish your character and create falling snow 00:15:00 Put text on card 00:06:00 Finalize and export your drawing 00:01:00 What's newin Inkscape 0.91? Why Inkscape 0.91 What is new 00:05:00 New way to deal with gradients! 00:04:00 Powerstroke and the symbol library 00:05:00 Tip and tricks Change canvas color 00:04:00 Use Find and replace to manage multiple objects 00:06:00 Tips for creating a good pattern 00:06:00 How to create mandala 00:06:00 Bonus lecture - check this out! 00:01:00 Additional Materials Resource Files: Inkscape Training - Vector Graphics Design 00:00:00

This Adobe Photoshop CC Advanced for Photographers has been designed for Photographers wanting to more about the production process. It shows how to extend skills using Camera RAW and HDR (High Dynamic Range). This comprehensive Adobe Photoshop CC Advanced for Photographers covers all the tools and techniques serious photographers need to know when using Photoshop, from workflow guidance to core skills to advanced techniques for professional results. Using clear, succinct instruction and real world examples, this guide is the essential reference for Photoshop users of all levels. You will learn advanced techniques that are used on a daily basis by professional photographers. These will lift your skills to a new level, and you will learn the ultimate in image control and manipulation. You will also learn how to work with exposure settings, creating grayscale images, managing corrections and effects, and creating image adjustments. Lastly, you will discover pluggings and explore workflows. This course is an ideal continuation once you have mastered the principles taught on the Basic Photoshop course. What Will I Learn? Process RAW images Working with Adobe Camera RAW Working with the tools Using Advanced Exposure Settings and Sharpening Managing Corrections and Effects Creating Image Adjustments Discovering Plugins for Photoshop Exploring Workflows Requirements Adobe Photoshop CC Advanced or equivalent knowledge. Who is the target audience? Photographers who wish to learn the advanced features of Photoshop. Introduction Introduction FREE 00:03:00 Processing Raw Images What is the RAW Format FREE 00:04:00 Understanding White Balance 00:05:00 Setting Exposure 00:07:00 Working with Color and Clarity 00:03:00 Working with Adobe Camera Raw Updating Adobe Camera Raw 00:01:00 Using the Before and After Views 00:05:00 Resetting the Sliders 00:01:00 Understanding the Workflow Options 00:04:00 Setting the Camera Raw Preferences 00:03:00 Working with the Tools Understanding the White Board Tool 00:03:00 Using the Color Sampler 00:01:00 Working with the Targeted Adjustment Tool 00:02:00 Cropping Images 00:03:00 Applying Straightening 00:01:00 Using the Spot Removal Tool 00:05:00 Applying the Red Eye Tool 00:03:00 Understanding the Adjustment Brush 00:04:00 Using the Graduated Filter 00:02:00 Applying the Radial Filter 00:02:00 Rotating Images 00:01:00 Using Advanced Exposure Settings and Sharpening Using Curves 00:03:00 Understanding Sharpening and Noise 00:03:00 Creating Grayscale Images 00:03:00 Using Split Toning 00:03:00 Managing Corrections and Effects Enabling Lens Profiles 00:03:00 Using Effects 00:02:00 Adding Grain 00:02:00 Applying Post Crop Vignette 00:02:00 Using Camera Calibration 00:03:00 Saving Presets 00:02:00 Applying Snapshots 00:02:00 Creating Image Adjustments Using Adjustment Layers 00:02:00 Painting Layer Masks 00:05:00 Discovering Plugins for Photoshop What are Plugins 00:04:00 Using the Nik Collection 00:08:00 Using HDR Pro Effex 00:06:00 Using On1 Effects 00:04:00 Exploring Workflows Processing a Landscape Image 00:13:00 Processing a Macro Image 00:09:00 Processing a City 00:11:00 Conclusion Course Recap 00:01:00 Course Certification

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 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. 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 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

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

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

Why You Should Choose The Ultimate Guide Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? The Ultimate Guide is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our The Ultimate Guide 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Should I be a Designer? Promo 00:02:00 What do I need to become a Designer? 00:05:00 What is it like to be a Designer? 00:02:00 How much can I earn as a Designer? 00:03:00 Costs of being a Designer 00:05:00 Freelancing vs Full time job 00:04:00 Where should I work? 00:04:00 Lifelong learning 00:02:00 Workspace Chair 00:02:00 Desk 00:03:00 Bookshelf 00:01:00 Pinboard 00:01:00 Desktop 00:01:00 Tools Computer and Screen 00:02:00 Storage and Backup 00:01:00 Wacom tablets and Pen displays 00:03:00 Camera 00:01:00 Mobile phones and Tablets 00:01:00 Applications Photoshop 00:05:00 Illustrator 00:01:00 InDesign 00:02:00 Acrobat 00:01:00 Lightroom 00:01:00 Bridge 00:01:00 Essential Skills Intro 00:01:00 Composition and Layout 00:02:00 Digital Image Theory 00:03:00 File Management 00:02:00 Layers 00:02:00 Colors 00:02:00 Selections 00:02:00 Masking 00:01:00 Pen tool 00:02:00 Adjustments 00:01:00 Image Editing and Filters 00:02:00 Brush Tool 00:01:00 Typography 00:02:00 Images in InDesign 00:01:00 Tracing Images 00:01:00 Camera RAW 00:03:00 Specialization Intro 00:01:00 Print Design 00:02:00 Web, Tablet and Mobile design 00:02:00 Photo Retouch 00:01:00 Digital Art 00:02:00 Getting Recognized Intro 00:01:00 Getting Inspired 00:04:00 Keep track of your tasks 00:02:00 Crowd-sourcing and contests 00:03:00 Sharing your work 00:01:00 Screen-casting and Blogging 00:02:00 Portfolio 00:04:00 Internship 00:02:00 Certfication 00:02:00 Creative CV 00:02:00 Applying for jobs and attending Interviews 00:03:00 Conclusion What's next? 00:02:00 Resources Resources- Ultimate Guide course 00:00:00