624 Trainer courses in Musselburgh delivered Live Online

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Very clearly explained Good pace. Lucy Tailor - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Course Overview The Canine First Aid and CPR Course provides essential knowledge and skills to respond to emergencies involving dogs. It covers a range of critical topics, including first aid, CPR, and basic health assessments. This course is designed to empower learners with the confidence to act decisively in a variety of canine emergency situations, enhancing the safety and well-being of pets. Upon completion, learners will gain the ability to handle common canine injuries and medical emergencies, ensuring pets receive the care they need in times of distress. Course Description This course dives deep into key areas of canine health and emergency response. Learners will explore pet first aid, including injury management and common health issues, along with essential CPR techniques for dogs. The course also covers important aspects of pet business practices, giving those interested in the pet care industry a well-rounded understanding. With an engaging and thorough curriculum, learners will develop the skills required to provide immediate assistance to dogs in need, preparing them for any situation that may arise. The course is designed for all levels of learners, from beginners to professionals seeking to expand their knowledge in pet care. Course Modules: Module 01: Pet First Aid Key first aid procedures for dogs Identifying and treating common injuries Basic wound care and infection prevention Module 02: Pet CPR Techniques for canine CPR Recognising signs of cardiac arrest in dogs Step-by-step guide to performing CPR Module 03: Pet Business Essential business practices for pet care professionals Overview of pet care industry trends Marketing and client management for pet businesses (See full curriculum) Who is this course for? Individuals seeking to improve their dog care knowledge. Professionals aiming to expand their skill set in the pet care industry. Beginners with an interest in pet health and emergency care. Pet owners looking to become more confident in handling canine emergencies. Career Path Pet Care Professional Canine Health Advisor Dog Trainer or Behaviourist Veterinary Assistant Pet Business Owner

Course Overview This Sexual Harassment Awareness Training is designed to equip individuals with the knowledge and skills to recognise, address, and prevent sexual harassment in the workplace. Covering key concepts, legal frameworks, and organisational responsibilities, the course provides essential insights into maintaining a respectful and safe work environment. Participants will gain a thorough understanding of what constitutes sexual harassment, how to identify it, and how to manage such situations effectively. By completing this course, learners will be better prepared to contribute to a respectful and legally compliant workplace culture. Course Description This course delves into various aspects of sexual harassment, from definitions to workplace implications, and legal frameworks. It covers the different forms of harassment, employee rights, and employer obligations. Learners will explore how to effectively address and prevent incidents of harassment, ensuring worker protection through robust policies and procedures. The course also covers the process of dealing with incidents, including mediation and the aftermath, helping individuals recognise the importance of fostering a safe, respectful work environment. Upon completion, learners will have the skills to proactively contribute to creating a harassment-free workplace. Course Modules Module 01: What is Sexual Harassment? Module 02: Sexual Harassment in the Workplace Module 03: The Law and Sexual Harassment Module 04: Addressing Sexual Harassment Module 05: Worker Protection Module 06: Prevent Sexual Harassment at Work Module 07: Policies and Procedures Module 08: How to Deal with Sexual Harassment in the Workplace? Module 09: Mediation and the Aftermath (See full curriculum) Who is this course for? Individuals seeking to understand workplace dynamics and employee rights. Professionals aiming to enhance their knowledge of workplace law and ethical practices. Beginners with an interest in workplace relations and human resources. Any other individual interested in fostering a respectful workplace environment. Career Path HR Manager Equality and Diversity Officer Workplace Health and Safety Specialist Legal Advisor (Employment Law) Corporate Trainer or Consultant

Presentation Skills Course Overview This course on Presentation Skills is designed to help learners develop the confidence and techniques necessary to deliver engaging and effective presentations. It covers key aspects of presentation delivery, from understanding audience psychology to mastering various engagement techniques. Learners will be guided on how to structure content, use humour, and create a safe, welcoming environment for their audience. By the end of the course, participants will be equipped with the skills to deliver presentations that are not only informative but also captivating and memorable. Course Description Throughout this course, learners will explore the essential principles behind effective presentation techniques. The content includes creating a sense of security for the audience, fostering a positive atmosphere, and using humour to enhance engagement. Learners will also delve into methods of connecting with different audience types, ensuring their message is both clear and compelling. The course will include modules that focus on both verbal and non-verbal communication, giving learners the ability to present confidently in any setting. By the end of this course, participants will be prepared to present with impact, regardless of their experience level. Presentation Skills Curriculum Module 01: Introduction to Archetype Module 02: Make Your Audience Feel Safe Module 03: Make Your Audience Feel Good Module 04: Make Your Audience Laugh Module 05: Course Wrap Up (See full curriculum) Who is this course for? Individuals seeking to improve their public speaking skills. Professionals aiming to enhance their communication and presentation abilities. Beginners with an interest in presentation techniques. Anyone looking to build confidence when presenting to groups. Career Path Public Speaking Coach Corporate Trainer Event Speaker Communications Specialist Marketing and Sales Presentations

