6239 Courses

This the official Modak Institute training, 80 hours classroom plus 4 hours online talks/PDF. Come to get alignment with the source of this work. Modak Institute is the only official Institute of the master Kusum Modak. Learning from A to Z with the official manual. Level 3 Diploma coming soon.

Business Writing Skills Online You must not miss out on the four Business Writing Skills courses if you want to thrive in your workplace and stand out from the crowd. Writing is one of the four domains of language, and it is widely used in business communication in different forms. In this Business Writing Skills course, we have combined four highly valuable courses, namely - Business Writing Level 5 Proofreading & Copy Editing Level 5 Report Writing Course Level 4 Copywriting Minute Taking Business Writing Skills - Level 5 Proofreading & Copy Editing course will give you in-depth knowledge of proofreading and why it is necessary. It will also cover the aspects of copy editing. If you complete this course, you will be able to proofread and edit any writing at your workplace. Thus, through this course, your area of expertise will be widened, and subsequently, your value as an employee will be increased. Business Writing Skills - Level 5 Report Writing Course also has various advantages. In any organisation, there are various types of reports to be written, for example, project reports, project proposals, partnership proposals etc. With this Business Writing Skills course, you will become an expert Report Writer. Business Writing Skills - Level 4 Copywriting is highly trending. Copywriters are behind the catchy advertisements you see on different platforms. Imagine you are writing such copies and as a result, the sales get increased in a great number! With this course, you can learn all the basics, tips and tricks of copywriting. Business Writing Skills - Minute Taking is also important. In any organisation, you need to attend or facilitate numerous meetings. And, in the meeting, one dedicated person needs to record the details of the meeting. Here comes minute taking. If you know how to take minutes of any meeting, you will get a competitive edge over your coworkers. Won't you love to unlock all the contents of this Business Writing Skills Course? Benefits of Business Writing Skills Course Free 5 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Business Writing Skills course] Business Writing Skills Course Curriculum of Business Writing Skills Module 01: An Overview of Proofreading Module 02: Use of the Style Guide Module 03: Spelling and Grammar Module 04: Paper-based Proofreading Module 05: On the Screen Proofreading Module 06: Basics of Copy Editing Module 07: Copy Editing - the Use of Language Module 08: Copy Editing - Checking Accuracy and Facts Module 09: Copy Editing - Legal Checks Module 10: Career Development Assessment Method of Business Writing Skills After completing each module of Business Writing Skillscourse, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification of Business Writing Skills After completing the MCQ/Assignment assessment for this Business Writing Skills course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Business Writing Skills This Business Writing Skills course is ideal for all. This course is highly valuable if you want to be a successful executive in your workplace. It is also needed for business owners, managers, supervisors, freelance writers. Requirements Business Writing Skills There is no specific requirement to enrol for this Business Writing Skills course. However, you must have a strong desire to learn new things and apply those in your relevant field. Career path Business Writing Skills This Business Writing Skills course will open the door for many positions! Such as - Freelance Writer, Copywriter, Proofreader, Business Executives, Executives in TV, Media, Communication Executives in different organisations. Certificates Certificate of completion Digital certificate - Included

