63303 Courses

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 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

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

The industry standard course in UX research Master the research skills that make UX professionals so valuable. Become a confident, credible and effective user researcher with a globally recognised qualification. Who is it for? UX professionals Aspiring UX researchers Duration 16 weeks Commitment 3 hours per week Format Online, self-paced with live support and mentoring Why take this user research course: Gain the most in-demand skills* and boost your career in a thriving industry. Learn a complete range of UX research methods. Expand your toolkit to conduct high-quality research at pace. Become an insights expert. Translate findings into actionable insights and communicate them with conviction. Showcase your expertise. Build a professional user research portfolio and earn a university credit-rated qualification. Get the confidence to succeed. Count on our mentors, career advisors and student community throughout your journey. *Research is one of the top 10 most in-demand skills globally (LinkedIn, 2023). A comprehensive, in-depth curriculum This user research course has been created and validated by experts in UX research. It is credit-rated by Glasgow Caledonian University. Self-paced learning gives you the flexibility to study in your own time. Monthly deadlines and submissions give you structure and accountability. The best of both worlds. Module 1 Introduction to user research Understand the role of a UX researcher. Explore the types, methods and ethics of research. Module 2 Planning the research Learn how to build a research plan, collaborate with stakeholders, recruit participants and manage data. Module 3 Fundamental user research skills Master the core skills of interviewing and usability testing. Learn how to moderate and take notes. Module 4 Expanding your toolkit Explore qualitative research methods like ethnography, contextual enquiry, service safaris and diary studies. Module 5 Analysing qualitative research Learn to analyse research data and translate it into user goals, affinity diagrams, personas and journey maps. Module 6 Quantitative research Learn to design, conduct and analyse online surveys, A/B tests and more. Module 7 Communicating the research Learn how to report and present your findings with confidence. Module 8 AI for user research Explore how AI tools can assist researchers. Project Portfolio project Build a professional portfolio to showcase your research expertise.

Build a rewarding career in content design Build a rewarding career in content design with a globally recognised, industry-approved qualification. Get the mindset, the confidence and the skills that will help you stand out in a rapidly growing industry. Why take this course: Be in demand. Certified qualifications will help you stand out in a fast-growing industry Build a career with impact. Design content experiences that will influence users worldwide Broaden your opportunities. Optimise your skills to get hired at leading companies Get qualified. Earn a university credit-rated certification approved by industry leaders Gain the confidence you need to succeed. Our mentors, career advisors and student community will support you all the way University credit-rated, industry-approved Our content design course is credit-rated by Glasgow Caledonian University and has been reviewed and endorsed by leaders in the tech industry. It covers everything you need to become a certified content design professional. Study method Online, self-paced Duration 10 weeks Access to content 12 months Qualification Professional Certificate in Content Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description In this Professional Certificate in Content Design course you will learn: An introduction to content design. Understand what content design is and the role of a content designer. Principles of good content design Learn the core principles of content design and why it matters. Voice, tone and style Learn how voice, tone, and style can create a cohesive product experience. Understanding your users Uncover your audience's goals and content needs. Writing for interfaces Learn to write microcopy for buttons, notifications and other UI elements. The product mindset Develop a product mindset by learning about product design systems and tools. Testing content Learn how to test, evaluate and improve your content. AI for content design Learn how to use AI tools to become a more effective content designer. Working in content design Learn how to be the content champion within your organisation. Support at every step From day one, you’ll be part of a lively community of tutors, mentors and fellow students that support each other along the way. Student Success team Our friendly and responsive team will help you stay on track and keep you accountable. Course mentor Your course mentor is an expert content designer who brings years of practical insight. Student community Collaborate, share tips and build connections on our lively student Slack channels. Who is this course for? Writers and journalists who want to enhance their skills for the digital world UX and UI designers who want to become more rounded professionals Content designers looking for a formal qualification that validates their expertise Digital marketers who need content design skills to succeed in their roles Anybody with a writing, content or design background looking for a creative tech job Requirements Background You don’t need experience in design or technology to enrol in our courses. To get the most value from this course, you will need some experience in writing and a genuine interest in words and language. Commitment You do need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. English language To take this course, you should be fluent in verbal and written English. If English is not your first language, you should have a proficiency of C1 as defined by the CEFRL (Common European Framework of Reference for Languages).

