59507 Courses

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Study abroad is about stepping out of your comfort zone, embracing a new culture and way of life, and coming home with unforgettable memories

Course Information Embark on our GLP course offering extensive guidance and pragmatic support tailored for individuals serving as Study Directors or Principal Investigators overseeing non-clinical safety studies on pharmaceuticals, agricultural, and industrial chemicals within the realm of Good Laboratory Practice (GLP). This comprehensive programme extends its benefits to study staff and management operating in GLP-compliant environments. The course extensively covers the current OECD GLP Principles and UK GLP legislation, while also referencing international standards, regulations, and guidelines pertinent to the field. Benefits of this course: Practical help and guidance on the interpretation and application of GLP An opportunity to update your knowledge of GLP with the current interpretation of requirements Access to an experienced panel of speakers Information on how other organisations address GLP issues An opportunity to improve your understanding of the GLP requirements as they are applied in different situations. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Examine particular aspects of GLP Learn from the experience of others. Tutors Tutors will be comprised of (click the photos for biographies): Tim Stiles Consultant, Qualogy Ltd Tony Woodall Head of Quality Assurance, Alderley Analytical Gill Armour Study Monitor Team Leader, AstraZeneca Jane Elliston Senior Quality Assurance Auditor, Battelle UK Vanessa Grant -, - Jeanet Logsted CEO, Scantox Programme Please note timings may be subject to alteration. Day 1 09:00 Registration 09:15 Welcome and Introductions 09:35 Development of Good Laboratory Practice A review of the history of GLP, its current scope and application, with a synopsis of current European and international standards. 10:05 Roles and Responsibilities The responsibilities of study director, test facility, management and study staff in the conduct of a GLP study. 10:45 Break 11:00 The Roles and Responsibilities of the Study Director and Test Facility Management The role of the study director in the management and control of a study, as defined by GLP, and management's roles are explored. 11:45 Multi-site Studies What is a multi-site study and when should such concepts be applied on a study. The role of the study director and principal investigator in the planning, conduct and reporting of multi-site study are explored. 12:30 Study Plan (Protocols) GLP requirements for the preparation of a study plan, content, authorisation, amendments and deviations are discussed. 13:00 Lunch 13:45 Workshop 1 - The Study Plan Some practical problems with study plans and amendments explored. 14:45 Workshop 1 - Feedback 15:00 Standard Operating Procedures The control, content and authorisation of SOPs and the principles behind the practice. 15:30 Break 15:45 Workshop 2 - Practical Study Conduct Problems Dealing with practical problems encountered during the conduct of studies. 16:40 Workshop 2 - Feedback 17:15 Close of Day Day 2 09:00 Questions and Answers Discussion of issues raised by course delegates. 09:20 Quality Assurance The interactions between QA, management, study director and principal Investigator are discussed as is QAs role when conducting a multi-site study. 10:00 The Final Report The content of the final report and the role of those involved in its preparation and approval. Specific reporting requirements when conducting a multi-site study are also explained. 10:30 Break 10:45 Workshop 3 - Final Report Problems Practical problems of report preparation including compliance statements. 11:30 Workshop 3 - Feedback 12:00 Management of Raw Data and Records A view on how records and materials are managed and archived in compliance with GLP. 12:45 Lunch 13:30 Workshop 4 - Data and Sample Management Issues Dealing with data and sample management issues. 14:15 Workshop 4 - Feedback 14:45 Regulatory Inspection Government monitoring for compliance with Good Laboratory Practice. 15:15 Panel Session This panel session will address any outstanding issues raised by delegates. 15:45 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 14 Points Development Level Develop

Course Information Our extensively proven course delves into the essential stages of process and system auditing. Gain invaluable insights and direction in auditing systems and processes, spanning across global and local organisational levels. This course will assist delegates with: A practical approach for the development and conduct of process and system audits An enhanced understanding of key system audit principles, preparation, design and conduct Increased expertise, efficiency and confidence. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Share knowledge and experiences. By the end of the course delegates will be better able to: Design and plan more effectively to achieve their process and systems audit objectives and add value to their organisation Improve the effectiveness, focus and credibility of the audit programme Understand the key system audit principles, preparation, design and conduct Develop system audit tools to ensure more effective audit conduct and outcome Create audit strategies utilising risk management principles Prepare for inspections. Tutors Tutors will be comprised of (click the photos for biographies): Allison Jack Executive Director, Bristol Myers Squibb Rocio Castellanos Director, Pfizer Ltd Guy Houben G(C)LP Auditor, Janssen Pharmaceutical Companies of Johnson & Johnson Programme Please note timings may be subject to alteration. Day 1 08:50 Registration 09:00 Welcome and Introductions, Expectations/Challenges/Experiences A discussion to explore the range of approaches to the conduct of systems audit. 09:30 Introducing Systems Audit What is a system? Why conduct system audits? Advantages, disadvantages and challenges. 10:20 Break 10:35 Systems Audit Design and Planning Identifying the customer, setting objectives, development of the audit plan and audit tools, plans for the audit report. 12:00 Designing System Audit Tools 12:45 Lunch 13:30 System Audit Plan - Exercise 14:00 Introduction to Case Studies The objectives of the case studies are defined and process and outputs described. 14:15 Case Studies - Session 1 A first opportunity for work on case studies. Defining objectives and scope and understanding the requirements of the audit client. 15:00 Break 15:20 Case Studies - Session 1 continued 16:30 Case Studies - Feedback 17:00 Close of Day 1 Day 2 09:00 Simple System Audit Example - Introduction The objectives of the case studies are defined and process and outputs described. 09:10 Case Studies - Session 2 - A Simple System Audit Example An example of system audit applied to a simple system. 10:30 Break 10:45 A Simple System Audit Example - Case Study Feedback 11:30 Strategy Audit programme planning. 12:15 Lunch 13:00 Case Studies - Session 3 Work on delegate's case studies. 14:30 Break 14:45 Case Studies - Session 3 - Feedback 15:15 Closing remarks 15:30 Close of course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 14 Points Development Level Develop