Are you aware of the misleading things that happen often to children? Learn how to safeguard the children around you and make your caregiver career effortless by obtaining a recognized certificate. This Course at a Glance Get an overview of safeguarding children. Learn the law of safeguarding. Understand the structure of safeguarding. Learn to Recognise Risks. Understand types of Abuse and more. Achieved reward CPD UK accredited certificate. Learn through engaging video-based training sessions. Continuous tutor support is available 24/7. Safeguarding Children Level 3 Overview The safeguarding children level 3 course is developed for the individual who wants to be aware of the unnoticed incidents that haappen to childrens. This course will immensely discuss this issue and guide the people, including how to be aware of the types of abuse, safeguarding laws, structure and more. Overall this course will unveil all the concerns and ways related to the safeguarding of children. Additionally, employers, professional organisations, and academic institutions value the safeguarding children level 3 course accredited by CPD UK. For details, please visit the Learner FAQs on our website. Who should take this course? The safeguarding children level 3 course is suitable for the following: Individuals who work with children. Professionals like nurses, social workers, school teachers and caregivers. Mother and soon to be mother. Any individual wishing to learn to stay aware of it. Entry Requirements The safeguarding children level 3 course requirments are the following:  You need a laptop or PC and a stable internet. Any previous qualifications are not required. Assessment On the assessment round, you will participate in the MSQ test to examine your learning from this course. After completing the gardening course's all modules, learners must answer MCQs to complete the assessment procedure.  The MCQ test measures how much a learner can grasp from each section. In the assessment test, you must get 60% as a pass mark. Course Curriculum Introduction to Safeguarding ● What 'Safeguarding' Means ● Who is Responsible for Protecting Children from Abuse? ● Statistics About the Different Types of Child Abuse Safeguarding and The Law ● The Laws Surrounding Safeguarding ● The Key Principles of The Acts and Details and Background of The Laws Safeguarding Structure ● What the Single Assessment is ● The Possible Outcomes of The Assessment ● What Happens If There Is A Risk of Serious Imminent Harm? Types of Abuse ● Different Forms of Abuse That A Child May Be Exposed ● Who May Be an Abuser Recognising Risks ● How You Can Recognise the Risks of Child Abuse ● How to Judge if a Report Needs to be Made or Not ● What Makes Children More Vulnerable to Child Abuse Reporting and Responding to Concerns ● How a Person Can Respond and Report to Concerns That a Child is Being Abused ● The Different Types of Disclosure ● How to Record Concerns and Disclosures Recording Concerns ● How to Report and Record Concerns That a Child is Being Abused ● Methods That Are the Most Useful Post Referral ● What Happens After a Referral Has Been Made - Its Potential Outcomes ● What is a Child Protection Conference? Recognised Accreditation CPD Certification Service CPD stands for Continuing Professional Development. This term refers to learning activities that professionals undertake to improve their skills and capabilities. Employers and professional organizations globally recognize CPD UK. Thus, a certificate from CPD Certification Service creates value for your professional goal and achievement. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam, you can order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. The certificate can be obtained in PDF version for £12, and there is an additional fee to receive a printed copy certificate which is £35. FAQs Why Should I do this Safeguarding Children training course? You must do this course as it will teach you how to protect children from abuse, which anyone working with people under 18 requires. This course will provide you with in-depth information about how to recognise if the child is being abused or not, and report any concerns. I am a mother, should I need this course? Mothers are highly encouraged to do this course as being a mother is not all. Due to a lack of safeguards, a mother cannot permanently presume the children's trauma and issues. Thus, she has to be educated on this matter, and it will only be possible by doing this course online. Can I utilise this learning outcome in practical life? Yes, indeed, you can utilise this course outcome in your real-life situation. You encounter the presence of children every time and everywhere in your daily life. You can easily recognise signs of child abuse or neglect Since you have gained the skills through the course. Where will I work after doing this course? You can work in several places, like school, daycare, homecare, etc. I am from outside the UK. Will I get access to the Course? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol in our courses. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realize the benefit of having a CPD-accredited certificate once you face the corporate world. As employees, job places, and more value the CPD-accredited certificate, you must own this certificate by doing the course with us. What do you mean by a CPD course? CPD refers to Continuing Professional Development, and the CPD-accredited course is developed for individuals who want to improve and update their skills within their professional field continuously. This certificate claims that the certificate holder's knowledge is up-to-date in their work area. How safe is it to purchase a course over the Internet? We have been providing courses over the internet for years, and all our learners' info is safe with us. We have implemented robust security measures to protect our learners' personal and financial information. Additionally, we use secure payment gateways to ensure safe transactions for course purchases.

Delve into the crucial domain of child welfare with the 'Child Protection Officer: Safeguarding Children's Welfare Course'. Designed meticulously, this course offers learners an unparalleled insight into safeguarding the well-being of children in the UK. From comprehending the essentials of child protection to understanding the specific protocols in the education system and sports sector, this comprehensive programme ensures you're equipped with the knowledge to make a difference. Learning Outcomes Understand the foundational principles of child protection and safeguarding. Recognise and appropriately respond to various child abuse cases. Master the protocols for sharing information concerning child safeguarding. Efficiently report any identified maltreatments or abuses. Grasp the procedures for addressing allegations against staff members in various settings. Why buy this Child Protection Officer: Safeguarding Children's Welfare Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success Who is this Child Protection Officer: Safeguarding Children's Welfare Course for? Individuals aspiring to work within child protection services. Teachers and educators wanting to understand child safeguarding in the educational sector. Sports coaches and trainers aiming to ensure child safety in sportive environments. Caretakers and guardians aiming to enhance their knowledge on child welfare. Policy makers keen on developing or refining child protection guidelines. Career path Child Protection Officer: £30,000 - £40,000 Safeguarding Coordinator in Schools: £25,000 - £35,000 Sports Safeguarding Manager: £28,000 - £38,000 Child Welfare Specialist: £32,000 - £42,000 School Counsellor focusing on Child Safety: £27,000 - £37,000 Child Protection Policy Developer: £35,000 - £45,000 Prerequisites This Child Protection Officer: Safeguarding Children's Welfare Course does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Child Protection and Safeguarding Basics Child Protection and Safeguarding Basics 00:16:00 Module 02: Child Protection In the UK Child Protection In the UK 00:20:00 Module 03:Respond to Child Abuses Respond to Child Abuses 00:14:00 Module 04: Sharing Information about Any Safeguarding Concerns Sharing Information about Any Safeguarding Concerns 00:16:00 Module 05: Report Abuse Report Abuse 00:11:00 Module 06: Maltreatment of Children Maltreatment of Children 00:19:00 Module 07: Child Protection in Education System Child Protection in Education System 00:22:00 Module 08: Allegations Against Staff Allegations Against Staff 00:18:00 Module 09: Child Protection in Sport & Active Leisure Child Protection in Sport & Active Leisure 00:21:00

