538 Courses

Duration 4 Days 24 CPD hours This course is intended for This class is ideal for admins with at least 6 months of experience administering Salesforce, and is a great foundational course for anyone looking to earn their Salesforce Advanced Administrator credential. Overview Determine and implement appropriate data access and visibility settings. Manage configuration changes in a sandbox environment and move metadata between environments using change sets. Extend the functionality of your implementation with custom objects and apps. Extend your reporting to provide up-to-date views of your business. Customize the Salesforce mobile app and create quick actions to increase efficiency. Improve data quality so that the ongoing task of data maintenance is not so overwhelming. Implement complex business processes using workflow rules, Process Builder, approval processes, and flows. Take your Salesforce Administrator skills to the next level and supercharge your knowledge to solve pressing business needs. In this 4-day class, discover how to extend Salesforce with custom objects and Lightning apps, generate complex reports and dashboards, and automate complex business requirements to work more efficiently. Our Salesforce experts will share tips and best practices to take your admin skills to the next level and arm you with the skills to get more out of Salesforce. Record Access and Field Visibility Troubleshoot Record Access Understand the Impact of Territory Management on the Sharing Model Manage Field Visibility Change Management Manage Changes in a Sandbox Deploy Changes Using Change Sets Custom Objects and Apps Build Custom Objects, Tabs, and Apps Create Relationships Between Objects Use Delegated Administration Advanced Reporting Create Custom Report Types Build Exception Reports with Cross Filters Categorize Report Data with Bucketing Extend Summaries in Reports and Dashboards Display Multiple Views of Data Using Joined Reports Analyze Data Over Time with Historical Trending and Reporting Snapshots Salesforce Mobile App and Quick Actions Customize the Salesforce Mobile App Create Object-Specific Quick Actions Create Global Quick Actions Data Quality Assess, Cleanse, and Maintain Data Prevent Duplicate Records Using Duplicate Management Automated Business Processes Use Validation Rules, Formula Fields, Workflow Rules, and Process Builder to Enforce and Automate Business Processes Approval Processes Manage Approval Processes Troubleshoot Approval Processes Visual Workflow Understand Use Cases for Visual Workflow Build and Deploy a Flow Advanced Business Process Automation Understand When to Use Apex and Visualforce for Extending Business Process Automation Understand the Order of Execution for Automated Processes Use Debug Logs to Troubleshoot Business Process Issues

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Developers, Developer Consultants, and Technology Consultants. Overview Define Data ServicesDefine Source and Target ConnectionsTrace, Validate, and Debug Data Services JobsUse Data Services TransformsImplement Change Data Capture in Data Services In this course, students will learn how to define data services, source, and target connections, as well as use data services transforms and implement change in data capture within data services. Data Services Defining Data Services Source and Target Metadata Defining Datastores in Data Services Defining a Data Services Flat File Format Batch Job Creation Creating Batch Jobs Batch Job Troubleshooting Writing Comments with Descriptions and Annotations Validating and Tracing Jobs Debugging Data Flows Auditing Data Flows Functions, Scripts, and Variables Using Built-In Functions Using Variables, Parameters, and Scripts Platform Transforms Using Platform Transforms Using the Map Operation Transform Using the Validation Transform Using the Merge Transform Using the Case Transform Using the SQL Transform Error Handling Setting Up Error Handling Changes in Data Capturing Changes in Data Using Source-Based Change Data Capture (CDC) Using Target-Based Change Data Capture (CDC) Data Services (Integrator) Platform Transforms Using Data Services (Integrator) Platform Transforms Using the Pivot Transform Using the Data Transfer Transform Additional course details: Nexus Humans DS10 SAP Data Services - Platform and Transforms training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DS10 SAP Data Services - Platform and Transforms course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Master advanced Excel skills and boost your career with our Microsoft Excel Advanced Diploma Course. Gain proficiency in data analysis, understand advanced features, and develop practical expertise.

