13286 Organ courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for This class is designed for experienced Salesforce Administrators with little or no Flow experience who need to streamline business processes with no-code automated solutions. This class is not recommended for developers. However, if you are a developer interested in learning Flow, we highly recommend Declarative Development for Platform App Builders in Lightning Experience (DEX403). Overview When you complete this course, you will be able to: Create automated no-code solutions with Salesforce Flow. Analyze use cases and effectively translate requirements into design plans that detail accurate Flow building processes. Understand and leverage various Flow types, elements, and resources. Build Screen Flows and manage screen layouts and field visibility. Implement Flows on Home and Record pages. Automate business processes by creating Record-Triggered Flows (based on record create, update, or delete) to perform specific actions. Identify best practices for creating and managing Flows. Streamline business processes and automate manual tasks across your organization by building no-code automation solutions with Flow Builder. In this 3-day class designed for administrators, our experts will introduce you to Screen and Record-Trigger Flows, in addition to various Flow elements and resources. Learn how to effectively create and manage Flows that champion automation best practices, solve for user requirements, and empower you to get more out of Salesforce. Foundations of Flow Create Variables Understand Algorithms Explore Control Structures Examine Flow Best Practices Screen Flows Use Elements and Resources Control Field Visibility Manage Data and Navigation Surface a Flow Complete the Flow Record-Triggered Flows Define Flow Triggers Use Flow Triggers to Replace Formula Fields Share Records with Flow Additional course details: Nexus Humans Salesforce Automate No-Code Solutions Using Flow (ADX301) 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 Salesforce Automate No-Code Solutions Using Flow (ADX301) 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.

Duration 4 Days 24 CPD hours This course is intended for Security-operations (SecOps), or security, orchestration, automation, and response (SOAR) engineers, managed security service providers (MSSPs), service delivery partners, system integrators, and professional services engineers Overview This training is designed to enable a SOC, CERT, CSIRT, or SOAR engineer to start working with Cortex XSOAR integrations, playbooks, incident-page layouts, and other system features to facilitate resource orchestration, process automation, case management, and analyst workflow. The course includes coverage of a complete playbook-development process for automating a typical analyst workflow to address phishing incidents. This end-to-end view of the development process provides a framework for more focused discussions of individual topics that are covered in the course. The Cortex? XSOAR 6.8: Automation and Orchestration (EDU-380) course is four days of instructor-led training that will help you: Configure integrations, create tasks, and develop playbooks Build incident layouts that enable analysts to triage and investigate incidents efficiently Identify how to categorize event information and map that information to display fields Develop automations, manage content, indicator data, and artifact stores, schedule jobs, organize users and user roles, oversee case management, and foster collaboration This class is powered by Cloud Harmonics. Course Outline Module 1 - Core Functionality and Feature Sets Module 2 - Enabling and Configuring Integrations Module 3 - Playbook Development Module 4 - Classification and Mapping Module 5 - Layout Builder Module 6 - Solution Architecture Module 7 - Docker Module 8 - Automation Development and Debugging Module 9 - The Marketplace and Content Management Module 10 - Indicators and Threat Intelligence Management Module 11 - Jobs and Job Scheduling Module 12 - Users and Role-Based Access Controls (RBAC) Module 13 - Integration Development Additional course details: Nexus Humans Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380) 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 Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380) 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.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification. Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Using VBA with Form Controls Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Duration 1 Days 6 CPD hours This course is intended for This course is intended for customer service professionals with some experience in the field who want to expand or refresh their knowledge and improve their skills. It is also intended for customer service professionals who have taken on, or are looking to assume, greater leadership responsibility. Overview In this course, you will refresh and expand your customer service skill set. You will: Apply fundamental customer service knowledge and skills. Manage your everyday workflow. Take care of customers by assessing their needs, resolving their issues, and encouraging further sales. Deal with challenging customer interactions. Apply customer service leadership skills In this course, you will apply important principles and skills you can use as a customer service professional. In addition to providing basic customer service, you'll also learn important principles and skills that will empower you to solve difficult and challenging customer interactions, encourage further sales, and take on leadership responsibilities. Applying Customer Service Foundations Topic A: Assess Customer Service Basics Topic B: Develop Interpersonal Skills Managing Your Workflow Topic A: Apply Organizational Skills Topic B: Handle Simultaneous Customer Contacts Topic C: Manage Individual Stress Taking Care of Customers Topic A: Maintain Focus on the Issue Topic B: Assess Customers Topic C: Diagnose Customers? Problems Topic D: Educate the Customer Topic E: Resolve Customers? Problems Topic F: Encourage Further Sales Through Service Dealing with Challenging Customer Interactions Topic A: Recognize Difficult Situations Topic B: Work within Your Company Parameters Topic C: Handle a Difficult Interaction Topic D: Overcome Negativity Topic E: Redirect the Customer Topic F: Follow Up on a Challenging Situation Progressing to Leadership Topic A: Lead from Within Your Team Topic B: Address Escalated Customer Issues Topic C: Analyze Customer Service Metrics Additional course details: Nexus Humans Excellence in Customer Service (Advanced) 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 Excellence in Customer Service (Advanced) 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.

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is as follows: System administrators Technical solutions architects Systems integrators Channel partners Value-added resellers Customer sales engineers DevOps engineers Sales engineers Systems engineers Technical solutions architects Overview Upon completing this course, the learner will be able to meet these overall objectives: Understand Cisco UCS Management in Cisco Intersight Describe the Cisco UCS Platform including Cisco X-Series Understand Cisco Intersight Workload Optimizer Explain Kubernetes Orchestration with Cisco Intersight Kubernetes Service (IKS) and Cisco UCS Perform Automation Using Cisco Intersight Create Intersight Elements Using Terraform Manage Intersight Using the API Cisco Intersight Overview (DCISO) is a 3-day instructor led course that builds your experience with the administration of Cisco Unified Computing System (UCS) X-Series servers, including using Cisco Intersight for UCS management. This course covers architecture, configuration, and operation of Cisco Intersight©, and is designed to serve the needs of engineers seeking to understand the capabilities of Cisco Intersight for managing data centers from a single management platform.This course will help you:Use SaaS or on-prem version of Cisco Intersight to enable IT organizations to analyze, simplify, and automate their environments in more advanced ways than the prior generations of toolsGain hands-on experience using Cisco IntersightUnderstand the X-Series, B-Series, and C-Series product line similarities and differencesDescribe Cisco Intersight and how it can be used to manage UCS and Cisco Hyperflex©Understand the process for upgrading firmware with Cisco IntersightAdministering server profiles, pools, and policies with Cisco IntersightDescribe how to get started with Cisco Intersight programmability Course Outline Describing Cisco UCS Management in Cisco Intersight Describing the Cisco UCS Platform Describing Cisco Intersight Workloads Describing Automation Options Using Cisco Intersight Additional course details: Nexus Humans Cisco Intersight Overview (DCISO) 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 Cisco Intersight Overview (DCISO) 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.

