7377 Systems courses delivered Online

Front Desk Skills Training Level 3 Course Overview: The "Front Desk Skills Training Level 3" course provides comprehensive training for individuals seeking to enhance their front desk expertise. It covers essential areas such as customer service, communication, time management, and business writing, equipping learners with the skills needed to excel in a professional front desk or receptionist role. The course is designed to improve learners' organisational abilities, efficiency in managing tasks, and proficiency in handling a wide range of administrative duties. By the end of the course, learners will have a solid foundation in key front desk responsibilities, preparing them for a variety of roles in customer-facing environments. Course Description: This course offers in-depth coverage of essential front desk skills, including telephone etiquette, managing business correspondence, travel arrangements, and the organisation of meetings and conferences. Learners will gain the ability to effectively manage time and maintain accurate records, develop strong business writing skills, and master organisational tasks crucial to front desk operations. The course also focuses on enhancing communication and customer service capabilities, ensuring learners are well-equipped to represent their employer with professionalism. With a balanced focus on administrative tasks and customer interaction, the training prepares individuals to thrive in dynamic front desk roles, enabling career progression in various industries. Front Desk Skills Training Level 3 Curriculum: Module 01: Introduction to Reception and Receptionist Module 02: Business Telephone Skills Module 03: Representing Your Boss and Company Module 04: Mail Services and Shipping Module 05: Travel Arrangements Module 06: Organising Meetings and Conferences Module 07: Time Management Module 08: Record Keeping and Filing Systems Module 09: Business Writing Skills Module 10: Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning and Scheduling Module 14: Invoicing/Petty Cash (See full curriculum) Who is this course for? Individuals seeking to enhance their front desk skills. Professionals aiming to improve their administrative and communication abilities. Beginners with an interest in administrative or customer service roles. Those seeking career advancement in office management or receptionist positions. Career Path Front Desk Receptionist Office Administrator Executive Assistant Customer Service Representative Administrative Assistant Office Manager Travel Coordinator Conference and Event Coordinator

