1686 Environment courses in Cardiff delivered Live Online

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate -level programming course, designed for experienced Java developers who wish to get up and running on developing well defended software applications. Familiarity with Java and JEE is required and real world programming experience is highly recommended. Ideally students should have approximately 6 months to a year of Java and JEE working knowledge. Overview Students who attend Attacking and Securing Java Web Applications will leave the course armed with the skills required to recognize actual and potential software vulnerabilities and implement defenses for those vulnerabilities. This course begins by developing the skills required to fingerprint a web application and then scan it for vulnerabilities and bugs. Practical labs using current tools and techniques provide students with the experience needed to begin testing their own applications. Students also gain a deeper understanding of how attackers probe applications to understand the runtime environment as well as find potential weaknesses. This course the introduces developers to the most common security vulnerabilities faced by web applications today. Each vulnerability is examined from a Java/JEE perspective through a process of describing the threat and attack mechanisms, recognizing associated vulnerabilities, and, finally, designing, implementing, and testing effective defenses. Practical labs reinforce these concepts with real vulnerabilities and attacks. Students are then challenged to design and implement the layered defenses they will need in defending their own applications. There is an emphasis on the underlying vulnerability patterns since the technologies, use cases, and methods of attack as constantly changing. The patterns remain the same through all the change and flux. This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in secure web application development, coding and design, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. This lab-intensive course provides hands-on Java / JEE security training that offers a unique look at Java application security. Beginning with penetration testing and hunting for bugs in Java web applications, you embrace best practices for defensively coding web applications, covering all the OWASP Top Ten as well as several additional prominent vulnerabilities. You will repeatedly attack and then defend various assets associated with fully functional web applications and services, allowing you to experience the mechanics of how to secure JEE web applications in the most practical of terms. Bug Hunting Foundation Why Hunt Bugs? Safe and Appropriate Bug Hunting/Hacking Scanning Web Applications Scanning Applications Overview Moving Forward from Hunting Bugs Removing Bugs Foundation for Securing Applications Principles of Information Security Bug Stomping 101 Unvalidated Data Broken Authentication Sensitive Data Exposure XML External Entities (XXE) Broken Access Control Bug Stomping 102 Security Misconfiguration Cross Site Scripting (XSS) Deserialization/Vulnerable Components Insufficient Logging and Monitoring Spoofing, CSRF, and Redirects Moving Forward with Application Security Applications: What Next? Making Application Security Real

Fraud should not happen, but it does. It can happen at the highest to lowest levels in an organisation. Recent surveys show that incidents of fraud are not decreasing. Fraud costs companies money and, perhaps even more importantly, reputational damage. The losers are not just the shareholders, suppliers, customers, etc, but society as a whole. This programme shows why frauds happen, how organisations put themselves at risk and what they can do to prevent it. This programme will help directors and others understand: The motives for committing fraud Directors' responsibilities for identifying and reporting fraud What types of frauds there are How frauds are perpetrated How they can be prevented How regulators deal with fraud Above all, the principal objective of this programme is to help make your organisation as secure as possible from the threat of fraud. 1 Motives for committing fraud - drivers of fraud Session objective: to understand why people might commit fraud Drivers of fraudulent behaviourAmbitionGreedTheftConceit? And more! 2 Accounting mechanisms that allow fraud Session objective: to review the elements of the accounting, internal control and management processes that allow creative accounting Income or liability? Asset or expense? Coding errors and misclassification Netting off and grossing up Off-balance sheet items 3 Structures that allow fraud Session objective: to consider company and trading structures that allow frauds to be perpetrated Group structures Trading structures Tax havens Importing and exporting 4 Interpretations and other non-compliance that allow fraud Session objective: to look at how creative interpretations of law and accounting practice may permit fraud The place of accounting standards Accounting policies Trading methods The place of auditing standards 5 Money laundering Session objective: to review what constitutes money laundering Types of money laundering Identifying laundering Preventing laundering 6 Preventing fraud - proper management structures Session objective: to review the place of proper corporate governance Corporate governance Company management structure Audit committees The place of internal audit 7 Preventing fraud - proper accounting Session objective: to review best accounting and auditing practice Accounting standards Internal accounting policies Adequacy of internal controls Internal audit 8 Preventing fraud - regulation Session objective: to look at how regulators aim to prevent fraud The regulatory environment Financial services regulation 9 Conclusion Course review Open forum Close 10 Course summary - developing your own cost action plan Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs

Duration 5 Days 30 CPD hours This course is intended for This course is primarily for Developers, Developer Consultants, Help Desk/COE Support, and Program/Project Managers. Overview Learn the fundamental concepts of the ABAP programming languageEfficiently use the ABAP Workbench toolsCreate simple application programs with user dialogs (list, selection screen, screens, Web Dynpro) and database dialogs (reading from the database) In this course, students gain knowledge of the fundamental concepts of ABAP and learn how to comfortably and efficiently work with the ABAP Workbench tools in order to undertake custom developments with confidence. Flow of an ABAP Program Describing the Processing of ABAP Programs ABAP Workbench Introduction Introducing the ABAP Development Environment Organizing ABAP Developments Developing Programs Finalizing Development Basic ABAP Language Elements Defining Elementary Data Objects Using Basic ABAP Statements Working with the ABAP Debugger Modularization Introducing Modularization Modularizing Using Subroutines Modularizing Using Function Modules Implementing Function Modules Modularizing Using BAPIs Modularizing Using Global Classes Implementing Simple Global Classes and Static Methods Modularizing Using Local Classes Complex Data Objects Working with Structures Working with Internal Tables Data Modeling and Data Retrieval Modeling Data Reading Single Database Records Reading Multiple Database Records Handling Other Aspects of Database Access Working with Authorization Checks Classic ABAP Report Implementing ABAP Lists Implementing Selection Screens Implementing Events of ABAP Reports Screen Creating Screens Creating Input/Output Fields Implementing Data Transport SAP List Viewer Using the SAP List Viewer Web Dynpro ABAP Describing Web Dynpro ABAP Implementing Navigation in Web Dynpro Implementing Data Transport in Web Dynpro Program Analysis Tools Using the Code Inspector ABAP Development Tools for SAP NetWeaver Describing ABAP Development Tools for SAP NetWeaver Creating an ABAP Project in Eclipse SAP Standard Software Adjustments Adjusting the SAP Standard Software Additional course details: Nexus Humans BC400 SAP ABAP Workbench Foundations 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 BC400 SAP ABAP Workbench Foundations 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.

Conflict is a word that conjures up many emotions. It is something that most people would prefer to avoid, if possible. Work can be an emotive place. Positive relationships can make your life at work exciting, motivating and challenging, whilst relationships that do not hold value to you could make your life very difficult and stressful, especially if there is conflict between you and your manager. This course is essential for people who want to understand where conflict can be used to positive effect and how to manage conflict in your working relationships and see it as something positive that can stimulate the environment. Research has shown that relationships at work are an extremely high motivational factor, and for a lot of people it has a higher importance that salary! Therefore, it is essential that we invest in relationships and search out new ways to make them better in order to have a more positive influence on our surroundings. By understanding why other people are in conflict we can manage the conversation a lot better, with outcomes managed more effectively so the 'conflict' will add value to the organisation. This participative event will cover a wide variety of exercises and personal stories, and leave course participants with a clear strategy to identify when they are in conflict with someone and how they will structure their approach to get to a satisfactory outcome. This is a workshop that targets anyone where conflict needs to be managed and cannot seem to resolve it, whether internally or externally. At the end of the day, participants will: Know their key relationships and the strength of those relationships Complete the Strengths Deployment Inventory (SDI) to identify where you deploy your strengths Understand what is important to you and your key stakeholders Know how motivational value systems can influence behaviour Tailor your communication style to match that of your opposite party Know conflict strategies to resolve conflict in others Learn to be more assertive when challenging Achieve key personal, departmental and organisational objectives 1 Where are you now? How effective are your current working relationships? Can I work effectively without the input from others? Who do you need to be a success? 2 The Strengths Deployment Inventory (SDI) Completion of the SDI questionnaire An understanding of the theory A 'trip around the triangle' Predicting relationship interaction Your scores and what they mean in your relationships 3 Conflict theory What is conflict? The 3 flags of conflict What are your conflict triggers? Your conflict scores plotted The conflict sequence 4 Conflict resolution strategies Early warning signs Most productive behaviours Least productive behaviours Preventable / unwarranted conflict Review of the dynamic triangle Review of the day, personal learning and action planning

This workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations. The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace. This course will give participants an understanding of: The broader context of the key areas of health and safety regulation which apply to your organisation Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy What they should do and the procedures to support it Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety How sound health and safety processes can contribute to business performance 1 Understanding the workplace legislation Overview of health and safety and workplace legislation Compliance, the role of the facilities manager, and who is accountable? Breakout session to discuss where we are now and to highlight issues of concern Applying required policies and procedures Developing and implementation/review of the safety policy Communicating with users, clients and contractors Health and safety manual 'Selling' health and safety 2 Key legislation - a practical working guide Asbestos Regulations Construction (Design and Management) Regulations 2007 / 2015 Control of Substances Hazardous to Health (COSHH) Regulations Disability Discrimination Act (DDA) Display Screen Equipment (DSE) Regulations 1992 Electricity at Work Regulations 1989 Fire Precautions (Workplace ) Regulations 2006 Health and Safety (Consultation with Employees) Regulations 1996 Health and Safety (First Aid) Regulations 1981 Health and Safety at Work etc. Act 1974 Management of Health and Safety at Work Regulations 1992 Manual Handling Operations Regulations 1992 Portable Appliance Testing (PAT) Provision and Use of Work Equipment Regulations 1992 REACH - Registration, Evaluation, Authorisation and restriction of Chemicals Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995 Waste Electrical and Electronic Equipment (WEEE) Regulations 2006 Work Equipment Regulations 3 Controlling contractors Understanding the Regulations Selecting and assessing contractors Understanding and setting accountability Why a method statement? How to apply a permit to work system Safe systems of work Round-table discussion to bring out issues from participants' own experience 4 Risk assessment Understanding your hazards Identifying specialist areas How to undertake these assessments Implementation of sound systems and processes Syndicate exercise identifying where assessments are needed and carrying out assessments 5 Keeping the work environment safe Sick building syndrome and legionella Asbestos Waste management Pest control Provisions for first aid Accident reporting and investigation At-work driver safety Security 6 Fire safety Understanding the Regulatory Reform Fire Safety Order Fire certificates The fire risk assessment Testing fire-fighting equipment? Emergency procedures Workshop to examine the procedures for dealing with different types of emergencies 7 Ergonomics programme Ergonomics - important or irrelevant? Are you complying with HSE regulations? Furniture and equipment Display screen equipment assessments Homeworking - your concern or not? Syndicate exercise to review what to do when relocating or refurbishing an office 8 Inspecting and auditing Role of Health and Safety Executive Inspectors - 'be prepared' FM role Staff/trade union involvement Independent audits Records and reports Communicating the results 9 Action plan Participants to list actions they need to take after the course

Having a dog is a joyful experience but an untrained dog will put stress and anxiety on the whole family. At Cheshire Dog Services, we want to help you enjoy your dog so are happy to provide one to one training sessions for you and your dog. Having trained many different breeds from Chihuahua’s & Yorkies – Lab’s & Spaniels to Rottweiler’s & German Shepherds, I am well versed in handling most problems in any breed. I am also a member of The Guild of Dog Trainers who acknowledge the needs of dog owners & their aim of a well behaved dog. The Guild fully understands the expectation society places on dog owners & additionally the laws which affect them all. We live in an artificial environment, which can often pose many dangers to dogs. We invite pets into our home then punish or blame them for acting up like animals do. It’s our responsibility to teach our dogs what the social boundaries are and how to live in a human environment. Even though they become trusted family members, we need to remember that fundamentally they are animals and as beautiful and loving as they are, training is key to avoid behavioral problems that will inevitably crop up. Have you ever noticed when a trainer handles a students’ dog in class – the dog performs amazingly well? The dog then goes back to his owner and forgets all that was taught. This is all down to how you handle your dog. How you are able to read the smallest changes in their body language and posture and make the confident and correct adjustments according to what is required. As a dog trainer with many years worth of experience, my aim is to pass on my skills and as much knowledge as is possible to all of my valued clients. When you and I work together, your dog will learn FASTER! You will enjoy a better-behaved dog in a shorter period of time whilst still being actively involved in the process of teaching your dog. As your dog learns the necessary concepts with me, you will experience the benefit of reducing your own frustration within your own training sessions at home. I help both you and your dog come together towards a common goal of a happy life together. Puppy 1-2-1’s Pups are never too young to learn, their Mums teach them many things in the first 7/8 weeks before we take them into our lives. We need to continue to educate the pup so they know the boundaries we expect in order for them to fit into our human ways and for you to fully enjoy these wonderful creatures. Much can be done BEFORE they have had all their inoculations and are ready to walk outside. The key to effective training is teaching your pup that whenever he does something wrong, you immediately redirect him to what you expect and then reward for getting it right. Most of all, puppy training needs to be upbeat, consistent and rewarding with regular sessions practiced and integrated into your daily routine. What I’ll cover with you at your home are: Shaping behaviour Crating Basic obedience controls of Sit, down, stand, focus & wait. Recall set up, the most important command for all dogs without a doubt! The best type of equipment use to help with training, whistles for recall, training lines, reward pouches etc. Interactive play used to build bonds and value in you as the owner/handler through ball tugs, tugs and ropes. How to teach the pup to “leave it” Advice on leads, harnesses, treats, socialising, lead control Answer any questions you may have resulting to your puppy Adolescent and mature dogs 1-2-1’s Adolescence in dogs is reached by month 7-8 & the dog becomes fully mature by month 18. We’ll cover the following in our sessions or can focus on a specific need if requiredat’s r Obedience Heel-work so your dog walks nicely by your side and doesn’t pull. Wait / Stay commands for both obedience and safety Interactive play and bond building to aid recall Recall development is essential for all dogs big and small. “Leave it” command so the dog ignores what its told to leave Focus will allow a higher level of obedience. I believe positive reinforcement training is the best way to create a happy and confident dog who understands what is expected of them. I teach owners how to establish boundaries at home and employ problem behaviour prevention strategies from early puppyhood onwards. Training and behaviour problems are resolved without the punishment-based techniques that commonly result in fear, aggression, or deterioration of the bond between dog and owner. Instead I utilise positive methods based on well-established learning theories and behavioural science that are humane, practical and effective. I teach marker-based training, either with a clicker or word, combined with rewards of all kinds (e.g., food, toys, play, and praise). All my training sessions reflect a comprehensive understanding of the dog’s natural behaviour, and take into respect learning abilities as well as the dog’s mental and physical developmental stages. In my classes, I strive to create a relaxed and enjoyable learning experience as I believe that the human part of the equation needs as much support and understanding as the canine component. Most people learn more quickly when not subjected to criticisms and negative feedback and therefore, a positive approach to the training of the people is an integral part of all our classes. Please contact us for prices (they vary depending on what’s required)

Duration 2 Days 12 CPD hours This course is intended for This course is for network managers, resellers, systems administrators, client security administrators, systems professionals, and consultants who are charged with the configuration and day-to-day management of Symantec Endpoint Protection in a variety of network environments. Overview By the completion of this course, you will be able to: Manage Virus and Spyware Protection policies. Manage SONAR scans. Manage Firewall and Intrusion Prevention policies. Manage Application and Device Control policies. Manage System Lockdown. Manage Host Integrity. Manage Virtualized clients. This course is designed for the network, IT security, and systems administration professional tasked with implementing and monitoring virus and spyware protection, zero-day protection, and network threat protection solutions. Introduction Course overview The classroom lab environment Introducing Antivirus, Insight, and SONAR Virus and spyware protection needs and solutions Reputation and Insight Administrator-defined scans Auto-Protect Download Insight SONAR Included Virus and Spyware Protection policies Managing Virus and Spyware Protection Policies for Windows Configuring administrator-defined scans Configuring protection technology settings and scans Configuring e-mail scans Configuring advanced options Managing scanned clients Managing Virus and Spyware Protection Policies for Mac and Linux Configuring Virus and Spyware settings for Mac Configuring Virus and Spyware settings for Linux Configuring advanced options Managing Exception Policies Exceptions and exclusions Configuring the Exceptions policy Introducing Network Threat Protection The OSI model and network threats Network threat tools and attack methods Attack and mitigation Managing Firewall Policies Firewall policy overview Defining rule components Modifying firewall rules Configuring built-in rules Configuring protection and stealth settings Configuring Windows integration settings Managing Intrusion Prevention Policies Configuring network and browser intrusion prevention Managing custom signatures Compliance Management Application and Device Control System Lockdown Host Integrity Virtualization Introducing virtualization features Virtual image exception Network and vShield Shared Insight Cache Virtual client tagging Offline image scanner Windows Azure support Additional course details: Nexus Humans Symantec Endpoint Protection 12.X - Manage And Administer 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 Symantec Endpoint Protection 12.X - Manage And Administer 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 Experienced DataStage developers seeking training in more advanced DataStage job techniques and who seek an understanding of the parallel framework architecture. In this course, students will develop a deeper understanding of the DataStage architecture, including a deeper understanding of the DataStage development and runtime environments. Introduction to the Parallel Framework Architecture Describe the parallel processing architecture Describe pipeline and partition parallelism Describe the role of the configuration file Design a job that creates robust test data Compiling & Executing Jobs Describe the main parts of the configuration file Describe the compile process and the OSH that the compilation process generates Describe the role and the main parts of the Score Describe the job execution process Partitioning & Collecting Data Understand how partitioning works in the Framework Viewing partitioners in the Score Selecting partitioning algorithms Generate sequences of numbers (surrogate keys) in a partitioned, parallel environment Sorting Data Sort data in the parallel framework Find inserted sorts in the Score Reduce the number of inserted sorts Optimize Fork-Join jobs Use Sort stages to determine the last row in a group Describe sort key and partitioner key logic in the parallel framework Buffering in Parallel Jobs Describe how buffering works in parallel jobs Tune buffers in parallel jobs Avoid buffer contentions Parallel Framework Data Types Describe virtual data sets Describe schemas Describe data type mappings and conversions Describe how external data is processed Handle nulls Work with complex data Reusable Components Create a schema file Read a sequential file using a schema Describe Runtime Column Propagation (RCP) Enable and disable RCP Create and use shared containers Balanced Optimization Enable Balanced Optimization functionality in Designer Describe the Balanced Optimization workflow List the different Balanced Optimization options. Push stage processing to a data source Push stage processing to a data target Optimize a job accessing Hadoop HDFS file system Understand the limitations of Balanced Optimizations Additional course details: Nexus Humans KM404 IBM InfoSphere Advanced DataStage - Parallel Framework (v11.5) 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 KM404 IBM InfoSphere Advanced DataStage - Parallel Framework (v11.5) 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.