CITB HEALTH AND SAFETY AWARENESS COURSE The 1 Day CITB Health and Safety Awareness course is for those who have entered, or are about to enter the construction and civil engineering industry as a member of the workforce, to help them understand the potential hazards that they face at work on site. The Site Safety Plus 1 day CITB health and safety awareness course provides a practical summary of safety, welfare and environmental issues identifying individual responsibilities for looking after themselves and others, what the employers duties are and what should be done if they think anyones safety and health is being put at risk. The aims and objectives of the CITB health and safety awareness course are to ensure that individual responsibilities are understood: why they are carrying out their identified duties what is expected of them to ensure that they contribute to the safety of the workplace To ensure that the end of the CITB health and safety in construction course delegates will be able to: understand the need to prevent accidents have an understanding of the law identify how their role fits into the control and management of the site understand the need for risk assessments and method statements appreciate the need to perform safely and to stop and ask for advice if not sure feel obliged to report unsafe acts to prevent an accident IMPORTANT INFORMATION Photographic I.D. is required for all delegates Written parental consent is required for all delegates under 18 years of age Failure to provide this on the first day of the course is likely to result in the delegate not being allowed to attend or complete the training.

Join EnergyEdge's classroom training course and gain valuable insights into Exploration and Production Accounting - Level 3. Enroll today!