Duration 4 Days 24 CPD hours This course is intended for Systems Administrators and EngineersTechnical Solutions ArchitectsSystems IntegratorsChannel PartnersValue-Added Resellers Overview Understand the B-Series and C-Series product line similarities and differencesDescribe the C-Series standalone and UCS managed architectures Understand the process for upgrading B-Series and C-Series FirmwareAdministering service profiles, pools, and policiesUnderstanding RBAC with Active Directory integrationAdministering backup and restores in UCS ManagerLearn and discuss the various management tools for Cisco UCSPerform basic troubleshooting of B-Series and C-Series in normal operations Using real-world scenarios and examples, this course will explore all of the components of the UCS B-Series and C-Series solutions from a day to day administrative point of view. UCS Infrastructure Components Cisco UCS Servers and Components Exploring Cisco UCS User Interfaces Cisco UCS Management Framework and Features Administering Cisco C-Series Servers Describing Cisco UCS C-Series Servers Cisco UCS C-Series Integrated Management Controller Provisioning Monitoring and Logging on the Cisco UCS C-Series Server Provisioning Cisco UCS C-Series Server Integration in UCS Manager Updating Cisco UCS C-Series Firmware with the Host Upgrade Utility Troubleshooting C-Series Standalone and UCS Managed Environments Administering Cisco B-Series Servers RBAC, Organizations, and Active Directory Integration Configuring Compute Node LAN Connectivity Configuring Compute Node SAN Connectivity Creating Identity and Resource Pools Creating Service Profiles Creating Templates and Cloning Service Profiles Managing Service Profiles Operating System Installation Options Backing Up and Restoring UCSM Database Upgrading UCS B-Series Firmware Troubleshooting Cisco UCS B-Series Configuration Troubleshooting Cisco UCS B-Series Operation UCS Management Tools UCS Management Tool Overview Integrating UCS Manager with UCS Central Managing UCS Using the Cisco UCS PowerTool Additional course details: Nexus Humans Cisco Administering Cisco Data Center Unified Computing System (DCUCA) 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 Cisco Administering Cisco Data Center Unified Computing System (DCUCA) 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.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for anyone engaged with teams or looking to live a more fulfilling life. Overview Upon successful completion of this course, participants will gain a new perspective on themselves and their emotions, and increase their value to society. In this course, participants will learn how beneficial becoming more self-aware can be and see how a highly self-aware person becomes more equipped to deal with daily life and its challenges. Getting Started Workshop Objectives Action Plan What is the Self? The Physical Self The Emotional Self The Mental Self The Spiritual Self Practical Illustration Awareness of the Physical Self Scanning Progressive Relaxation Physical Stressors Exercise Practical Illustration Time Management Organization Goal Management Priorities Procrastination Practical Illustration The Emotional Self Validity of Emotions Utility of Emotions Emotional Arousal Emotional Valence Practical Illustration Mood Management Emotional Intelligence Categories of Emotion Increasing Arousal Decreasing Arousal Practical Illustration The Mental Self Thinking Style Learning Style Personality Stinking Thinking Practical Illustration Interpersonal Awareness Addressing Different Thinking Styles Addressing Different Learning Styles Active Listening and Body Language Transactional Analysis Practical Illustration The Spiritual Self Mindfulness Meditation Cultivating Positivity Gratitude Practical Illustration Limitations of Self Awareness Navel Gazing Excessive Self Discipline Developing Humility Developing Empathy Practical Illustration Independence versus Interdependence What is Interdependence? Systems Theory More Than the Sum of All Parts Team Building Practical Illustration Wrapping Up Words from the Wise Additional course details: Nexus Humans Improving Self Awareness 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 Improving Self Awareness 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.