JavaScript is the backbone of dynamic websites and interactive web applications, and this course is designed to guide you smoothly through its essentials. Whether you’re a complete beginner or someone keen to brush up on scripting, this course breaks down complex concepts into clear, digestible segments. You’ll explore the fundamentals of JavaScript, including variables, functions, events, and the Document Object Model (DOM), setting a solid foundation for future coding endeavours. This course offers a straightforward path to understanding how JavaScript shapes user experiences on the internet. With engaging explanations and carefully structured lessons, you’ll gain the confidence to read, write, and troubleshoot JavaScript code. Ideal for those interested in web development or looking to add a valuable skill to their repertoire, the course ensures your journey into scripting is smooth, enjoyable, and highly rewarding. Learning Outcomes: Gain a solid understanding of JavaScript concepts, including conditional statements, functions, and event handling. Learn how to work with cookies, page redirection, and popup boxes using JavaScript. Understand advanced JavaScript concepts like regular expressions and browser debugging. Build your skills in JavaScript validation techniques. Gain the skills and confidence needed to create dynamic and interactive web pages. JavaScript for Everyone is a comprehensive course designed to provide you with a solid understanding of JavaScript concepts and their application in web development. From basic concepts like conditional statements and functions to advanced topics like regular expressions and debugging, this course covers everything you need to know to become proficient in JavaScript. With our step-by-step approach and hands-on exercises, you'll gain the skills and confidence needed to create your own JavaScript-based web applications. JavaScript for Everyone Course Curriculum Section 01: Introduction Section 02: Basic Concepts on JavaScript Section 03: Conditional and Switch Statements Section 04: JS Functions Section 05: JS Events Section 06: JS Cookies Section 07: JS Page Redirection Section 08: JS Popup boxes Section 09: JS Void Section 10: JS Print Section 11: JS Objects Section 12: JS Number Object Section 13: JS Boolean Object Section 14: JS String Object Section 15: JS Arrays Section 16: JS Dates Section 17: JS Math and Reg Exp Section 18: JS Browsers and summary Section 19: JS Debugging Section 20: JS Errors Section 21: JS Validations How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Web developers who want to enhance their skills in JavaScript and create dynamic and interactive web pages. Students who want to learn web development and gain a solid understanding of JavaScript concepts. Entrepreneurs who want to develop their own web-based applications using JavaScript. Anyone who wants to explore the world of JavaScript and expand their knowledge of web development. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Front End Developer: £24,000 - £55,000 Full Stack Developer: £30,000 - £75,000 Web Application Developer: £28,000 - £65,000 Senior Web Developer: £40,000 - £90,000 Technical Lead: £50,000 - £100,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Description: Nowadays Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel's uses cover a wide gamut - from simple data entry to complicated financial models and analysis. This Microsoft Office 2016 Excel Advanced - Complete Video Course is designed to help you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. You will learn Visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and more. So, if you have intermediate skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface. Then this advanced level will be very helpful for you. So, be an expert by joining us. 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? Microsoft Office 2016 Excel Advanced - Complete Video Course 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 Microsoft Office 2016 Excel Advanced - Complete Video Course 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. Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