Become a certified UI designer Learn how to create beautiful, pixel-perfect user interfaces Accelerate your career with an in-demand skillset Get a professional qualification in just 12 weeks Manage your own schedule with our flexible, self-paced online course Expand your career options UI skills are needed worldwide, and demand is growing. With a globally recognised qualification, you’ll become a more valuable, sought-after professional. Design with confidence You’ll understand the ‘why’ of good UI design by knowing the principles behind it. You’ll be able to defend your decisions and design with confidence. Work in a creative, rewarding job UI designers add personality and visual appeal to user interfaces. It’s an enjoyable career that rewards creativity: the perfect entry into tech for visually-minded people. A flexible, university-backed curriculum Our curriculum is university credit-rated and approved by the industry. Over 12 weeks, you’ll learn the principles and skills you need to become a confident UI designer. Study method Online, self-paced Duration 12 weeks Access to content 12 months Qualification Professional Certificate in UI Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description During this 12 week, online course you will learn: Introduction to UI Design Brand and Personality Layout Design Principles Interactivity Typography Colour, shapes and effects Iconography and imagery Design process Presenting ideas UI design tools You will also work on a project and your portfolio with access to weekly mentor sessions, an active student community, and support from our student success team. Who is this course for? Graphic designers and digital designers who want to upskill to UI design UI designers who want to strengthen their knowledge and craft UX professionals who want to become more rounded product designers Anybody with a design background looking for a creative job in tech Requirements You don’t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse mix of backgrounds, including project management, development, graphic design, product management, business analysis and so on. You need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. You need to be comfortable learning in English. All video lessons, course materials, webinars, correspondence and the final exam are delivered in English. Career path Students typically graduate into UI Designer jobs. The average UI Designer salary in the UK with 3-5 years experience is £62,500. This is based on data from Payscale, Totaljobs, Indeed, Talent, and Glassdoor

Group Course (Max 6 Delegates)

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.

The NCCH Convention 2025 – Elevate Your Hypnotherapy Practice! Date: Saturday, November 8th & Sunday, November 9th 📍 Location: Crown Hotel, Harrogate – Bronte Room 🎟 Admission: FREE for Students and Trance Tribe Members Join us for the Northern College of Clinical Hypnotherapy Convention, a dynamic two-day event designed to enhance your skills, expand your network, and inspire your practice. Featuring expert-led workshops, hands-on learning, and guest speakers, this is the perfect opportunity to deepen your knowledge and connect with like-minded professionals. 🔹 Convention Highlights ✅ Live demonstrations of hypnotic inductions, deepening techniques, and ideomotor signaling ✅ Practical workshops on Parts Therapy, Compassionate Inquiry, and experiential learning ✅ Guest speakers covering hypnotherapy business strategies and audio production for hypnotherapists ✅ Hands-on training to refine your techniques and boost client engagement ✅ Networking opportunities with fellow hypnotherapists, trainers, and industry experts Note: All sessions include refreshments. Attendees are encouraged to bring business cards for networking opportunities. The Northern College of Clinical Hypnotherapy Convention Schedule. Saturday, November 8th 10:00 AM - 10:30 AM Registration & Welcome Check-in and networking with fellow attendees. Refreshments available. 10:30 AM - 11:30 AM Session 1: Hypnotic Inductions Explore various hypnotic induction and rapid induction techniques to enhance client engagement. 11:30 AM - 12:30 PM Session 2: Deepening Techniques Learn effective methods to deepen the hypnotic state for optimal results. 12:30 PM - 1:30 PM Lunch Break Enjoy refreshments and network with other practitioners. 1:30 PM - 2:30 PM Session 3: Ideo-Motor Signaling and EAM demo with Nicola Barragry. Discover the art of ideomotor signalling for subconscious communication. 2:30 PM - 3:30 PM Guest Speaker: Zoe from Build It Brilliant Topic: Hypno Business Strategy Masterclass Gain insights on building a successful hypnotherapy practice. 3:30 PM - 4:00 PM Q&A Session with Zoe Open floor for questions and discussion with the guest speaker. The Northern College of Clinical Hypnotherapy Convention Schedule Sunday, November 9th 10:00 AM - 10:30 AM Welcome Back & Refreshments Gather for the second day of learning and networking. 10:30 AM - 11:30 AM Session 1: Advanced Techniques - Compasionate enquiry & Parts Therapy Delve into parts therapy and its application in hypnotherapy. 11:30 AM - 12:30 PM Session 2: Practical Application of Compassionate Inquiry and Parts Therapy Hands-on practice in small groups to implement techniques learned. 12:30 PM - 1:30 PM Lunch Break Refreshments provided; continue networking. 1:30 PM - 2:30 PM Session 3: Experiential Learning Engage in experiential exercises to deepen understanding of advanced techniques. 2:30 PM - 3:30 PM Guest Speaker: Unlock your audio potential with a special session featuring hypnotherapist trainer and audio expert Louise Frank! Learn the basics of Audacity, from setup and interface navigation to capturing high-quality audio and editing techniques, take your audio skills to the next level with 3:30 PM - 4:00 PM Closing Remarks & Networking Opportunity Wrap up the convention with final thoughts and a chance to connect with peers.