1963 Courses in Cardiff

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

Battery Storage (Electrical Energy Storage Systems)

This course is suitable for Solid Fuel engineers who are looking to re-new their previous certification. Our Initial course is available through this link: https://www.citytraining.com/w/courses/21-solid-fuel-initial Dry - 1 Day Wet - 2 Days Our courses are accredited by OFTEC and certified by Cert-ain, but this does not stop you from renewing or achieving accreditation from HETAS and similar bodies, saving you money on training costs too. What's included? DryOFT15-108(D) - Installation, commissioning, and servicing of solid fuel burning appliances (dry space heating).OFT18-108(S) - Service, maintenance, repair, or commissioning of solid fuel burning appliances. WetAs above [OFT15-108(D) & OFT18-108(S)].OFT15-108(W) - Installation, commissioning, and servicing of solid fuel burning appliances with space heating and hot water heating. Prerequisites Category 1 - RENEWAL (this course) Applicants in this category are regarded as experienced Solid Fuel technicians holding one of the following - they will need to provide an original certificate as evidence to the Assessment Centre prior to taking OFTEC assessments:  OFTEC OFT15-108D (category 1 status for OFT15-108D and OFT18-108S) OFT15-108W (category 1 status for OFT15-108W, OFT15-108D and OFT18-108S) OFT18-108S (category 1 status for OFT18-108S only) HETAS H003 AND H006 (category 1 status for OFT15-108D and OFT18-108S) H004 AND H006 (category 1 status for OFT15-108W, OFT15-108D and OFT18-108S)H005 (category 1 status for OFT15-108W, OFT15-108D and OFT18-108S) H009 (category 1 status for OFT18-108S only) BPEC Solid Fuel Installer (category 1 status for OFT15-108W, OFT15-108D and OFT18-108S) CITY & GUILDS Level 3 NVQ Diploma in Domestic Plumbing and Heating (6189) - must include Solid Fuel pathway (category 1 status for OFT15-108W, OFT15-108D and OFT18-108S)Level 3 Diploma in Plumbing and Domestic Heating (9189-03) - must include Solid Fuel pathway (category 1 status for OFT15-108W, OFT15-108D and OFT18-108S) Category 2 (Heating Engineer - Other Fuel) - (Initial Only)Applicants in this category are regarded as holding a nationally recognised qualification in a trade associated with Solid Fuel work; candidates must provide relevant qualifications to support entry: For those looking to expand into Solid Fuel, please visit our Solid Fuel Initial page! DryOFTEC technician with scope of work categories 101,102 or 105Eor - Registered Gas Safe or RGII operativeor - Registered member of GOMCS, APICS, NACS, NIACS, CSAI, ICS, CSA or NACEor - evidence of formal qualifications: City & Guilds 6129/6035 and 6089, or QCF 6189;or - (United Kingdom) N/SVQ Level 2/3 in plumbing or equivalent earlier certification that provides evidence of competenceor - (Republic of Ireland) FETAC Level 5 in plumbingor - HETAS H003 Dry Appliance Installer courseor - BPEC Solid Fuel Installer or Solid Biomass courseor - APHC Installation of Solid Fuel Appliances and Heating Systems Fed by Solid Fuel in Domestic Appliances courseor have relevant qualifications, skills and experience gained from working in a related trade such as Plumbing / Heating / Ventilation / Refrigeration / Air-Conditioning / Gas Fitting or servicing. Applicants must provide evidence of this related experience to the Assessment Centre. The evidence must consist of, as a minimum, the following:Name and address of the business(s) providing the related experience.The types of related work undertaken (minimum 4/5 jobs). Wet Compulsory: OFTEC OFT15-108D AND (United Kingdom) - N/SVQ Level 2/3 in plumbing or equivalent earlier certification that provides evidence of competence (Republic of Ireland) - FETAC Level 6 in plumbing or - evidence of OFTEC 101 or 105E; or - evidence of formal qualifications: City & Guilds 6035 and 6089, or QCF 6189; or - HETAS H004 Wet Appliance Installer course or - BPEC Solid Biomass course or - Gas Safe Registered Operative holding a current CENWAT category or - RGII Registered Operative holding a current GID category All Category 2 candidates must also undertake training at an OFTEC approved training centre. The training must consist of training utilising the current OFTEC Technical Book. The possession of the OFTEC Technical Book prior to training and subsequent assessment is mandatory. Category 3 (New to Industry - Dry Only) - (Initial Only) Applicants in this category are regarded as new to the Solid Fuel industry, and do not hold any national qualifications in a related field nor have any related work experience. Application conditions for this category require that the Category 3 applicant must obtain experience with a business which is willing to provide an auditable extended Solid Fuel training programme incorporating both On and Off the Job components with organisational support prior to the applicant taking OFTEC training and assessment. Evidence of the contents of the programme detailing the Off the Job training and On the Job experience must be presented to the Assessment Centre as above. 4 to 5 jobs are required as a minimum for your portfolio.