Duration 4 Days 24 CPD hours This course is intended for Security engineers Security administrators Security architects Operations engineers Network engineers Network administrators Network or security technicians Network managers System designers Cisco integrators and partners Overview After taking this course, you should be able to: Describe and administer the Cisco Email Security Appliance (ESA) Control sender and recipient domains Control spam with Talos SenderBase and anti-spam Use anti-virus and outbreak filters Use mail policies Use content filters Use message filters to enforce email policies Prevent data loss Perform LDAP queries Authenticate Simple Mail Transfer Protocol (SMTP) sessions Authenticate email Encrypt email Use system quarantines and delivery methods Perform centralized management using clusters Test and troubleshoot This course shows you how to deploy and use Cisco© Email Security Appliance to establish protection for your email systems against phishing, business email compromise, and ransomware, and to help streamline email security policy management. This hands-on course provides you with the knowledge and skills to implement, troubleshoot, and administer Cisco Email Security Appliance, including key capabilities such as advanced malware protection, spam blocking, anti-virus protection, outbreak filtering, encryption, quarantines, and data loss prevention. This course helps you prepare to take the exam, Securing Email with Cisco Email Security Appliance (300-720 SESA). Describing the Cisco Email Security Appliance Cisco Email Security Appliance Overview Technology Use Case Cisco Email Security Appliance Data Sheet SMTP Overview Email Pipeline Overview Installation Scenarios Initial Cisco Email Security Appliance Configuration Centralizing Services on a Cisco Administering the Cisco Email Security Appliance Distributing Administrative Tasks System Administration Managing and Monitoring Using the Command Line Interface (CLI) Other Tasks in the GUI Advanced Network Configuration Using Email Security Monitor Tracking Messages Logging Controlling Sender and Recipient Domains Public and Private Listeners Configuring the Gateway to Receive Email Host Access Table Overview Recipient Access Table Overview Configuring Routing and Delivery Features Controlling Spam with Talos SenderBase and Anti-Spam SenderBase Overview Anti-Spam Managing Graymail Protecting Against Malicious or Undesirable URLs File Reputation Filtering and File Analysis Bounce Verification Using Anti-Virus and Outbreak Filters Anti-Virus Scanning Overview Sophos Anti-Virus Filtering McAfee Anti-Virus Filtering Configuring the Appliance to Scan for Viruses Outbreak Filters How the Outbreak Filters Feature Works Managing Outbreak Filters Using Mail Policies Email Security Manager Overview Mail Policies Overview Handling Incoming and Outgoing Messages Differently Matching Users to a Mail Policy Message Splintering Configuring Mail Policies Using Content Filters Content Filters Overview Content Filter Conditions Content Filter Actions Filter Messages Based on Content Text Resources Overview Using and Testing the Content Dictionaries Filter Rules Understanding Text Resources Text Resource Management Using Text Resources Using Message Filters to Enforce Email Policies Message Filters Overview Components of a Message Filter Message Filter Processing Message Filter Rules Message Filter Actions Attachment Scanning Examples of Attachment Scanning Message Filters Using the CLI to Manage Message Filters Message Filter Examples Configuring Scan Behavior Preventing Data Loss Overview of the Data Loss Prevention (DLP) Scanning Process Setting Up Data Loss Prevention Policies for Data Loss Prevention Message Actions Updating the DLP Engine and Content Matching Classifiers Using LDAP Overview of LDAP Working with LDAP Using LDAP Queries Authenticating End-Users of the Spam Quarantine Configuring External LDAP Authentication for Users Testing Servers and Queries Using LDAP for Directory Harvest Attack Prevention Spam Quarantine Alias Consolidation Queries Validating Recipients Using an SMTP Server SMTP Session Authentication Configuring AsyncOS for SMTP Authentication Authenticating SMTP Sessions Using Client Certificates Checking the Validity of a Client Certificate Authenticating User Using LDAP Directory Authenticating SMTP Connection Over Transport Layer Security (TLS) Using a Client Certificate Establishing a TLS Connection from the Appliance Updating a List of Revoked Certificates Email Authentication Email Authentication Overview Configuring DomainKeys and DomainKeys Identified Mail (DKIM) Signing Verifying Incoming Messages Using DKIM Overview of Sender Policy Framework (SPF) and SIDF Veri?cation Domain-based Message Authentication Reporting and Conformance (DMARC) Verification Forged Email Detection Email Encryption Overview of Cisco Email Encryption Encrypting Messages Determining Which Messages to Encrypt Inserting Encryption Headers into Messages Encrypting Communication with Other Message Transfer Agents (MTAs) Working with Certificates Managing Lists of Certificate Authorities Enabling TLS on a Listener?s Host Access Table (HAT) Enabling TLS and Certi?cate Verification on Delivery Secure/Multipurpose Internet Mail Extensions (S/MIME) Security Services Using System Quarantines and Delivery Methods Describing Quarantines Spam Quarantine Setting Up the Centralized Spam Quarantine Using Safelists and Blocklists to Control Email Delivery Based on Sender Configuring Spam Management Features for End Users Managing Messages in the Spam Quarantine Policy, Virus, and Outbreak Quarantines Managing Policy, Virus, and Outbreak Quarantines Working with Messages in Policy, Virus, or Outbreak Quarantines Delivery Methods Centralized Management Using Clusters Overview of Centralized Management Using Clusters Cluster Organization Creating and Joining a Cluster Managing Clusters Cluster Communication Loading a Configuration in Clustered Appliances Best Practices Testing and Troubleshooting Debugging Mail Flow Using Test Messages: Trace Using the Listener to Test the Appliance Troubleshooting the Network Troubleshooting the Listener Troubleshooting Email Delivery Troubleshooting Performance Web Interface Appearance and Rendering Issues Responding to Alerts Troubleshooting Hardware Issues Working with Technical Support References Model Specifications for Large Enterprises Model Specifications for Midsize Enterprises and Small-to-Midsize Enterprises or Branch O?ces Cisco Email Security Appliance Model Specifications for Virtual Appliances

