Microsoft Access training course description A hands on course providing a solid grounding in Microsoft Access. What will you learn Use and customise the Microsoft Access environment. Select, use and customise queries. Define tables. Design forms and reports. Recognise the use of macros. Microsoft Access training course details Who will benefit: Anyone wishing to work with Microsoft Access. Prerequisites: Database fundamentals Duration 3 days Microsoft Access training course contents Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. Macros Introduction to macros.
Our Fast-Track Barbering Course allows you to choose what you learn. Aimed at those who have Barbering experience but don’t feel confident enough on the salon floor, or those looking to brush up on a specific skill. You choose what you learn – cutting, fading, beard/moustache work or focusing on a specific style/technique – and the number of days you want to train.
Choose what you want to learn in this fast-track hairdressing course. Aimed at those who’ve left college with a hairdressing qualification but don’t feel confident enough on the salon floor or those needing to brush up on a specific skill. Our training concentrates on cutting, colouring, styling and barbering.
The Level 3 Diploma in Dental Nursing is internationally recognised qualification. Successful completion will enable you to register as a Dental Care Professional with the General Dental Council (GDC) Dental Nursing Diploma with National Examining Board for Dental Nurses (NEBDN) is an internationally recognised qualification that will allow you to work as a Dental Nurse in hospitals, NHS and private dental practices. Successful completion of Dental Nursing Diploma course will enable you to register as a Dental Care Professional with the General Dental Council (GDC) and practice as a qualified Dental Nurse. Dental Nursing is more than just a job, it’s a profession that allows you to make a real difference in people’s lives. Being a Dental Nurse can be an exciting and fulfilling career that allows you to make a positive impact on people’s lives while enjoying a variety of work and opportunities to learn and grow. You’ll get to work with an amazing dental team and get to know patients, helping them to feel at ease and comfortable during their visit. You’ll be the one behind the scene making sure everything runs smoothly, and you’ll be the one that patients will turn to for assistance. You’ll also get to be a part of the latest advancements in dental technology and treatment. And on top of all that, you get to have a flexible schedule and a good earning potential, with the potential to advance in your career. All in all, being a dental nurse is one of the most exciting and fulfilling career that you can have, and you’ll get to leave work every day knowing you’ve made a real difference in the lives of others. Join a profession that is in demand, fulfilling and financially rewarding. Our dental nursing course will provide you with the necessary knowledge and skills to succeed in a field that is growing in popularity. The course is delivered by Team of Dental Professionals who are examiners, dentists and experienced Dental tutors with years of experience in teaching Dentistry. Dental Nurses are involved in a wide range of procedures, from routine check-ups to complex surgeries, which can make the job interesting and varied. Patient-centered care: Dental Nurses have a direct impact on the patient’s experience and can make a positive difference in people’s lives by providing them with quality care. Professional development: Dental Nurses have the opportunity to continue their education and expand their skills, leading to advancement and new opportunities in the field. Study mode – hybrid/blended mode of study that combines traditional class-based tuition with virtual/livestream learning No previous experience required – we will teach you from A to Z. Do you need a job? Yes, you will have 3 months’ time from the start of your course to find a placement. The Academy provides a list of Private and NHS Dental Surgeries, who are regularly contacting us when looking for more Trainee Dental Nurses, so you can contact them directly as a registered student at the Academy. This is a paid job, unless you would like to work voluntary for personal reasons. We also provide a reference letter to the employer in case you need it. The course is ideal for you if: You are looking for a qualification that leads to employment You intend to participate within dentistry and make a positive contribution to the dental health You wish to learn how to maintain high standards of hygiene, cleanliness, health & safety You enjoy interacting with multidisciplinary team and different people The curriculum is based on the GDC (General Dental Council) registration requirements for dental nurses. It sets out the knowledge, skills and behavioural requirements that should be developed and demonstrated. These are set out in terms of professional competencies, with the assessment method clearly outlined (e.g. how the skills and knowledge will be assessed in the final examinations – via written questions such as multiple choice (MCQ) or extended matching questions (EMQ) or via Objective Structured Clinical Examinations – OSCEs). We are proud to announce that our Dental Nursing students has the highest examination pass rate in OSCE examinations! Free services– workshops, mock exams, eRoE marking and internal moderation. Why join London Waterloo Academy? We are truly proud of what we have already accomplished. Academy has been operating since 2009 with a long list of graduates and successful Dental Professionals. We are continually striving to provide high quality tuition, and by listening to our learners, we are able to make studying at London Waterloo Academy easy and comfortable, which helps our learners to be confident and successful. This is what we can offer to our students. Top Dental Nursing course provider We are regularly contacted by Dental Surgeries to recruit our learners for Trainee Dental Nurse position 98% exam pass rate Small groups designed to keep high quality of tuition and progress Individual support all the way to graduation Earn while you learn Interactive lessons (visual, practical, activities, games, social events) We offer flexible payment plan at no extra charge on top of the instalments We are recognised and consistently approached by private surgeries that are well acquainted with our high teaching standards. These surgeries actively seek out our candidates to fill Trainee Dental Nurse vacancies On completion you will hold National Dental Nursing Diploma (NEBDN) and become General Dental Council (GDC) registered Dental Nurse Regular feedback on progress We have a community feel where each individual values and respects one another. This may be the reason why our graduates, even those who have completed the course many years ago, continue to come back not only for a chat and a cuppa, but also to share personal issues, tell us of their experience and success stories, among many other reasons. Central London – Waterloo/Southwark How will you learn? The course is based on 1 year part time (once a week, 2 hours) class based studies and a minimum of 16 hours per week practical experience, which involves working at a dental surgery. This is a paid job, unless you would like to work voluntary for personal reasons. LWA will also provide a Reference letter to the employee in case if learner finds a job independently. Earn while you learn could be another benefit for doing this course. We provide a list of Private Surgeries who have been working with us for the last 10 years and looking for more Trainee Dental Nurses so learners can contact them as a registered student at the Academy. Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Dental Department always behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. What Can You Expect to Earn as a Dental Nurse? Compared to other caring professions, Dental Nursing is well paid and offers plenty of opportunity for continued training and development. This is great for those looking on a the long-term plan for their career and those who wish to work their way up the ladder through continued learning, experience & hard work.Trainee Dental Nurse salary for standard working week will be around £23,000 per annum. Average wage for a qualified Dental Nurses between £40,417 to £42,350 p.a. Any workshops or exam preparation? Academy offers 4 revision and mock test sessions prior to the written examination and 3 hour preparation session for OSCE’s examination. When are the exams? There are two exams: 1. Multiple choice theory exam – November and March 2. Practical exam – January and June. Please click here for more information Record of Experience (eROE) To be eligible to sit your first exam, you have to complete your electronic Record of Experience (ROE). The ROE has to be submitted to your tutor by 31st Jan for March exam, and 31st August for November exam. Please click here for more information
Foundation • Advanced • Masterclass 8 CPD POINTS 1 DAY COURSE ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) PDO THREADS LIFT AREA BEGINNER Face and Neck Threads Lift, ADVANCED Body Threads Lift, MASTERCLASS Face, Neck, Body Threads Lift, MASTERCLASS Foxy Eyes | Cat Eyes
This qualification delivers a solid foundation in finance administration and core accounting skills, including double-entry bookkeeping, basic costing and an understanding of purchase, sales and general ledgers. Course Overview This qualification delivers a solid foundation in finance administration and core accounting skills, including double-entry bookkeeping, basic costing and an understanding of purchase, sales and general ledgers. Students will also learn about accountancy related business and personal skills and be introduced to the four key themes embedded in the qualification: ethics, technology, communications and sustainability. The jobs it can lead to: • Account administrator • Accounts assistant • Accounts payable clerk • Purchase/sales ledger clerk • Trainee accounting technician • Trainee finance assistant Entry requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success, we recommend that students begin their studies with a good standard of English and maths. Course Content: Introduction to Bookkeeping: This unit provides students with an understanding of manual and digital bookkeeping systems, including the associated documents and processes. Students will learn the basic principles that underpin double-entry bookkeeping systems. Learning outcomes: • Understand how to set up bookkeeping systems. • Process customer transactions. • Process supplier transactions. • Process receipts and payments. • Process transactions into the ledger accounts. Principles of Bookkeeping Controls: This unit builds on the knowledge and skills acquired from studying Introduction to Bookkeeping and explores control accounts, journals and reconciliations. Students will develop the ability to prepare the value added tax (VAT) control accounts as well as the receivables and payables ledger accounts. They’ll use the journal to record a variety of transactions, including the correction errors. Students will be able to redraft the initial trial balance, following adjustments. Learning outcomes: • Use control accounts. • Reconcile a bank statement with the cash book. • Use the journal. • Produce trial balances. Principles of Costing: This unit gives students an introduction to the principles of basic costing and builds a solid foundation in the knowledge and skills required for more complex costing and management accounting tasks. Students will learn the importance of the costing system as a source of information that allows management to plan, make decisions and control costs. Learning outcomes: • Understand the cost recording system within an organisation. • Use cost recording techniques. • Provide information on actual and budgeted cost and income. • Use tools and techniques to support cost calculations. The Business Environment: This unit provides knowledge and understanding of key business concepts and their practical application in the external and internal environment in which students will work. Students will gain an understanding of the legal system and principles of contract law and an appreciation of the legal implications of setting up a business and the consequences this may have. This unit will also give an understanding of how organisations are structured and where the finance function fits. Learning outcomes: • Understand the principles of contract law. • Understand the external business environment. • Understand the key principles of corporate social responsibility (CSR), ethics and sustainability. • Understand the impact of setting up different types of business entity. • Understand the finance function within an organisation. • Produce work in appropriate formats and communicate effectively. • Understand the importance of information to business operations. DURATION 170-190 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate
About this Virtual Instructor Led Training (VILT) Electrical machines, mainly power transformers and electric motors are critical equipment that run production, and it must operate without any abnormalities. A wide variety of tests and standards have been developed to assist manufacturers and users of motors and transformer winding, assess the condition of the electrical insulation. The objective of this training course is to provide an understanding of power transformers and electric motors, their materials, components, and how they operate. It will also emphasize the importance of transformer life management, especially for those transformers and electric motors which have been in operation for than 10 years. The course will address in detail all aspects related to transformer principles, calculations, operation, testing and maintenance. Training Objectives This course aims to provide participants with the understanding of the fundamentals and constructional features of power transformers and electric motors, with particular reference to the design, testing, operation and maintenance of transformers in power systems. Delegates will gain a detailed appreciation of the following: Practical solutions for specifying, operating and maintaining power transformers and electric motors in a utility or plant environment Comprehensive understanding of principles, protection, maintenance and troubleshooting of power transformers and electric motors The necessary safe procedures relating to transformer operation and related circuitry Understand the principles of operation of the transformer and electric motors Identify the different features of power transformers and electric motors Appreciate the principles of transformer design, ratings, winding, core structure and materials, insulation and cooling methods, insulation and lifetime Utilize thermal limits and loading guides of transformers Analyze transformer and electric motors failure modes Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 half-day sessions comprising 4 hours per day, with 1 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. Trainer Our key expert is actively involved in electrical inspections, energy audits, energy efficiency and technical consultation for M&E activities for industrial and commercial sectors. He is involved in testing and commissioning works of factory substations of up to 132kV system. He previously worked for Jimah coal-fired power plant in Port Dickson for 9 years with his last position being Electrical Maintenance Section Head. He was involved in the commissioning of coal-fired power plant mainly with 500kV generator transformer, 934 MVA generator, and up to 33kV MV motors and switchgear panels. Our key expert has managed the maintenance team to perform routine maintenance activities (together with supporting tools such as motor lube oil analysis, infrared thermography analysis, transformer oil analysis) & electrical troubleshooting and plant outages for critical and non-critical equipment. Besides that, our key expert has published several IEEE conference papers and journals such as: (2009). Effectiveness of auxiliary system monitoring & continuous hydrogen scavenging operation on hydrogen-cooled generator at power plant. In Energy and Environment, 2009. ICEE 2009. 3rd International Conference on (pp. 151-160). IEEE. (2010). Study on electric motor mass unbalance based on vibration monitoring analysis technique. In Mechanical and Electrical Technology (ICMET), 2010 2nd International Conference on (pp. 539-542). IEEE. (2012). Re-Design of AC Excitation Busduct based on Infrared (IR) Thermography: Condition-Based Monitoring (CBM) data analysis. eMaintenance, 101. (2016). Energy Saving Studies for a University Campus: An Educational-Based Approach, 3rd International Conference on Language, Education, Humanities and Innovation 2016. 'Grid-tied photovoltaic and battery storage systems with Malaysian electrcity tariff - A review on maximum demand shaving.' Energies 10.11 (2017): 1884 'Techno-Economic Optimization of Grid-Connected Photovoltaic (PV) and Battery Systems Based on Maximum Demand Reduction (MDRed) Modelling in Malaysia.' Energies 12.18 (2019): 3531 POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations
The NVQ Diploma in Senior Construction Management Qualification is suited to those who are engaged in high level management activity of a construction business and who working in a senior management role and are seeking to obtain the Black CSCS Card. Our team will discuss the qualification process with you prior to signing up in order to ensure that you will be able to complete the qualification. Complete your qualification quickly with the support of your assessor in as little as 10 to 12 weeks providing that you work with your assessor to provide the required evidence. We offer two other qualifications that lead to the Black CSCS card, follow the links below for more information (open in new window): Level 6 NVQ Diploma in Construction Contracting Operations Management – 8 Units – Complete in as little as 10 weeks. Level 6 NVQ Diploma in Construction Site Management – 19 units – Complete in as little 16 to 20 weeks. CSCS Cards We can provide CSCS tests and CSCS cards alongside your qualification without the need to attend the test centre. Speak to our friendly and helpful team for more information.
The NVQ Level 4 Diploma in Construction Site Supervision is appropriate for individuals who work as a Construction Site Supervisor/ Foreman or Assistant Site Manager in the construction sector and are looking to become eligible for the Gold ‘Site Supervisor’ CSCS Card. Our team will discuss the qualification process with you prior to signing up in order to ensure that you will be able to complete the qualification. Every candidate is assigned a competent and experienced assessor who will provide advice and guidance throughout the programme to ensure that candidates are supported in the successful completion of the qualification. CSCS Cards We can provide CSCS tests and CSCS cards alongside your qualification without the need to attend the test centre. Speak to our friendly and helpful team for more information.
The NVQ Diploma in Construction Contracting Operations Management qualification is suited to those who are working in a management role in the construction industry and are looking to become eligible for the Black CSCS Card. Candidates follow one of five pathways depending on their job role: General Estimating Buying Planning Surveying Our team will discuss the qualification process with you prior to signing up in order to ensure that you will be able to complete the qualification. Every candidate is assigned a competent and experienced assessor who will provide advice and guidance throughout the programme to ensure that candidates are supported in the successful completion of the qualification. CSCS Cards We can provide CSCS tests and CSCS cards alongside your qualification without the need to attend the test centre. Speak to our friendly and helpful team for more information.