Awareness of first aid for mental health: What will you learn? You’ll be surprised by how much you enjoy the 4-hour session. I always make sure the learning process is engaging, interactive and stimulating — so you won’t be bored. Most importantly, it’s a fascinating insight into a subject that’s often brushed under the carpet. It’s a flexible course, and I’m always happy to tailor the content. If there’s an aspect of mental health or addiction you’d like to know more about, please just ask. Here’s the 4-hour course content: Defining mental health, and understanding the stigma surrounding it Factors which affect mental health Roles and responsibilities of a first aider Outline of advice — What to say (and not to say) to someone with a suspected mental health condition Listening without judgement Knowing when to contact the emergency services Identifying signs of stress, and how stress can be managed How to implement a positive mental health culture in the workplace Identifying signs and symptoms of depression, suicide, psychosis, anxiety, self-harm, eating disorders Do bear in mind, this course can’t teach you how to diagnose and treat a mental health condition. That’s the responsibility of a healthcare professional. However, you’ll know where to signpost an individual who needs professional help. You’ll leave with the knowledge and confidence to approach, reassure and support someone when they need it most.

Overview Improve your knowledge of the English language and pronunciation and practice your speaking and vocabulary with our video lessons and with live face to face with the trainer online and In-Class. Choose your English course level from our wide range of english courses and start learning online today. Take any of our high quality online English lessons with the highlu experienced trainer and improve your English speaking skills along with your grammar, reading and writing. Start by taking our English lessons to help you find your level and increase your communication skills also find lessons and resources to improve your English skills. Throuh this course you will get more practice to improve your general English with our extended listening and reading materials and online trainer led training. Improve your the grammar and vocabulary and support your learning.

Immerse Medical are experienced at teaching first aid to young people within the educational sector. We have designed this workshop style programme specifically for those in KS3/4. The sessions are fun, engaging and focus on fundamental life saving skills. Using interactive gamification, students gain hands on experience, which they will draw upon in real life medical emergencies. These sessions are perfect as part of phase 2 of National Citizenship Service (NCS) and Duke of Edinburgh (DofE) Awards. Key points Meets national curriculum secondary education guidelines– We’ve designed this programme to exceed the requirements of the 2020 guidelines. Training by doctors, nurses and paramedics – We have years of experience working on the front line of emergency medicine; giving us real world knowledge and skills in managing injured or unwell people. Latest equipment & technology – We utilise technology enhanced learning to provide a realistic opportunity to practice fundamental life saving skills in a safe environment. More than first aid – While participating in this workshop young people will also develop their ability to work as part of team, communicate effectively and think critically in high pressure situations leading to an overall increase in personal confidence. Check out the skills included in the videos below. First Aid Courses For Young People Programmes and sessions for young people focusing on how to keep each other safe and what to do if something goes wrong. Sessions are designed with age and national curriculum in mind, from 1 hour tasters to sessions for large groups, perfect as part of NCS and Duke of Edinburgh programmes. Our training for young people is fun, engaging and focuses on fundamental life saving skills.  All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.

A dynamic and interactive one-day or two-half-day live virtual workshop for women leaders in business, government and non-profit organizations.

Emergency First Aid at Work: What will you learn? The course covers everything listed below. There will be practical demonstrations, a bit of role playing and some activities to keep things engaging and interesting. I’m happy to tailor the content with additions. For instance, if you’d like me to focus on treating sprained ankles because this is a particular risk at your workplace, that’s fine. During the course, you’ll be trying out your newly-learned techniques with a whole range of equipment, including mannequins. And… this course includes the Bra Off, Defib On. Did you know that women are less likely than men to survive when a defibrillator is used on them in a medical emergency? Proper pad placement is crucial, and you’ll learn this life-saving skill. Here’s the full course content: The role of a first aider Health and safety regulations (First Aid) How to respond to an emergency Casualty care How to deal with an unresponsive casualty, and the recovery position Resuscitation, and how to carry out CPR How to use an automated external defibrillator (includes Bra Off, Defib On) How to save someone from choking Dealing with seizures Treating someone who’s in shock Bleeding, both minor and severe Treating minor injuries

Attention Private 1-10 classes! Take advantage of our limited time offer and get your own training program at a discounted rate of £550 instead of £600. Our program is designed to help you fix dysfunctional points, improve mobility, build strength, and learn effective techniques using kettlebells, free weights, bodyweight exercises and combat movements / Muay Thai Boxing, Boxing, Brazilian Jiu Jitsu/  Achieve your fitness goals including weight loss, strength & muscle gain, better performance in your sports!  Don't miss out on this opportunity to invest in yourself! Single private class is £65 10 Private classes is £600 Get a 10 private class package with discount now, for £550

Well-being isn't just a 'nice to have' - it should be a core part of your employee strategy.