Duration 4 Days 24 CPD hours This course is intended for The information protection administrator translates an organization?s risk and compliance requirements into technical implementation. They are responsible for implementing and managing solutions for content classification, data loss prevention (DLP), information protection, data lifecycle management, records management, privacy, risk, and compliance. They also work with other roles that are responsible for governance, data, and security to evaluate and develop policies to address an organization's risk reduction and compliance goals. This role assists workload administrators, business application owners, human resources departments, and legal stakeholders to implement technology solutions that support the necessary policies and controls. Learn how to protect information in your Microsoft 365 deployment. This course focuses on data lifecycle management and information protection and compliance within your organization. The course covers implementation of data loss prevention policies, sensitive information types, sensitivity labels, data retention policies, Microsoft Purview Message Encryption, audit, eDiscovery, and insider risk among other related topics. The course helps learners prepare for the Microsoft Information Protection Administrator exam (SC-400). Prerequisites Foundational knowledge of Microsoft security and compliance technologies. Basic knowledge of information protection concepts. Understanding of cloud computing concepts. Understanding of Microsoft 365 products and services. 1 - Introduction to information protection and data lifecycle management in Microsoft Purview Know your data Protect your data Prevent data loss Govern your data 2 - Classify data for protection and governance Data classification overview Classify data using sensitive information types Classify data using trainable classifiers Review sensitive information and label usage Explore labeled and sensitive content Understand activities related to your data 3 - Create and manage sensitive information types Compare built-in versus custom sensitive information types Create and manage custom sensitive information types Describe custom sensitive information types with exact data match Implement document fingerprinting Create keyword dictionary 4 - Understand Microsoft 365 encryption Learn how Microsoft 365 data is encrypted at rest Understand service encryption in Microsoft Purview Explore customer key management using Customer Key Learn how data is encrypted in-transit 5 - Deploy Microsoft Purview Message Encryption Implement Microsoft Purview Message Encryption Implement Microsoft Purview Advanced Message Encryption Use Microsoft Purview Message Encryption templates in mail flow rules 6 - Protect information in Microsoft Purview Information protection overview Configure sensitivity labels Configure sensitivity label policies Configure auto-labeling policies Manage, monitor, and remediate information protection 7 - Apply and manage sensitivity labels Apply sensitivity labels to Microsoft Teams, Microsoft 365 groups, and SharePoint sites Plan on-premises labeling Configure on-premises labeling for the Unified Labeling Scanner Apply protections and restrictions to email and files Monitor label performance using label analytics 8 - Prevent data loss in Microsoft Purview Data loss prevention overview Identify content to protect Define policy settings for your DLP policy Test and create your DLP policy Prepare Endpoint DLP Manage DLP alerts in the Microsoft Purview compliance portal View data loss prevention reports Implement the Microsoft Purview Extension 9 - Configure DLP policies for Microsoft Defender for Cloud Apps and Power Platform Configure data loss prevention policies for Power Platform Integrate data loss prevention in Microsoft Defender for Cloud Apps Configure policies in Microsoft Defender for Cloud Apps Manage data loss prevention violations in Microsoft Defender for Cloud Apps 10 - Manage data loss prevention policies and reports in Microsoft 365 Configure data loss prevention for policy precedence Implement data loss prevention policies in test mode Explain data loss prevention reporting capabilities Manage permissions for data loss prevention reports Manage and respond to data loss prevention policy violations 11 - Manage the data lifecycle in Microsoft Purview Data Lifecycle Management overview Configure retention policies Configure retention labels Configure manual retention label policies Configure auto-apply retention label policies Import data for Data Lifecycle Management Manage, monitor, and remediate Data Lifecycle Management 12 - Manage data retention in Microsoft 365 workloads Explain retention in Exchange Online Explain retention in SharePoint Online and OneDrive Explain retention in Microsoft Yammer Activate archive mailboxes in Microsoft Exchange Apply mailbox holds in Microsoft Exchange Recover content in Microsoft Exchange 13 - Manage records in Microsoft Purview Records management overview Import a file plan Configure retention labels Configure event driven retention Manage, monitor, and remediate records 14 - Explore compliance in Microsoft 365 Plan for security and compliance in Microsoft 365 Plan your beginning compliance tasks in Microsoft Purview Manage your compliance requirements with Compliance Manager Examine the Compliance Manager dashboard Analyze the Microsoft Compliance score 15 - Search for content in the Microsoft Purview compliance portal Explore Microsoft Purview eDiscovery solutions Create a content search View the search results and statistics Export the search results and search report Configure search permissions filtering Search for and delete email messages 16 - Manage Microsoft Purview eDiscovery (Standard) Explore Microsoft Purview eDiscovery solutions Implement Microsoft Purview eDiscovery (Standard) Create eDiscovery holds Search for content in a case Export content from a case Close, reopen, and delete a case 17 - Manage Microsoft Purview eDiscovery (Premium) Explore Microsoft Purview eDiscovery (Premium) Implement Microsoft Purview eDiscovery (Premium) Create and manage an eDiscovery (Premium) case Manage custodians and non-custodial data sources Analyze case content 18 - Manage Microsoft Purview Audit (Standard) Explore Microsoft Purview Audit solutions Implement Microsoft Purview Audit (Standard) Search the audit log Export, configure, and view audit log records Use audit log searching to investigate common support issues 19 - Prepare Microsoft Purview Communication Compliance Plan for communication compliance Identify and resolve communication compliance workflow Case study--Configure an offensive language policy Investigate and remediate communication compliance alerts 20 - Manage insider risk in Microsoft Purview Insider risk management overview Create and manage insider risk policies Investigate insider risk alerts Take action on insider risk alerts through cases Manage insider risk management forensic evidence Create insider risk management notice templates 21 - Implement Microsoft Purview Information Barriers Explore Microsoft Purview Information Barriers Configure information barriers in Microsoft Purview Examine information barriers in Microsoft Teams Examine information barriers in OneDrive Examine information barriers in SharePoint 22 - Manage regulatory and privacy requirements with Microsoft Priva Create and manage risk management policies Investigate and remediate risk management alerts Create rights requests Manage data estimate and retrieval for rights requests Review data from rights requests Get reports from rights requests 23 - Implement privileged access management Case study--Implementing privileged access management 24 - Manage Customer Lockbox Manage Customer Lockbox requests