About Course Unlock key insights with our comprehensive guide to market research - propel your business towards unprecedented growth Our immersive online course on Market Research provides a comprehensive exploration into the intricate art and science of understanding consumer behaviour, trends, and market dynamics. Do you want to grow your business and take it to new heights? Achieving sustainable growth requires a deep understanding of your target audience and a keen awareness of industry trends. This marketing course equips you with the knowledge and skills required to understand your target customers and their needs. We start with a brief history and definition of 'market research' before we lay out the six steps of the market research process. This course examines the classifications of market research and explains how to identify research problems to set up the market research process. We show you how to develop and design a market research approach. We also trace the relationship between market problems and research design by distinguishing between exploratory, descriptive and causal research. The course goes over data analysis techniques and discusses how to deliver effective presentations of research findings to facilitate analysis and discussion. We cover qualitative and quantitative market research methods and provide examples to help you with questionnaire design with examples of open- and closed-end questions. We demonstrate data analysis techniques to help you leverage your research findings to make better business decisions. Finally, the course explains how to communicate research results while adhering to market research ethics. This course has no prerequisites and suits anyone interested in business and marketing. It is particularly useful for small business owners, entrepreneurs and marketers and helps you to create focused marketing campaigns that connect with your audience to boost customer engagement, brand loyalty and business success. Sign up to learn how to conduct market research that lets you understand consumer behaviour, spot gaps in the market and grow your business. Whether you're a budding marketer, a business owner, or a student of the commerce field, this course offers a comprehensive and practical guide to mastering market research. Enroll now to gain the knowledge and skills that can help shape business strategies, influence product development, and drive business success. What Will You Learn? Discuss the importance of market research in supporting marketing decision-making Identify the factors that influence the decision to conduct market research Outline the key components of a market research proposal Discuss the significance of problem identification in marketing research Analyse the key characteristics and advantages of qualitative research Recognise the factors that affect the sample size and accuracy in quantitative research Identify the key components and goals of a questionnaire Explain the importance of data validation and quality control Summarise the significance of the report and presentation as key components of marketing research Discuss the ethical principles of research methodology and the importance of integrity in market research Course Content Introduction to Market Research Introduction to Market Research The Market Research Process The Market Research Process Market Research Design Market Research Design Defining the Problem & Developing Research Approach Defining the Problem & Developing Research Approach Qualitative Market Research Qualitative Market Research Quantitative Market Research Quantitative Market Research Questionnaire Design Questionnaire Design Data Analysis Data Analysis Communicating Research Results Communicating Research Results Research Ethics Research Ethics Conclusion Conclusion A course by Xpert Learning Audience Marketers Current and aspiring product managers Business executives Consultants Entrepreneurs

Description Register on the Web Development Bootcamp: Learn Web Development from Scratch today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Web Development Bootcamp: Learn Web Development from Scratch course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.   Course Content Section 01: Getting Started Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask a Great Questions 00:01:00 FAQ's 00:01:00 Section 02: HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 Section 03: HTML Basic Heading tags 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 IDs 00:06:00 Comments 00:04:00 Section 04: HTML Intermediate Images 00:12:00 Forms 00:05:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 Section 05: HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 Section 06: JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:14:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 Section 07: JavaScript Basics Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Strings 00:06:00 String Formatting 00:05:00 Section 08: JavaScript Operators Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 Section 09: JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statement 00:04:00 Section 10: JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 Section 11: JavaScript Functions Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 Section 12: JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 Section 13: JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Section 14: Python Introduction Introduction to Python 00:02:00 Python vs Other Languages 00:04:00 Why It's Popular 00:04:00 Command Line Basics 00:07:00 Python Installation (Step By Step) 00:06:00 PyCharm IDE Installation 00:08:00 Getting Start PyCharm IDE 00:05:00 First Python Hello World Program 00:07:00 Section 15: Python Basic Variables 00:16:00 Data Types 00:13:00 Type Casting 00:07:00 User Inputs 00:08:00 Comments 00:04:00 Section 16: Python Strings Strings 00:05:00 String Indexing 00:05:00 String Slicing 00:04:00 String Built-in Functions 00:09:00 Formatting String (Dynamic Data) 00:05:00 Section 17: Python Operators Arithmetic Operators 00:08:00 Assignment Operators 00:05:00 Comparison Operators 00:05:00 Logical Operators 00:02:00 AND Operator 00:04:00 OR Operator 00:02:00 NOT Operator 00:03:00 Booleans 00:02:00 Section 18: Python Data Structures Arrays in Earler 00:02:00 Lists 00:06:00 Add List Items 00:03:00 Remove List Items 00:01:00 Sort Lists 00:03:00 Join Lists 00:08:00 Tuples 00:08:00 Update tuples 00:07:00 Join tuples 00:02:00 Dictionaries 00:06:00 Add Dictionary Items 00:04:00 Remove Dictionary Items 00:03:00 Nested Disctionaries 00:04:00 Sets 00:04:00 Add Set Items 00:03:00 Remove Set Items 00:01:00 Join Set Items 00:04:00 Section 19: Python Conditional Statements If Statement 00:03:00 If-else Statement 00:04:00 If-elif-else Statement 00:04:00 If Statement Coding Excercise 00:05:00 Section 20: Python Control Flow Statements Flow Charts 00:06:00 While Loops Statement 00:10:00 For Loops Statement 00:06:00 The range() Function 00:04:00 Nested Loops 00:04:00 2D List using Nested Loop 00:04:00 Section 21: Python Core Games Guessing Game 00:07:00 Car Game 00:10:00 Section 22: Python Functions Creating a Function 00:03:00 Calling a Function 00:06:00 Function with Arguments 00:05:00 Section 23: Python Args, KW Args For Data Science args, Arbitary Arguments 00:04:00 kwargs, Arbitary Keyword Arguments 00:06:00 Section 24: Python Project Project Overview 00:04:00 ATM RealTime Project 00:13:00

