• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Microsoft Access

5.0(3)

By Systems & Network Training

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.

Microsoft Access
Delivered in Internationally or OnlineFlexible Dates
£1,697

Intro to data communications & networking

5.0(3)

By Systems & Network Training

Data comms training course description A hands on training course introducing the concepts of data communications, moving on to covering both LAN and WAN technology. Quizzes are used extensively to ensure material has sunk in and to maximise learning time. Hands on sessions ensure that by the end of the course delegates have made cables, built LANS and WANS, configured TCP/IP, switches and routers. What will you learn Use the seven layer model to classify networking buzzwords. Build and troubleshoot Ethernet, LAN/WAN and WiFi networks Explain the difference between switches and routers. Connect networks with routers. Data comms training course details Who will benefit: Anyone who requires a technical introduction to networks. Prerequisites: None. Duration 3 days Data comms training course contents What are networks? What is data communications? What are networks? Types of network, LANs, LAN choices, WANs, WAN choices, PANs, SANs, MANs, connecting networks. Internetworks, the internet, clouds. Networks and standards Standards bodies, ISO, ITU, IEEE, IETF, OSI 7 layer reference model, TCP/IP and OSI, ping and the 7 layer model, encapsulation, fragmentation. The physical layer Transmission media: Copper, Fibre, RF, UTP, Cat 5/5e/6/7..., RJ45, straight and cross over cables. Coax, Fibre cable & connectors, SFP, MMF, SMF, radio spectrum, frequencies, ranges, noise and electrical distortion, repeaters. Hands on Cabling, ping. Bandwidth Definition, Bits, bytes, speeds, simplex, half/full duplex, a/symmetrical, aggregation, latency. Calculating bandwidth requirements. The Data Link layer Frames, classifications, standards, LAN/WAN layer 2 technologies (Point to point, virtual circuits). Ethernet What is Ethernet? 802.3, evolution from CSMA/CD, choosing cables, topologies, NICs, MAC addresses. Ethernet frame format. Hands on Analysing Ethernet frames. Ethernet switches Connecting multiple devices, switches work at layer 2, Switches vs. hubs, simultaneous conversations, full duplex, MAC address database, how switches work, switch benefits, loops, STP. Console ports. Hands on Switches and WireShark, configuring switches, broadcast storms, STP. VLANS What are VLANs, why have VLANs. Hands on The effect of VLANs on network traffic. Wireless LANs Type of wireless network. WiFi, 802.11b/g/n/ac, WiFi6, antennae, interference, 802.11 frame format, CSMA/CA, half duplex, Wireless Access Points, security. Hands on Building a WiFi network. WANS WAN architecture, WAN types, service providers, access equipment, DTE, DCE, core equipment, WANs and the 7 layer model, choosing a WAN. WAN access Point to point, multi access, Internet, phone lines, leased lines, xDSL, broadband architecture. DOCSIS, FTTH, PON, SD-WAN. Older technologies (if required): Modems, ISDN, 64k, E1, TDM. Packet switched networks Packet switching, virtual circuits, Hub & spoke, partial & full mesh, MPLS, MPLS and routers, Why MPLS? MPLS -TE, MPLS VPN, Internet VPN. Older technologies (if required). Service provider technologies Transport plane, SDH, SONET, WDM, CWDM, DWDM, DWDM architectures, OTN. TCP/IP Definition, protocols, services, internetworking, the Internet, intranets, IAB, RFCs, IP header, IP addressing, subnet masks, IPv6, TCP, UDP. Hands on IP address and subnet mask configuration. Routers What are routers? Routers vs switches, when to route and when to switch, default gateways, routing tables, static routes, routing protocols. Firewalls, how firewalls work. Hands on Router configuration, tracert. Applications Clients, servers, web, HTTP, Email, resource sharing, IM, VoIP, Video over IP, terminal emulation, ftp, ssh. Hands on telnet

Intro to data communications & networking
Delivered in Internationally or OnlineFlexible Dates
£1,697

Certified Scrum Product Owner

By IIL Europe Ltd