Duration 5 Days 30 CPD hours This course is intended for This course is intended for those who provide site collection and site administration and are power users or IT professionals who are tasked with supporting or working within the SharePoint 2016 environment on premise and/or in Office 365. Overview After completing this course, students will be able to: - Design and implement a company portal structure using SharePoint 2016 objects including sites, libraries, lists and pages - Explain the role of security and permissions throughout SharePoint 2016 - Implement guidelines for consistency in building a company portal to aid in the day-to-day administration of content in SharePoint 2016 - Enhance the design and content of a company portal using SharePoint 2016 pages and web parts - Explain the importance of governance for the planning and managing future growth of the - SharePoint 2016 implementation - Identify options to integrate data from other systems such as Microsoft Office, as well as preserve existing data - Explain the role of social networking in SharePoint 2016 and its impact on collaboration This course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. Getting Started with SharePoint 2016 Exploring SharePoint 2016 Site Collection and Site Administrator Roles Defining SharePoint Terminology Navigating a SharePoint Site Interacting with the Ribbon Creating and Editing Basic Content What is Metadata? Versions of SharePoint Standard Enterprise O365 Building a Site Collection with Apps The Structure of SharePoint Creating a Site What does a site template come with? Defining SharePoint Apps Customizing Lists and Libraries Creating/Managing Lists and Libraries through SharePoint Designer Explaining Views on Lists and Libraries Creating Views in Lists and Libraries Modifying Navigation Turning Site Features On/Off Reorganizing a Site using Site Content and Structure feature Lab 1: Creating a Structured Company Portal Lab 2: Creating a List Using SharePoint Designer (Optional) Creating Consistency across Sites Defining Site Columns Defining Content Types Implementing a Taxonomy Using Templates to Promote Consistency Lab 1: Creating Site Columns and Content Types Lab 2: Implementing a Taxonomy Lab 3: Configuring the Content Organizer SharePoint Permissions Explaining Permissions and Security in SharePoint Creating SharePoint Groups Managing Permissions within SharePoint Sharing versus Traditional Security Sharing as different permission levels Lab 1: Managing Permissions in SharePoint Working with Pages and Web Parts Changing the Appearance of the Portal Editing a Page wiki web part Working with Web Parts and App Parts App Parts Content Search Web Part Relevant Documents Content query Table of Contents Pictures Web Part Connections Filter web parts Web parts with Targeting Audience Lab 1: Adding and Configuring Web Parts Lab 2: Connecting Web Parts Lab 3: Applying Themes to Your Company Portal Document and Records Management Basic Content Approval Versioning Check In/Out Holds Retention Policy Document ID Content Organizer Compliance Policy Center Site Template EDiscovery Records Center Lab 1: Working with Advanced Document Management Features Lab 2: Leveraging Records Management to Preserve Data Workflow Alerts Out of the Box Workflow Activating Workflow Features Approval Workflow Creating a Workflow in SharePoint Designer Lab 1: Creating an Approval Workflow from SharePoint Lab 2: Creating a Custom Workflow in SharePoint Designer (Optional) Office Integration Outlook Calendar Contacts Excel Word PowerPoint OneDrive for Business OneNote Access Lab 1: Importing and Exporting Excel Data with SharePoint Lab 2: Linking Outlook and SharePoint Creating Publishing Sites Why use a publishing site? Publishing Pages Enabling Web Content Management Managing the Structure of Web Content Navigating a Site Using Managed Metadata Lab 1: Creating a Rich Publishing Sit Lab 2: Configuring a Publishing Approval Process Lab 3: Implementing a Managed Navigation Site Bridging the Social Gap My Sites Configuring Social Features in SharePoint Posts, Tags and Mentions Creating a Community Site Lab 1: Designing a Social Experience in SharePoint 2016 Lab 2: Creating a Community Site Finding Information Using Search Exploring the Search Features in SharePoint Configuring Search Settings Search Analytics Search Visibility Lab 1: Configuring an Advanced Search Center Planning a Company Portal Using SharePoint Defining SharePoint Governance Working with Information Architecture Implementing Site Hierarchies Discussing the Execution of Governance Site Collection Administrator Settings Exploring Settings for Site Collection Administrators Exploring Settings for Site Administrators Site Closure Policies Additional course details: Nexus Humans 55234 SharePoint 2016 Site Collections and Site Owner Administration 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 55234 SharePoint 2016 Site Collections and Site Owner Administration 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.

Hydrogen sulphide (H₂S) might not ring alarm bells at first, but this gas is no joke. Known for its pungent “rotten egg” smell, H₂S is both toxic and flammable—making awareness of it absolutely vital in industries like oil and gas, wastewater, mining, and chemical production. This course is tailored for individuals working in or around environments where hydrogen sulphide may be present, offering the essential safety knowledge to recognise hazards, respond swiftly, and reduce risks effectively. You’ll gain a solid understanding of how hydrogen sulphide behaves, where it’s typically found, and what to do when exposure becomes a threat. From warning systems to emergency actions, every key topic is covered in a clear, accessible way—no fluff, just the facts you need. Whether you're new to this or brushing up your knowledge, this course provides the confidence to navigate H₂S environments with the caution and awareness they demand. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to H2S Awareness Module 02 : Hazards Associated with H2S Module 03 : Detection and Monitoring of H2S Module 04 : Safety Measures Module 05 : Emergency Response Learning Outcomes: Identify the characteristics of H2S and its risks. Recognize potential hazards associated with H2S exposure. Demonstrate proficiency in H2S detection and monitoring. Implement safety measures to prevent H2S incidents. Respond effectively to H2S-related emergencies. Safeguard yourself and others in hazardous environments. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Oil and gas industry workers Chemical plant employees Construction site personnel Environmental safety professionals Emergency responders Anyone working in H2S-prone areas Entry-level safety personnel Health and safety enthusiasts Career path Health and Safety Officer Environmental Compliance Specialist Emergency Response Coordinator Process Operator Chemical Plant Operator Industrial Safety Consultant Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

