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.
Venepuncture and cannulation course Venepuncture training for healthcare professionals Cannulation skills development Intravenous access techniques Blood sample collection training Infection control in venepuncture Hands-on venepuncture practice Cannula insertion training Nursing revalidation hours CPD accredited course Healthcare professional skills development Venepuncture and cannulation procedures Venepuncture certification program Intravenous catheter insertion Best practices in venepuncture Patient assessment for venepuncture Troubleshooting venepuncture complications Venepuncture and cannulation simulation Real-life venepuncture scenarios Healthcare career advancement with venepuncture skills
Broadband access training course description ADSL is a broadband technology providing fast Internet access (amongst other applications) over existing telephone lines. This course covers an overview of the DSL family, what ADSL is through to how ADSL works. What will you learn Describe what ADSL is. Describe how ADSL works. Describe the ADSL architecture. Recognise the limitations of ADSL. List the elements required for an ADSL installation. Broadband access training course details Who will benefit: Network engineers and anyone who will be working with ADSL. Prerequisites: Intro to data communications & networking Duration 2 days Broadband access training course contents What is ADSL? Broadband definitions, OSI layer 1, ADSL services, WANS. ADSL features: always on, point to point, Asymmetric, speeds. ADSL benefits, xDSL family, standards, history, example DSL forum documents. ADSL architecture The big picture, The PSTN and telephones, Digital and analogue, PSTN and modems, ADSL vs. modem speeds, Block 1: Customer premises, Block 2: The last mile, Block 3: The exchange, Block 4: the core network. Customer premises Splitters, micro filters, splitter architectures, Splitterless ADSL, ADSL modems, USB, ADSL routers. The local loop ADSL PHY, Some basics, ADSL margins, speed implications, distances, RADSL, Line testing, whoosh tests, line coding, multiple channels, FDM, echo cancellation, Modulation: AM, FM, PM, QAM, QAM constellations, DMT, CAP, Framing, Superframes, fast data mode, interleaved mode, RADSL revisited. The exchange Local exchange ADSL items, DSLAMs, ADSL racks, Contention. The core network The role of the core network, ATM, ATM VPI/VCI, ATM cells, ATM layers, AAL5, RAS, Home gateways. ADSL and the higher layers Layer 2 choices, PPPoA, PPP, CHAP, Layer 4 and above, ADSL and ATM. Installing and configuring ADSL Choosing providers, line activation, hardware requirements, Configuring layer 1 and layer 2, Configuring IP. Summary ITU ADSL standards
Osteopathic palpation of the involuntary mechanism and paediatric/developmental anatomy of the cranium, membranous/fascial & fluid systems Course Title: OCC Access Course Dates: 14, 15 and 22 September 2024 (minimum 6 contact hours per day) Location: OCC, Canopi Building 7 - 14 Great Dover Street, London, SE1 4YR Osteopaths studying on our postgraduate courses need to have acquired hands-on skills beyond their undergraduate training. Our Access Course provides tailored training to introduce & nurture palpation of the involuntary mechanism and paediatric/developmental anatomy of the cranium, membranous/fascial & fluid systems to prepare less experienced osteopaths for further paediatric training. Our experienced faculty will deliver this 3-day course, which enables osteopaths to reach the required standard for entry onto the OCC courses and does not limit our osteopaths to any one technical style. These days can also be useful to osteopaths who want to refresh or enhance previously acquired skills & can be attended as individual days if space permits. Course Content: Day 1 - Saturday 14th September – Vault & base osteology, applied anatomy & motion – RTM & venous sinuses – Sacral /pelvic anatomy & motion Day 2 - Sunday 15th September – SBS patterns, theory & palpation – Fascia – Fluid – CNS Day 3 - Sunday 22nd September – Viscerocranium anatomy, osteology & motion – Principles of treatment – Intra oral techniques – Condylar parts osteology, applied anatomy & treatment All 3 days will be delivered in small groups to facilitate individual learning and needs. Most of the teaching will take place at the tables with very little lecture material & will include demonstrations interwoven with appropriate practical sessions. This is designed to deliver theory but in a very practical hands-on way. In order to provide this level of supervision numbers will be limited, and places are allocated on a ‘first come first served’ basis. For more info call 0208 875 5291 or email educationregistrar@occ.uk.com Cancellation Policy The OCC/FPO reserves the right to postpone this course if circumstances change. Eventbrite’s processing fee is non-refundable, so in the event that the course is cancelled by the OCC/FPO, all fees (excluding Eventbrite’s fee) will be refunded. Should circumstances mean that you have to cancel your place on this course, the OCC/FPO regrets to inform that no refunds can be given unless we are able to re-sell your place. Please note, the OCC/FPO does not accept responsibility for any expense you incur (such as travel and accommodation costs), so please do consider this before registration. occ.uk.com/continuing-professional-development The Osteopathic Centre for Children is the clinical arm of the Foundation for Paediatric Osteopathy. Registered Charity: 1003934
We will work closely with you, sharing insights and putting into practice core financial modelling techniques as you model a case study based on a business acquisition. You will learn to create the step-by-step calculations required to forecast the three primary financial statements — income, balance sheet, and cash flow. More advanced topics will include a valuation of the equity in the case study company (based upon the present value of forecast dividends). Participants can expect detailed instruction and hands-on practice with a focus on developing and working with a financial model that they have built from scratch. Post-course, you will receive full and ongoing access to the online version of the course as well as online support from our team of modelling experts.
Gain the knowledge and skills to safely insert and manage peripheral IV cannulas with our training course for healthcare professionals. Ideal for nurses, medical personnel, and other practitioners.
Our Central Venous Access Device Training course is facilitated by registered clinicians with extensive experience.
My Virtual Surgery - Coronary Masterclass A Dry-Lab Masterclass in Coronary Anastomosis A NEW LSOC Course! Led by My Virtual Surgery Founder, and Internationally - renowned coronary surgeon, Professor Paul Sergeant, and expert senior Cardiac Surgeon, Mr Alex Shipolini. This course provides a comprehensive masterclass in coronary anastomosis, featuring innovative anastomotic techniques, specialised surgical ergonomics, and expert guidance. PLEASE REVIEW THE IMPORTANT INFORMATION BELOW BEFORE PURCHASING YOUR TICKET (including regarding pre-course learning). When: Saturday, 9th August 2025. Where: St.Bartholomew's Hospital, London. Required Equipment: Needle holder and forceps for pre-course learning (see below). Ticket Types: Course Only This will provide access to the elements detailed below. This does NOT include the costs of instruments. Please purchase this ticket if you have access to a set of needle holders and thin-tipped forceps at home (ideally a Castroviejo needle holder and Geralds/Ring tip forceps). Course + Instruments This will provide course access + procurement and shipping of a Castroviejo needle holder and Geralds/Ring tip forceps, for you to keep. Please purchase this ticket if you would also like to purchase instruments. Cost includes the course cost, instrument costs, inc. shipping, processing and handling fees. All Tickets include: Access to pre-course training with the MyVirtualSurgery Programme. All day face-to-face seminar on coronary artery surgery from coronary experts. Lifetime access to MyVirtualAnastamosis - the MVS Coronary Anastomosis platform, including direct feedback at home from Prof Sergeant, and ongoing virtual learning. Additionally included in the Course and Instrument Ticket: Procurement of Castroviejo Needle Holder and Forceps to support home training. Sales Open: 22nd June, 7pm Please note: Mandatory Pre-Course Learning Pre-Requisites Pre - Course Learning Deadline All participants must complete Mandatory Pre-Course Learning before the course begins. To ensure we can prepare adequately for the course, including confirming the number of attendees who have completed the pre-course training, a fixed deadline of Monday 28th July will be set for all participants to finish the pre-course training. Not completing the pre-course learning by Monday, 28th July, will lead to forfeiting your place in the course, and no refunds will be issued. Pre-Course Learning Instruments This pre-course learning requires access to a needle holder and thin-tipped forceps. We strongly recommend using a Castroviejo needle holder along with either Geralds or Ring Tips forceps, as this platform is designed for these instruments, and alternatives may not provide as comprehensive training. Furthermore, these are essential instruments for cardiac surgery and will be used during the course. These instruments will also be required for the remainder of the steps on the platform. If you cannot independently acquire a needle holder and forceps, LSOC can purchase a Castroviejo needle holder and a pair of forceps on your behalf and send them directly to you. In this case, please make sure to purchase a Course + Instruments Ticket, to include the cost of these instruments. We look forward to you joining us on our newest course soon!
The IRATA Level 1 is the entry level into the rope access industry. An IRATA Level 1 technician will be able to perform a range of rope access manoeuvres and have an understanding of the current legislation. An IRATA Level 1 is required to be supervised by an IRATA Level 3 technician.
Securing UNIX systems training course description This course teaches you everything you need to know to build a safe Linux environment. The first section handles cryptography and authentication with certificates, openssl, mod_ssl, DNSSEC and filesystem encryption. Then Host security and hardening is covered with intrusion detection, and also user management and authentication. Filesystem Access control is then covered. Finally network security is covered with network hardening, packet filtering and VPNs. What will you learn Secure UNIX accounts. Secure UNIX file systems. Secure UNIX access through the network. Securing UNIX systems course details Who will benefit: Linux technical staff needing to secure their systems. Prerequisites: Linux system administration (LPIC-1) Duration 5 days Securing UNIX systems course contents Cryptography Certificates and Public Key Infrastructures X.509 certificates, lifecycle, fields and certificate extensions. Trust chains and PKI. openssl. Public and private keys. Certification authority. Manage server and client certificates. Revoke certificates and CAs. Encryption, signing and authentication SSL, TLS, protocol versions. Transport layer security threats, e.g. MITM. Apache HTTPD with mod_ssl for HTTPS service, including SNI and HSTS. HTTPD with mod_ssl to authenticate users using certificates. HTTPD with mod_ssl to provide OCSP stapling. Use OpenSSL for SSL/TLS client and server tests. Encrypted File Systems Block device and file system encryption. dm-crypt with LUKS to encrypt block devices. eCryptfs to encrypt file systems, including home directories and, PAM integration, plain dm-crypt and EncFS. DNS and cryptography DNSSEC and DANE. BIND as an authoritative name server serving DNSSEC secured zones. BIND as an recursive name server that performs DNSSEC validation, KSK, ZSK, Key Tag, Key generation, key storage, key management and key rollover, Maintenance and resigning of zones, Use DANE. TSIG. Host Security Host Hardening BIOS and boot loader (GRUB 2) security. Disable useless software and services, sysctl for security related kernel configuration, particularly ASLR, Exec-Shield and IP / ICMP configuration, Exec-Shield and IP / ICMP configuration, Limit resource usage. Work with chroot environments, Security advantages of virtualization. Host Intrusion Detection The Linux Audit system, chkrootkit, rkhunter, including updates, Linux Malware Detect, Automate host scans using cron, AIDE, including rule management, OpenSCAP. User Management and Authentication NSS and PAM, Enforce password policies. Lock accounts automatically after failed login attempts, SSSD, Configure NSS and PAM for use with SSSD, SSSD authentication against Active Directory, IPA, LDAP, Kerberos and local domains, Kerberos and local domains, Kerberos tickets. FreeIPA Installation and Samba Integration FreeIPA, architecture and components. Install and manage a FreeIPA server and domain, Active Directory replication and Kerberos cross-realm trusts, sudo, autofs, SSH and SELinux integration in FreeIPA. Access Control Discretionary Access Control File ownership and permissions, SUID, SGID. Access control lists, extended attributes and attribute classes. Mandatory Access Control TE, RBAC, MAC, DAC. SELinux, AppArmor and Smack. etwork File Systems NFSv4 security issues and improvements, NFSv4 server and clients, NFSv4 authentication mechanisms (LIPKEY, SPKM, Kerberos), NFSv4 pseudo file system, NFSv4 ACLs. CIFS clients, CIFS Unix Extensions, CIFS security modes (NTLM, Kerberos), mapping and handling of CIFS ACLs and SIDs in a Linux system. Network Security Network Hardening FreeRADIUS, nmap, scan methods. Wireshark, filters and statistics. Rogue router advertisements and DHCP messages. Network Intrusion Detection ntop, Cacti, bandwidth usage monitoring, Snort, rule management, OpenVAS, NASL. Packet Filtering Firewall architectures, DMZ, netfilter, iptables and ip6tables, standard modules, tests and targets. IPv4 and IPv6 packet filtering. Connection tracking, NAT. IP sets and netfilter rules, nftables and nft. ebtables. conntrackd Virtual Private Networks OpenVPN server and clients for both bridged and routed VPN networks. IPsec server and clients for routed VPN networks using IPsec-Tools / racoon. L2TP.