Certified ScrumMaster® This course is an introduction to Scrum and the principles and tools required to be an effective Scrum Product Owner. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of the Scrum framework to different situations. Participants successfully completing this course earn a Certified Scrum Product Owner® (CSPO®) designation. The Scrum Alliance certification includes a one-year membership with Scrum Alliance. What You Will Learn You'll learn how to: Use the principles, practices, and tools required to be an effective Scrum Product Owner Make effective decisions regarding the application of the Scrum framework to different situations, including: Setting product vision and goals Chartering the project Writing user stories and structuring your product backlog Scaling the Product Owner Estimating for forward planning Applying prioritization techniques Planning and tracking release progress Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Process control models Incremental and iterative development Shifting the focus on product management Overview of the Scrum process Agile principles Lean principles Scrum Roles and Responsibilities Scrum roles Cross-functional teams Product Owner Responsibilities The Scrum Project Community What happens to my traditional role in Scrum? Chartering the Project Establishing a shared vision Elevator Statement Data sheets Product Vision Box Magazine Review / Press Release Product Backlog and User Stories Product uncertainty and progressive refinement User role modeling User Stories Product backlog characteristics Getting backlog items ready Slicing User Stories Using the product backlog to manage expectations Sprints Done and Scaling Done The Scrum process in detail Sustainable pace The Product Owner's role in each of the Scrum meetings Scaling the Product Owner Scaling Scrum Approaches to scaling the Product Owner Estimation for Forward Planning Why comparative estimation works Planning Poker Affinity Estimation Prioritization Techniques Additional Product Backlog Prioritization Techniques Kano Analysis Theme Screening Release Planning and Tracking Progress Velocity Release Planning Tracking release progress

Certified Scrum Product Owner
Delivered In-Person in LondonFlexible Dates
£1,595

1 week Introduction to barbering

By TotalBarber Academy Limited

THIS COURSE IS DESIGNED FOR THOSE WISHING TO TEST THE WATERS AND SEE HOW THEY FEEL ABOUT JOINING THE BARBER LIFE.

1 week Introduction to barbering
Delivered In-PersonFlexible Dates
£890

Leadership Professional - Mastery Programme

By Mpi Learning - Professional Learning And Development Provider

Four half-day Leadership modules with mini work placed projects to bring the learning into action in the workplace.

Leadership Professional - Mastery Programme
Delivered in Loughborough or UK Wide or OnlineFlexible Dates
£1,995

Foundation Lip Augmentation Course

By Cosmetic College

Our foundation lip filler course is designed for learners wanting to enter the industry at a beginner level and specialise in lip augmentation. Our goal at the Cosmetic College is to deliver the highest quality training in dermal fillers using the safest and most up-to-date techniques. Our courses are carried out in small groups; This enables us to provide you with a training programme tailored to your needs, with more time and emphasis on the hands-on practical sessions. Course Prerequisites This course is suitable for those with or without a medical background. It is designed to provide the student with the ability to seek employment or start their own business upon qualification. At a minimum, students will be required to be qualified at least one of the following: Medically qualified as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months micropigmentation experience and Anatomy & Physiology Level 3 Please note that if your qualification does not appear above, we offer a fast track access course for those completely new to the industry.  Course Pre Study 40 hours of E-learning A series of online assessments 2 Days of Practical training Anatomy and physiology of the face Infection control Sharps and hazardous waste training First aid and anaphylaxis training Introduction to dermal filler injection techniques Elective and emergency dissolving Injection techniques practice Danger zones training Vessels, muscles, fat pads workshop Professional live demonstrations Legal requirements, obtaining consent with consultation techniques and documentation Practical training Clinical setup procedures Areas CoveredLips Professional KitDermal filler (Used for training) Numbing creamMassage gelChlorhexidine pre-injection wipesSterile treatment packsGlovesSurgical face masksSkin marker pencilsIce packConsultation forms

Foundation Lip Augmentation Course
Delivered In-PersonFlexible Dates
£1,250

Introduction to HTML and CSS

By Platform Training

This HTML course will provide you with an easy to follow, hands-on introduction to HTML and CSS, the basic coding languages which drive the internet. Participants will learn how to create an attractive and well-structured web page using basic HTML and CSS. This workshop is highly recommended for anyone wishing to learn how to create websites and also for people who already use applications such as Dreamweaver or WordPress and need more control over their web output.

Introduction to HTML and CSS
Delivered In-PersonFlexible Dates
£215

Certified Scrum Product Owner: In-House Training

By IIL Europe Ltd

Certified ScrumMaster®: In-House Training This course is an introduction to Scrum and the principles and tools required to be an effective Scrum Product Owner. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of the Scrum framework to different situations. Participants successfully completing this course earn a Certified Scrum Product Owner® (CSPO®) designation. The Scrum Alliance certification includes a one-year membership with Scrum Alliance. What You Will Learn You'll learn how to: Use the principles, practices, and tools required to be an effective Scrum Product Owner Make effective decisions regarding the application of the Scrum framework to different situations, including: Setting product vision and goals Chartering the project Writing user stories and structuring your product backlog Scaling the Product Owner Estimating for forward planning Applying prioritization techniques Planning and tracking release progress Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Process control models Incremental and iterative development Shifting the focus on product management Overview of the Scrum process Agile principles Lean principles Scrum Roles and Responsibilities Scrum roles Cross-functional teams Product Owner Responsibilities The Scrum Project Community What happens to my traditional role in Scrum? Chartering the Project Establishing a shared vision Elevator Statement Data sheets Product Vision Box Magazine Review / Press Release Product Backlog and User Stories Product uncertainty and progressive refinement User role modeling User Stories Product backlog characteristics Getting backlog items ready Slicing User Stories Using the product backlog to manage expectations Sprints Done and Scaling Done The Scrum process in detail Sustainable pace The Product Owner's role in each of the Scrum meetings Scaling the Product Owner Scaling Scrum Approaches to scaling the Product Owner Estimation for Forward Planning Why comparative estimation works Planning Poker Affinity Estimation Prioritization Techniques Additional Product Backlog Prioritization Techniques Kano Analysis Theme Screening Release Planning and Tracking Progress Velocity Release Planning Tracking release progress