If chasing payments without sounding like a debt collector is your idea of a good time, this Credit Controller Training Course might just be your professional soulmate. Designed for those looking to refine their approach to credit control, this online course takes a structured look at the key responsibilities of credit controllers—from assessing credit risk to managing overdue accounts and improving cash flow. It’s all delivered in a format that fits neatly into your schedule, with no awkward role-plays or fluorescent-lit classrooms in sight. With a sharp focus on clarity, strategy, and communication, the course offers valuable insights into setting credit limits, working with accounting systems, and ensuring debt recovery remains firm but fair. You’ll gain confidence in crafting polite but persuasive correspondence, understanding credit policies, and handling disputes without raising blood pressure—yours or theirs. Whether you're new to credit control or want to polish up your existing approach, this course offers the knowledge you need, minus the fluff and buzzwords. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Introduction to Financial Management Module 02: Fundamentals of Budgeting Module 03: The Balance Sheet Module 04: The Income Statement Module 05: The Cash Flow Statement Module 06: Statement of Stockholders' Equity Module 07: Analysing and Interpreting Financial Statements Module 08: Inter-Relationship Between all the Financial Statements Module 09: International Aspects of Financial Management Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Credit Controller training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Credit Controller training. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

This Electrical Safety Management Training provides job-ready skills, expert insights, and a certification that helps you establish a safe and compliant working environment. Enrol now and take control of electrical safety in your workplace! 🚀

Course Overview The Restaurant Management Level 3 course offers a comprehensive exploration of the skills and strategies required to successfully manage a restaurant. Covering key areas such as menu planning, staff recruitment, financial management, and customer relations, this course prepares learners to navigate the dynamic restaurant industry with confidence. Whether aspiring to open a new venue or improve existing operations, learners will gain valuable insights into creating efficient layouts, maintaining safety standards, managing inventory, and implementing effective marketing strategies. The course blends theoretical knowledge with real-world industry standards, equipping participants to handle the complexities of restaurant management. By completing this course, learners will be able to develop structured plans for running a successful restaurant, cultivate a strong team culture, and deliver exceptional customer experiences. This qualification provides a valuable stepping stone towards achieving career goals in the vibrant hospitality sector. Course Description The Restaurant Management Level 3 course delves into the essential elements that underpin a thriving restaurant business. Topics covered include restaurant selection and set-up, legal and health regulations, drinks and food management, technology integration, financial planning, staff training, and customer engagement. Learners will explore how to create compelling menus, implement inventory systems, and foster teamwork within a restaurant environment. Emphasis is placed on strategic decision-making, operational efficiency, and building a reputable brand image. The course is structured to support learners in developing managerial skills, with a strong focus on leadership, communication, and customer satisfaction. Designed for those seeking a detailed understanding of the restaurant business, this programme empowers learners with the knowledge needed to excel in both operational and supervisory roles. Upon completion, learners will possess the expertise to contribute significantly to any restaurant’s success or embark on entrepreneurial ventures in the food and hospitality industry. Course Modules Module 01: An Overview of the Restaurant Industry Module 02: Choosing Your Restaurant Module 03: Restaurant Layout Management and Legal Requirements Module 04: Menu Planning Module 05: Drinks Management Module 06: Purchasing, Receiving, Inventory, and Storage Module 07: Financing Your Business Module 08: Finding, Recruiting, and Training Employees Module 09: Running a Safe and Clean Restaurant Module 10: Handling Service Using Technology Module 11: Teamwork and Daily Routine of a Restaurant Module 12: Customer Relations and Marketing Policy (See full curriculum) Who is this course for? Individuals seeking to pursue a career in restaurant management. Professionals aiming to enhance their leadership skills within the hospitality industry. Beginners with an interest in understanding restaurant operations. Entrepreneurs planning to open or manage a restaurant business. Hospitality staff looking to transition into management roles. Career Path Restaurant Manager Assistant Restaurant Manager Hospitality Supervisor Food and Beverage Manager Front of House Manager Catering Manager Restaurant Owner or Entrepreneur Operations Manager in Hospitality Businesses