Designed as a follow-on to The Practical Manager, this course will take your managers to the next level. Give them the skills to develop high performing teams through the application of tailored motivation strategies, effective performance appraisal and razor-sharp decision-making.

Group Course (Max 6 Delegates)

This qualification is aimed at those working in an environment where an AED is available.

Achieving certification for Compliance Management Systems (ISO 37301:2021) through an external audit process to help you identify, prevent and address compliance risks within your organisation provides a range of benefits. What if you could gain the expertise to conduct internal audits in-house, to not only successfully complete ISO certification, but allow you to continue to monitor your adherence to that certification standard? 'Prove your competency to the wider compliance industry.' Created by UKAS accredited ISO certification experts, this wholly unique, internationally focussed, 2-day online internal auditor training course is a fantastic way to develop your in-house expertise and allow your team to attain the competence they need to maintain and continually improve your management system. A cost-effective route, negating the need to hire external consultants Avoid closing a business for what might be a lengthy audit Prove your ' culture of compliance', and in turn, strengthen your 2nd and 3rd lines of defence Add additional skills to your CV, demonstrating your commitment to best practice while gaining a competitive advantage for your organisation. 'Don't just tick the boxes, demonstrate a culture of compliance.' Ensure you are fully compliant with relevant legislation and regulation and give confidence to the regulators, your partners, and clients that you have processes in place to comply with the law. Developing knowledge of compliance management system standards/normative documents Developing knowledge of ICA Audit (certification body's) processes Developing knowledge of relevant business sectors Developing knowledge of business management practices and how they integrate into business activities Developing knowledge of audit principles, practices, and techniques Developing knowledge of client products, processes, and organization Developing language skills appropriate to all levels within the client organization Developing notetaking and report-writing skills Developing presentation skills Developing interviewing skills

Peering at LINX training course description A one or two day induction course covering the technical procedures of LINX along with correct interaction with LINX and LINX members. This course focuses on the implementation of the technologies within the LINX network. For those already competent in BGP the one day version of this course is sufficient. What will you learn Explain the role of LINX in the Internet. Correctly connect to LINX. Recognise the correct procedures for peering at LINX. Use the current Best Current Practices. Peering at LINX training course details Who will benefit: Technical staff of new LINX members. Technical staff of companies preparing to join LINX. Non technical staff may also benefit from this course. Prerequisites: None. (For technical staff with BGP knowledge 1 day) Duration 1 to 2 days Peering at LINX training course contents Introduction and review Networks, The Internet, IP, routers, Autonomous systems, the structure of the Internet, the role of Internet Exchanges. BGP and peering. LINX, EuroIX, RIPE. What you get when you join LINX. LINX products: Connexions, Virtual PoPs, Colocation resales, LINX from anywhere. LINX infrastructure The original architecture, The growth of LINX, the current topology. LINX London locations. Dual LAN topology. LON1, LON2. Use of MPLS to connect London sites. Regional peering: LINX NoVa, LINX Manchester, LINX Wales, LINX Scotland, ManxIX, JEDIX. Connecting with LINX nnecting with LINX Locations. 1/10/100/400G. Interface specifications. Link aggregation. The racks and space provided, access to the racks, connecting WAN circuits into LINX. The connection form, How to link your ISP with LINX, switch assignments, limits on traffic, average measured traffic, getting statistics from LINX, Using looking glass. Allowed traffic. Port security Configuration hints LINX IP details, IPv4, IPv6, PTR records, Cisco base configuration, Juniper base configuration. Peering with other LINX members Preparing for peering, the peering template, setting up the peering, RFC 2142, the RIPE database, contacts, peeringdb.net, solving downed BGP sessions, escalation procedures. Peering configuration hints Cisco BGP configuration, Juniper BGP configuration. LINX additional services Private interconnect, LINX time service. NTP, Strata. The LINX route server Bi lateral peering, Multi lateral peering. How the LINX route server is configured. Use of communities on the route server, template for peering with the route server. Summary Getting further information, the LINX website, the LINX mailing lists.