Certified Scrum Product Owner: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,595

Assuring Quality Through Acceptance Testing

By IIL Europe Ltd

Assuring Quality Through Acceptance Testing It is also the business analyst's responsibility to confirm that the resulting solution developed by IT does, in fact, solve the defined problem. This is done first through testing, especially acceptance testing, and then through monitoring of the installed solution in the user community. It is the business analyst's job to define the business problem to be solved by IT. It is also the business analyst's responsibility to confirm that the resulting solution developed by IT does, in fact, solve the defined problem. This is done first through testing, especially acceptance testing, and then through monitoring of the installed solution in the user community. The business analyst is not only concerned with the testing itself, but also with the management and monitoring of the users doing the acceptance testing, and recording, analyzing, and evaluating the results. What you will Learn Upon completion, participants will be able to: Create a set of acceptance test cases Manage and monitor an acceptance test stage where users perform the testing Work with the development team in the systems testing stage Assess the solution once it is in the business environment Foundation Concepts The role of the business analyst An introduction to the BABOK® Guide BA roles and relationships through the project life cycle Introduction to assuring software quality through acceptance testing The Scope of IT Testing Overview of testing stages The testing process Testing documentation Pre-Acceptance Testing The BA's role in testing Early development testing stages (unit and integration) Late development testing stage (system) The Acceptance Test Stage - Part I (Planning, Design, and Development) Overview of user acceptance testing Acceptance test planning Designing user acceptance tests Developing individual user acceptance test cases Building effective user acceptance test scenarios The Acceptance Test Stage - Part II (Execution and Reporting) Operating guidelines Execution Reporting Post-Acceptance Testing Overview Project implementation Project transition (project closure) Production through retirement Testing Commercial Off-the-Shelf (COTS) Software Overview Selecting the software Implementing the software Summary What did we learn and how can we implement this in our work environments?

Assuring Quality Through Acceptance Testing
Delivered In-Person in LondonFlexible Dates
£1,495

Earned Value Management

By IIL Europe Ltd

Earned Value Management Earned Value Management (EVM) incorporates a set of proven practices appropriate for project or program management methodologies. These include integration of program scope, schedule, and cost objectives, establishment of a baseline plan for accomplishment of program objectives and use of earned value techniques for performance measurement during the execution of a program. Earned Value Management (EVM) incorporates a set of proven practices appropriate for project or program management methodologies. These include integration of program scope, schedule, and cost objectives, establishment of a baseline plan for accomplishment of program objectives and use of earned value techniques for performance measurement during the execution of a program. EVM provides a solid platform for risk identification, corrective actions, and management re-planning as may be required over the life of a project or program. The course emphasis is on the latest EVM principles and concepts in accordance with changes and guidelines for Earned Value Management in The Guide to the Project Management Body of Knowledge (PMBOK® Guide) and The Practice Standard for Earned Value Management published by the Project Management Institute. What you Will Learn You'll learn how to: Develop a project baseline, using an effective WBS Record actual project performance Calculate EVM measures Evaluate project performance based on EVM measures Respond to project variances Integrate EVM and risk management Determine how EVM will add value to your organization Develop an EVM implementation plan for your organization Getting Started Introductions Course structure Course goals and objectives Expectations Foundation Concepts Introduction to Earned Value Management (EVM) Benefits of EVM EVM Process Overview Applications of EVM Creating a Work Breakdown Structure Reviewing WBS concepts Reviewing WBS development process (decomposition) Using a WBS to support EVM Building a Project Baseline Defining a project baseline Developing a project baseline Using a project baseline Recording Actuals Recording actuals overview Collecting data for actual project performance Determining earned value - various methods EVM Performance Measures Using current status measures Using forecasting measures Analyzing EVM measures EVM and Risk Management Integrating EVM and Risk Management Using EVM measures in the risk register Exploring how EVM can facilitate reserves management Drawing down contingency reserves Responding to Variances Introduction to variances Process for responding to variances Response options Reporting Project Performance EVM reporting overview Meeting EVM reporting needs Addressing EVM reporting challenges Implementing an EVMS Defining EVMS requirements EVM for Agile projects Tailoring the EVMS Summary and Next Steps Review of content Review of objectives / expectations Personal action plan

Earned Value Management
Delivered In-Person in LondonFlexible Dates
£1,495