The Microsoft Office Essentials - 3 Course Bundle has been expertly designed for you to complete through distance e-learning. Successful completion of the Microsoft Office bundle will see you achieve a CPD certified proficiency which will add significant weight to your CV and impress potential employers when applying for new jobs. Enrol now on the Microsoft Office Essentials - 3 Course Bundle and get access to top-quality training modules. Start studying Microsoft Office using any internet-enabled device including computers, tablets, and smartphones. With 24/7 student support, you can be sure of quick and comprehensive assistance whenever you need it. Why Choose Microsoft Office Essentials - 3 Course Bundle? Opportunity to boost your CV/Resume with CPD accredited proficiency Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Certificates available in both PDF and hard copy format Interactive, high-quality course content with 24/7 online access Full tutor support and learning assistance included Course Curriculum Breakdown: Here are the topics you will cover on the Microsoft Office Essentials - 3 Course Bundle Course: Microsoft Excel 2022 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Excel Templates Excel Templates CPD 11 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Essentials - 3 Course Bundle has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Microsoft Office Essentials - 3 Course Bundle. Requirements Enrol on the Microsoft Office Essentials - 3 Course Bundle with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Office Essentials - 3 Course Bundle without any delay. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited Certificate Hard copy certificate - £29

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

Course Information In today's evolving landscape, pharmacovigilance (PV) systems face ongoing challenges due to global, national, and company-specific events. This course focuses on developing personnel equipped to navigate these complexities and improve the safe use of medicinal products. We emphasise continuous global thinking, communication, and strategic planning, ensuring adaptability across various levels. The course explores maintaining PV system functionality while adhering to regulatory requirements. Participants will apply European regulatory standards to enhance and sustain PV system effectiveness, contributing to improvement initiatives and ensuring operational integrity. The course covers PV system intricacies, regulatory compliance, and a 'systems approach' for auditors, quality assurance personnel, and PV practitioners. Through presentations and workshops, attendees gain insights into implementing and maintaining an effective PV system. Who should attend? Auditors Pharmacovigilance Quality System Managers Pharmacovigilance scientists The QPPV. Course benefits Throughout the course delegates will explore application of the legal requirements for the PV system and quality system and how to assure these systems. They will demonstrate their ability to contribute to: A systematic investigation of the pharmacovigilance system and its quality system Examination of how the pharmacovigilance system and quality system interact to achieve compliance. The risk-based approach to auditing the PV system and quality system The maintenance of 'inspection readiness' Explore how to investigate the complex PV system Discussions about how to monitor and maintain the PV system and assure compliance. Course Objectives Clarify what has to be done: Explore application of the legal requirements. Explore how to do what has to be done: Adopt a systemic approach to systematically investigate or implement and maintain the PV system and quality system Examine how a compliant PV system and a compliant quality system interact to achieve compliance with regulatory requirements for PV Explore how to investigate the complexity of the PV system. Discus how to identify what is missing or what needs to be improved: Discuss how to monitor and maintain the PV system and assure compliance. This course will assist delegates with: An understanding of key system principles, A practical approach to implementing, maintaining and monitoring the PV system and its quality system A procedure to share expertise to increase efficiency and confidence. This course is structured to encourage delegates to: Discuss and develop ideas - Share knowledge and experiences - Solve specific problems.  By the end of the course delegates will be able to: Understand better the pharmacovigilance system, its quality system and how the components interact to achieve the objectives of pharmacovigilance Investigate, and analyse the pharmacovigilance system and to identify what is missing and what needs to be improved. Tutors Tutors will be comprised of (click the photos for biographies): Jana Hyankova Head of PV Department, IVIGEE Services a.s. Programme Please note timings may be subject to alteration. Day 1 08:30 Welcome, registration, course objectives and introduction to work groups Housekeeping notices, meet other delegates, explore how to work in your work group, course objectives. Clarify the definition and objectives of Pharmacovigilance. 09:30 The Regulatory Framework for Pharmacovigilance Identify the relevant regulations and directives. Explore GVP guidance, structure of the modules and standard format of each module. 10:00 The Pharmacovigilance System Exploration of how to organise what has to be done, communications. Exploration of the structures and processes for pharmacovigilance. 10:30 Break 11:00 Workshop 1 and Feedback Exploring an organisational model of the pharmaceutical company- cooperation between PV and other stakeholders. 12:00 The Quality System for pharmacovigilance Exploration of the structures, processes for the PV quality system and discussion of how it interacts with the pharmacovigilance system to meet the objectives of pharmacovigilance effectively and efficiently. 13:00 Lunch 14:00 Workshop 2 and Feedback The quality system puzzle. Explore the organisation of the PV quality system and how it interacts with the PV system. 14:30 The Quality System for pharmacovigilance Exploration of the structures processes for the PV quality system and discussion of how it interacts with the pharmacovigilance system to meet the objectives of pharmacovigilance effectively and efficiently. 15:00 Description of PV System 15:30 Break 15:30 Workshop 3 and Feedback The quality system puzzle Explore the organisation of the PV quality system and how it interacts with the PV system. 16:00 The Pharmacovigilance Safety Master File Construction of the Pharmacovigilance System Master File and its purpose. 17:00 Workshop 3 and Feedback Description of PV System. 18:00 End of Day Day 2 08:30 Drug Safety in the Clinical Trial Environment - Part 1 Information flow and responsibilities of the sponsor. 09:30 Workshop 4 and Feedback Drug Safety in the Clinical Trial environment: Information flow and responsibilities of the sponsor. 10:30 Break 11:00 Drug Safety in the Clinical Trial Environment - Part 2 Information flow and responsibilities of the sponsor. 12:00 Lunch 13:00 Workshop 5 and Feedback Drug Safety in the clinical trial environment: Information flow and responsibilities of the sponsor. 13:30 Processing of Safety Data Exploration of safety data processing, verification, validation, follow up, formatting and collation, reporting requirements, quality and data management. 15:00 Break 15:30 EudraVigilance Exploration of how EudraVigilance supports the PV system. 16:15 Signal Detection and Evaluation/Risk Benefit Assessment: Pharmacovigilance Risk Assessment Committee (PRAC): What is a signal? What are the regulatory requirements? How is signal detection and evaluation conducted? Qualitative and quantitative methods of signal detection. Risk benefit assessment. 17:00 Risk Management Plans A cornerstone of Pharmacovigilance safety communications, direct healthcare professional communication 18:00 End of Day Day 3 08:30 The Pharmacovigilance Risk Assessment Committee (PRAC) Exploration of how good practice is achieved. Composition, role and responsibilities. Examples of referrals. 09:15 Development Safety Update Reports (DSURs): Regulatory requirements, exploring good practice, report format, reference safety information, schedule of submission, analysis evaluations and distribution. 10:00 Periodic Safety Update Reports (PSURs)/Periodic Benefit Risk Evaluation Reports (PBRERs) Regulatory requirements, exploring good practice, report format, reference safety information, schedule of submission, analysis evaluations and distribution. 10:30 Break 11:00 Periodic Safety Update Reports (PSURs)/Periodic Benefit Risk Evaluation Reports (PBRERs) Regulatory requirements, exploring good practice, report format, reference safety information, schedule of submission, analysis evaluations and distribution. 12:00 Workshop 6 and Feedback To explore the compilation and submission of the PSUR. 13:00 Lunch 13:30 Role of the QPPV Exploration of the legal responsibilities of the QPPV and the MAH. 14:30 Break 15:00 Workshop 7 and Feedback To explore the challenges faced by the QPPV. 15:30 End of course Extra Information Face-to-Face Course Course material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device< Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking You will need a stable internet connection, a microphone and a webcam. CPD Points 23 Points   Development Level Develop