Duration 5 Days 30 CPD hours This course is intended for Application Consultant Business Process Owner / Team Lead / Power User Overview This course will prepare you to: Provide an overview of basic customizing settings in the main components of Financial Accounting with SAP S/4HANA Configure the Master Data Settings (G/L Accounts, Customer and Vendor Accounts) of Financial Accounting with SAP S/4HANA Configure the Document Control and Posting Control Settings of Financial Accounting with SAP S/4HANA Configure the Settings for Financial Document Clearing of Financial Accounting with SAP S/4HANA The course provides an overview of how to implement Financial Accounting capabilities of SAP S/4HANA in order to cover the related business requirements. You will gain the mandatory foundation knowledge required in order to understand and configure business processes for the SAP S/4HANA financials module in the areas of general ledger, accounts payable, and accounts receivable accounting. For the Master Data, the Document Control/Posting Control and Financial Document Clearing you will practice some configurations and verify the result by using the application. Course Outline Short Overview of SAP S/4HANA Core Financial Accounting (FI) Configuration Managing Organizational Units in Financial Accounting (FI) Checking the Basic Settings in New General Ledger (G/L) Accounting Outlining the Variant Principle Managing Fiscal Year Variants Master Data Maintaining General Ledger (G/L) Accounts Managing Customer and Vendor Accounts Document Control Configuring the Header and Line Items of Financial Accounting (FI) Documents Managing Posting Periods Managing Posting Authorizations Posting Control Analyzing Document Splitting Maintaining Default Values Configuring Change Control Configuring Document Reversal Configuring Payment Terms and Cash Discounts Maintaining Taxes and Tax Codes Posting Cross-Company Code Transactions Financial Document Clearing Performing Open Item Clearing Managing Payment Differences Additional course details: Nexus Humans S4F12 SAP Basics of Customizing for Financial Accounting: GL, AP, AR in SAP S/4HANA 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 S4F12 SAP Basics of Customizing for Financial Accounting: GL, AP, AR in SAP S/4HANA 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.

Duration 2 Days 12 CPD hours This course is intended for Technical professionals who need to install, configure, and manage Virtual Security Extension (VSX) solutions within their network security environment. Overview Explain the benefits of virtual network security. Understand the basic functions, components, and advantages of VSX technology. Examine the VSX management infrastructure and understand how traffic flows within a VSX network. Discuss options for deploying VSX technology within various types of organizations. Understand how to install and configure VSX Gateways and Virtual Systems. Describe different routing schemes and features that are available to use within the VSX environment. Understand how to deploy additional VSX networking configurations that may be required in the environment. Understand the differences between deploying physical Security Gateway Clusters and VSX Gateway Clusters. Understand how Virtual System Load Sharing works to enhance VSX network performance. Understand how to use the VSX Provisioning Tool to add and remove virtual devices. Recall how CoreXL technology enhances Security Gateway performance and recognize how to use the technology in a VSX environment. Understand how to employ tools for optimizing resources allocated in a VSX environment. Identify various VSX command line tools commonly used to retrieve information and perform configuration changes. Understand how to use VSX utility commands to perform various maintenance tasks for the VSX environment. Understand how to troubleshoot and debug issues that may occur in a VSX environment. This course provides a comprehensive understanding of the Check Point VSX solution and describes how to deploy it within the corporate network environment. Course Topics VSX Overview Virtual System Installation and Configuration VSX Clustering Advanced VSX Features Troubleshooting VSX LAB EXERCISES Configuring the VSX Environment Deploying a Virtual System with a Physical Interface Deploying a VS with Bonded VLAN Interfaces Configuring Virtual System HA Converting VSX High Availability to Virtual System Load Sharing Maintaining the VSX Environment Using the CLI to Manage VSX Performance Tuning in VSX Troubleshooting VSX Issues Upgrading a VSX Environment Additional course details: Nexus Humans CCVS Check Point Certified VSX Specialist 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 CCVS Check Point Certified VSX Specialist 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.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. Your training and experience using Microsoft© Access© has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Promoting Quality Data Input Topic A: Restrict Data Input Through Field Validation Topic B: Restrict Data Input Through Forms and Record Validation Lesson 2: Improving Efficiency and Data Integrity Topic A: Data Normalization Topic B: Associate Unrelated Tables Topic C: Enforce Referential Integrity Lesson 3: Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Lesson 4: Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Lesson 5: Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Lesson 6: Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report