Career Development and Passion Course Overview This course is designed to help individuals navigate their career development while staying true to their passions. It covers key aspects of career growth, self-improvement, and the strategic pursuit of personal interests to build a fulfilling professional life. Learners will explore how to harness their passion to fuel career success, develop essential skills, and adopt a positive mindset for achieving long-term professional goals. Upon completion, learners will be equipped to enhance their career trajectory, align their passion with their work, and achieve greater job satisfaction. Course Description In this course, learners will delve into various stages of career development, focusing on self-improvement, identifying and chasing one's passion, and mastering the mindset required for success. Topics such as aligning passion with career choices, improving skills, and navigating job hunting will be covered in-depth. Learners will gain insights into how passion can be a driving force behind career success and how to monetise skills and interests effectively. By mastering these topics, participants will be well-prepared to achieve personal and professional fulfilment in their chosen career path. Career Development and Passion Curriculum Module 01: Career Module 02: Self-Improvement Module 03: Passion Module 04: Chase the Passion Module 05: Be Good at Your Passion Module 06: Passion and Money Module 07: Master Your Mindset Module 08: Preparation for Success Module 09: Job Hunting Module 10: Acing Your Interview Module 11: Prosper in Career (See full curriculum) Who is this course for? Individuals seeking to align their career with their passion. Professionals aiming to enhance career growth and job satisfaction. Beginners with an interest in career development and personal growth. Anyone looking to improve their job hunting and interview skills. Career Path Career development coach HR specialist Business consultant Entrepreneur in passion-driven industries Motivational speaker or trainer Corporate strategist Freelance professional

Ace Your Presentations: Public Speaking Masterclass Course Overview In the "Ace Your Presentations: Public Speaking Masterclass," learners will acquire essential skills to enhance their public speaking and presentation abilities. The course covers techniques for confident delivery, structuring engaging presentations, handling stage fright, and communicating effectively with diverse audiences. By the end, learners will have the tools to captivate any audience, whether in a business meeting, conference, or seminar. This course offers practical value for anyone seeking to improve their speaking abilities, with tangible benefits in personal confidence and professional success. Course Description This comprehensive course dives into various aspects of public speaking, including speech structure, voice modulation, body language, and audience engagement. It explores techniques for managing nerves, maintaining focus, and delivering persuasive presentations. Learners will also gain valuable insights into creating compelling visual aids and handling questions with ease. With a focus on clear, effective communication, this course equips participants with the skills needed to influence, inspire, and inform any audience, setting the stage for career advancement and personal growth. Ace Your Presentations: Public Speaking Masterclass Curriculum Module 01: Introduction to Public Speaking Module 02: Building Confidence and Overcoming Nervousness Module 03: Structuring Your Presentation Module 04: Mastering Body Language and Voice Modulation Module 05: Engaging Your Audience and Handling Questions Module 06: Creating Effective Visual Aids and Supporting Materials Module 07: Final Project: Delivering Your Own Presentation (See full curriculum) Who is this course for? Individuals seeking to boost their public speaking confidence Professionals aiming to enhance their communication skills Beginners with an interest in becoming effective presenters Anyone looking to refine their speaking abilities for career advancement Career Path Public Speaker Corporate Trainer Marketing and Sales Professional Event Speaker Communication Consultant

"Self Care" - A Key To Happiness Course Overview: "Self Care: A Key To Happiness" is a comprehensive course designed to provide learners with essential strategies and techniques to improve their well-being and mental health. Focusing on the importance of self-care in maintaining happiness, this course equips participants with practical tools to manage stress, set boundaries, and enhance their emotional resilience. It explores various self-care practices, including mindfulness, relaxation techniques, and the significance of a balanced lifestyle. By the end of the course, learners will gain the ability to integrate self-care into their daily routines, leading to increased overall happiness, productivity, and life satisfaction. Course Description: This course delves deeper into the concept of self-care, exploring the connection between mental and physical health. Participants will learn effective methods for self-awareness, stress management, and emotional well-being. Key topics include mindfulness practices, relaxation exercises, understanding emotional triggers, and cultivating a positive mindset. The course also examines the role of nutrition, sleep, and exercise in maintaining a balanced and happy life. Learners will be guided on how to create personalised self-care plans tailored to their unique needs, ensuring long-term success. Upon completion, students will have gained valuable skills in self-regulation, resilience-building, and sustainable happiness. "Self Care" - A Key To Happiness Curriculum: Module 01: About this Course Module 02: Full Course Module 03: Next Steps Module 04: Extra Content for YOU (See full curriculum) Who is this course for? Individuals seeking to enhance their well-being and happiness Professionals aiming to improve their stress management and mental resilience Beginners with an interest in mental health and self-care Those seeking balance and mindfulness in their daily lives Career Path Mental Health Support Worker Wellness Coach Health and Well-being Consultant Personal Development Trainer Employee Wellness Program Manager