518 Courses in Cardiff delivered Online

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

A course that focuses on using Kotlin for server-side development using the Spring Boot framework. This hands-on course will help you get familiar with the basics of the Kotlin programming language as well as the entire process of building RESTful APIs using Kotlin Spring Boot.

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

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