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
The Combined First Aid at Work and Paediatric First Aid Course is ideal for those who work in settings that require both first aiders and paediatric first aiders, such as schools, sports clubs or other childcare settings. Combining the QA Level 3 Award in First Aid at Work (RQF) and the QA Level 3 Award in Paediatric First Aid (RQF) into 3 extended days of classroom learning, this specially designed course enables candidates to gain the skills and knowledge needed to provide both adult and paediatric first aid, whilst minimising the number of training days required to achieve both qualification. Candidates will cover a range of topics needed to provide effective first aid for adults, children and infants including CPR and defibrillation, choking, stroke, head injuries, asthma and much more.
An emergency can happen anywhere, so it's better to be prepared at all instances, specially at the workplace. Come to Knight Training and ensure your employees are safe with our Emergency First Aid At Work Course now!
NPORS Plant Supervisor Awareness (N034)
NPORS Abrasive Wheels Awareness (N301A)
Who Should Attend This course is aimed at candidates that require the knowledge to enable them to comply with working at height regulations, and go in depth into industry dangers and respectability when working at height. This course can be completed by both novice and experienced candidates. We also offer refresher tests. Novice course- 1/2 day Experienced worker tests- 1/2 day. Course information Category N404 Safe Working At Height It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following: ➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities when working at height ➢ Be able to define height work and identify the hazards of work above ground level and outline the general requirements necessary to control them ➢ Be able to identify accident causation in work at height ➢ Have an appreciation of planning and organisation of work at height ➢ Set up exclusion zone explaining actions required for emergency actions, identifying any overhead hazards ➢ Identify and maintain PPE appropriate for safe working at height use ➢ Demonstrate working at height and explain all safety issues that could arise Assessment Assessment will be to NPORS standards consisting of a theory test.
NPORS Harness and Fall Arrest (N723)
NPORS Dozer (N215)
NPORS Piling Rig (N221)
NPORS Horizontal Directional Drilling Rig (N130)