Diploma of Event Management (Online) - CPD Certified Are you looking for a challenging and rewarding career in private investigation? The demand for private investigators in the UK is growing, with an estimated 10,000 new jobs expected to be created by 2025. Our CPD-certified course will teach you the skills you need to succeed in this exciting field, including surveillance, interviewing, and report writing. Enrol today and start your journey to becoming a private investigator! Courses Are Included in this Diploma of Event Management (Online) - CPD Certified Bundle: Course 01: Advanced Diploma in Event Management at QLS Level 7 Course 02: Diploma in Wedding Planner at QLS Level 5 Course 03: Kids Party Planner Diploma Course 04: Diploma in Catering Management at QLS Level 4 Course 05: Wedding Photography Training Course 06: Project Management Course Learning Outcomes Gain a comprehensive knowledge of the UK legal system, understanding the essential legalities and ethics involved in private investigation, boosting your credibility in the field. Develop critical thinking and analytical skills, equipping you to solve complex cases; 80% of our graduates report improved problem-solving abilities. Learn advanced surveillance techniques and modern technology applications, vital for over 90% of private investigative work in today's digital world. Understand the business side of private investigation, empowering you to start your own investigative agency, an opportunity pursued by 40% of our alumni. Achieve a CPD-certified diploma, enhancing your career opportunities in a market seeing a 30% rise in demand for qualified private investigators. Why Choose Our Event Management Course? FREE Event Management certificate accredited Get a free student ID card with Event Management Training Get instant access to this Event Management course. Learn Event Management from anywhere in the world Event Management is affordable and simple to understand Event Management is entirely online, interactive lesson with voiceover audio Lifetime access to the Event Management course materials Event Management comes with 24/7 tutor support So enrol now in this Event Management Today to advance your career! Start your learning journey straightaway with Diploma of Event Management (Online) - CPD Certified! This Event Management curriculum has been designed by Event Management experts with years of experience behind them. The Event Management course is extremely dynamic and well-paced to help you understand Event Management with ease. You'll discover how to master the Event Management skill while exploring relevant and essential topics. Assessment Process of Diploma of Event Management (Online) - CPD Certified Once you have completed all the courses in the Event Management bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 230 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Diploma of Event Management (Online) - CPD Certified This Diploma of Event Management (Online) - CPD Certified bundle is suitable for everyone. Requirements Diploma of Event Management (Online) - CPD Certified You will not need any prior background or expertise to enrol in this Diploma of Event Management (Online) - CPD Certified. Career path Diploma of Event Management (Online) - CPD Certified This Diploma of Event Management (Online) - CPD Certified bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course. Access 2019 Beginner Module 1: Introduction to the course 00:01:00 Module 2: What is Database 00:03:00 Module 3: Understanding Database terminology 00:04:00 Module 4: Navigating the Access Interface 00:09:00 Module 5: What is Flat file Database 00:03:00 Module 6: What is Relational Database 00:10:00 Module 7: Relating Tables 00:08:00 Module 8: Reviewing the Access Ribbon 00:02:00 Module 9: Working with Tables 00:07:00 Module 10: Navigating Tables 00:03:00 Module 11: Editing Data 00:03:00 Module 12: Adding New Records 00:03:00 Module 13: Using Subdatasheets 00:04:00 Module 14: Understanding Database and Table Design Principles 00:09:00 Module 15: Using Table Data Sheet View 00:04:00 Module 16: Working with Field Data Types 00:07:00 Module 17: Using Table Design View 00:04:00 Module 18: Using Calculated Fields 00:08:00 Module 19: Calculating Dates 00:04:00 Module 20: Calculating Strings 00:04:00 Module 21: Using the Lookup Wizard 00:11:00 Module 22: Lookup Wizard Linking Tables 00:06:00 Module 23: Using Indexes 00:05:00 Module 24: What are Queries 00:06:00 Module 25: Creating Simple Queries 00:05:00 Module 27: Entering Criteria-Exact Match and Ranger Operators 00:06:00 Module 28: Understanding And VS Or 00:06:00 Module 29: Using Wild Cards 00:04:00 Module 30: Using Key Words 00:04:00 Module 31: Sorting and Hiding Fields 00:03:00 Module 32: Creating Multi-Table Queries 00:03:00 Module 33: Creating a Calculated Field in Query 00:05:00 Module 34: Additional Tips 00:05:00 Module 35: What are Reports 00:04:00 Module 36: Understanding Report Types 00:03:00 Module 37: Building Good Reports 00:02:00 Module 38: Using Autoreport 00:06:00 Module 39: The Report Wizard 00:12:00 Module 40: Using the Report Design View 00:07:00 Module 41: Printing Reports 00:04:00 Module 42: Creating Labels 00:05:00 Module 43: Additional Tips 00:09:00 Module 44: What are Forms 00:03:00 Module 45: Understanding Form Types 00:03:00 Module 46: Creating Forms 00:02:00 Module 47: Navigating Forms 00:02:00 Module 48: Editing Data in Forms 00:05:00 Module 49: Understanding the Form Wizard 00:05:00 Module 50: Using the Form Design View 00:04:00 Module 51: Working with Controls 00:07:00 Module 52: Using the Form Layout View 00:03:00 Module 53: Additional Tips 00:07:00 Downloadable Resources Resources - Access 2019 Beginner 00:00:00 Final Exam Final Exam - Access 2019 Beginner 00:20: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