Increasing sales is the core of objective for all salespeople and it is vital they are given the tools and techniques to thrive in this highly competitive environment. The landscape within which salespeople operate is ever shifting, and now more than ever it is recognised that the key to successful selling is understanding the customer's needs and working collaboratively with them to achieve their objectives. This highly practical programme has been developed to support salespeople to develop their all-round sales skills using a customer-focused approach. The course will be fun and informal, using practical exercises to help new and experienced salespeople ensure they are equipped to deal with the challenges of selling. This course will help participants: Develop core sales skills such as building rapport, questioning and presenting benefits Identify the roles and goals of key contacts and recognize the importance of consultative selling Understand how to achieve sales by uncovering needs, matching benefits and promoting value Understand how to structure and control a customer interaction and set clear objectives for each account Develop techniques for handling objections, questions and staying positive Master the art of closing a sale and gaining agreement Understand tactical selling and how to build multiple contacts and relationships Develop skill and confidence in selling to both new prospects and existing customers 1 Consultative selling - key principles for success Recognise the importance of consultative selling and being client-focused Build the right processes to achieving sales targets - questions before features Assess your core sales skills; building rapport, asking questions, presenting features and benefits, closing 2 Consultative sales call skills How best to structure and control a customer meeting or call to be client-centric: Four Cs The importance of setting clear objectives for each call and account Setting the agenda and pre-call preparation Planning sessions 3 Your mission, message and meaning - comparative advantage Defining sales messages and USPs; positioning value and quality not price Knowing your target product and services and their value to the customer Understanding your customers buying role and qualifying the opportunity 4 An effective sales meeting - part 1 Opening the sales interview - and building rapport Gaining and retaining the full attention of the customer Probing and identifying real needs using effective sales questions Planning and practice sessions for consultative selling 5 An effective sales meeting - part 2 Matching customer needs and wants to products and services available Presenting your product or service using features, advantages, and benefits Recognising and responding to buying signals and other sales opportunities Planning and practice sessions 6 Closing the sale successfully Anticipating objections and seeing them as positives, including price objections Handling objections using proven methods and models How and when to ask for the sale professionally Follow up and follow-through Planning and practice sessions

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students looking to establish a foundational understanding of Microsoft Access for Office 365, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Overview In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports. In this introductory course, you will discover the capabilities of Microsoft© Access©, a relational database application that can help you and your organization manage your complex data. Working with an Access Database Topic A: Launch Access and Open a Database Topic B: Use Tables to Store Data Topic C: Use Queries to Combine, Find, Filter, and Sort Data Topic D: Use Forms to View, Add, and Update Data Topic E: Use Reports to Present Data Topic F: Get Help and Configure Options in Microsoft Access Creating Tables Topic A: Plan an Access Database Topic B: Start a New Access Database Topic C: Create a New Table Topic D: Establish Table Relationships Creating Queries Topic A: Create Basic Queries Topic B: Add Calculated Columns in a Query Topic C: Sort and Filter Data in a Query Creating Forms Topic A: Start a New Form Topic B: Enhance a Form Creating Reports Topic A: Start a New Report Topic B: Enhance Report Layout Promoting Quality Data Input Topic A: Restrict Data Input through Field Validation Topic B: Restrict Data Input through Forms and Record Validation Improving Efficiency and Data Integrity Topic A: Data Normalization Topic B: Associate Unrelated Tables Topic C: Enforce Referential Integrity Additional course details: Nexus Humans Microsoft Access for Office 365 (Desktop or Online) - Part 1 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 Microsoft Access for Office 365 (Desktop or Online) - Part 1 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.