Course Overview The Tax Accounting course provides a comprehensive introduction to the UK tax system, covering key areas such as income tax, corporation tax, VAT, and inheritance tax. Designed to equip learners with up-to-date knowledge of tax regulations and processes, this course offers valuable insights into tax administration, individual and corporate responsibilities, and submission of tax returns. Learners will develop a solid understanding of fundamental and advanced tax principles, payroll, and financial analysis. By the end of the course, participants will be able to navigate the complexities of taxation confidently and apply their knowledge in professional contexts. Whether aiming to launch a career in tax accounting or broaden existing financial expertise, this course supports learners in achieving their professional development goals and gaining skills that are in high demand across multiple sectors in the UK. Course Description This Tax Accounting course delves into the structure and operation of the UK tax system, offering detailed modules on personal and corporate taxation, VAT, capital gains, and national insurance contributions. Learners will explore both basic and advanced income tax calculations, understand payroll systems, and gain familiarity with self-assessment and double-entry accounting methods. The curriculum is structured to promote a clear and methodical understanding of tax reporting, compliance obligations, and financial analysis. With a strong emphasis on technical knowledge and regulatory frameworks, this course supports learners in building the analytical and accounting skills essential for a successful career in finance and taxation. Throughout the course, learners will benefit from clear explanations, real-world examples, and guided study that align with industry standards. By completion, participants will be well-prepared to pursue opportunities in accounting firms, corporate finance departments, and tax advisory roles. Course Modules Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Advanced Income Tax Module 07: Payee, Payroll and Wages Module 08: Capital Gain Tax Module 09: Value Added Tax Module 10: Import and Export Module 11: Corporation Tax Module 12: Inheritance Tax Module 13: Double Entry Accounting Module 14: Management Accounting and Financial Analysis Module 15: Career as a Tax Accountant in the UK (See full curriculum) Who is this course for? Individuals seeking to develop a strong foundation in tax accounting. Professionals aiming to enhance their accounting and financial expertise. Beginners with an interest in taxation, finance, or business management. Entrepreneurs wanting to understand tax obligations for businesses. Students planning a career in accounting, auditing, or tax consultancy. Career Path Tax Accountant Payroll Administrator VAT Specialist Income Tax Advisor Financial Analyst Management Accountant Corporate Tax Consultant Self-Assessment Practitioner Tax Compliance Officer Accounting Technician

Course Overview: The "Technical Analysis Masterclass for Trading & Investing" is a comprehensive course designed to equip learners with the essential skills to make informed trading and investment decisions using technical analysis. Covering a wide range of topics, from candlestick patterns to advanced trading strategies, this course empowers learners to interpret market data and identify trends effectively. By the end of the course, participants will have a solid understanding of how to analyse price movements, recognise key patterns, and apply strategies to improve their decision-making. With an emphasis on real-world applicability, learners will be prepared to confidently navigate the markets and pursue trading and investment opportunities. Course Description: This in-depth course dives into the core concepts and techniques used in technical analysis, ideal for those looking to sharpen their trading and investment skills. Learners will explore topics such as candlestick patterns, chart patterns, and volume analysis to understand market behaviours. Key focus areas also include tape reading strategies and technical trading systems, which are critical for timing market entries and exits. The course provides a structured learning experience, guiding participants through different methods of interpreting market data and applying analytical strategies to both short- and long-term trading. By mastering these techniques, learners will develop the skills to assess market conditions, identify profitable trends, and execute informed investment decisions with confidence. Course Modules: Module 01: Introduction to Technical Analysis Overview of technical analysis and its importance in trading and investing Key concepts and tools used in technical analysis Market data types and interpretation Module 02: Candlestick Patterns and Analysis Introduction to candlestick charting Key candlestick patterns and their significance Identifying trends and reversals Module 03: Trade and Investment Chart Patterns Common chart patterns: head and shoulders, triangles, and more How to interpret chart patterns for trade signals Setting up price targets using chart patterns Module 04: Volume Analysis Understanding volume and its role in market analysis Volume indicators and their applications Volume-based trading strategies Module 05: Tape Reading Strategies Introduction to tape reading and its historical significance Techniques for interpreting market order flow Understanding supply and demand through tape reading Module 06: Technical Trading Strategies Popular technical analysis strategies for trading Risk management and strategy development Implementing strategies for both short and long positions Module 07: Trading Platform and Practice Overview of different trading platforms and their features Using charting tools and indicators in platforms Best practices for executing trades and managing portfolios (See full curriculum) Who is this course for? Individuals seeking to enhance their trading and investment knowledge. Professionals aiming to refine their analytical skills for better decision-making. Beginners with an interest in financial markets and technical analysis. Investors wanting to better understand charting techniques and market trends. Career Path: Stock Trader Investment Analyst Financial Consultant Portfolio Manager Market Research Analyst Risk Manager

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers