325 Courses in Leeds

We run regular Emergency First Aid at Work public courses or we can bring our training to you. Includes free annual refresher video training. Ideal for low risk organisations.

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

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 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. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Certificates Certificates Certificate of completion Digital certificate - Included

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

About the technique: The Kusum Modak Method, previously referred to as Ayurvedic Yoga Massage (AYM), Traditional Ayurvedic Massage, or simply Ayurvedic Massage, is now named in honor of its creator. This change was introduced with the establishment of the Modak Institute, founded by Kusum Modak to preserve her legacy with integrity and authenticity for future generations. This contemporary method combines traditional Ayurvedic Massage with Yoga, developed through Kusum Modak’s studies with her teachers, Limaye and B. K. S. Iyengar, in Pune, India. The therapy focuses on activating breath, circulation, and vital energy through deep touch using hands and feet, along with tractions and stretching maneuvers. Treatments are conducted on an orthopedic mat using vegetable oil and a natural powder called Vekhand, derived from a root known in the West as Calamus. Course Information: Course Structure: Over 10 days, students will gain the knowledge and skills to practice the Kusum Modak MethodSM and become officially certified as bodywork therapists by the Modak Institute. The program includes: Students will cultivate a therapeutic perspective and build confidence in applying the technique. This course follows the updated guidelines set forth by Kusum Modak through the Modak Institute. Content: Total Hours: 80 hours of practical classes + 4 hours online + 12 hours assessment Duration: 10 days (in person classes) Dates: June 3rd to 7th and June 10th to 14th, 2025 Schedule: 9:00 AM to 1:00 PM and 2:00 PM to 6:00 PM Course Location: Roots of Respect, 16 Blenheim Terrace Woodhouse LS2 9HN United Kingdom Hands-on practical exercises Detailed technical understanding of the 118 maneuvers Dedicated time for questions, reviews, and session exchanges Introduction to the basics of the technique (structure & practice); Kusum Modak MethodSM history and influential contributors; Introduction of Ayurveda Principles; The elements of the Kusum Modak MethodSM - AYTM The steps of the therapy sequence; Learning to warm up the muscles; Use of hands and feet (walking on the back); Understanding the quality of the touch to perform Kusum Modak MethodSM; Using therapy props (why and when to use them); Manoeuvres and stretching – how to apply and its variations; Synchronisation of the pressure and breath; Learning to set up a 1-hour sequence (which is the original duration) that will serve the needs of each client; Applied anatomy to the technique and subtle anatomy, pathology and application of the studied content; Client Assessment protocols. Why the medical history form is essential?; Contraindications; Postural correction and student welfare practices (preparing the body for delivery) Assessment: We offer complementary activities designed to provide a deeper understanding of the Method and to help you develop a more precise approach to your practice. To be approved and certified, you must: You will receive clear instructions and guidance to help you succeed, as well as detailed information about the evaluation criteria. The 4 hours of online activities include complementary lectures and related assignments. - Anatomy - Demystifying the Kusum Modak Method - Holistic Medical Systems - SOAP notes and Health History form Certification: You have two options: Review with Q&A Supervised Practice (individual correction, gaining accuracy) How to maintain health + wellbeing as a bodywork therapist. Attend 100% of the in person classes. Submit 10 case studies on the same person, including reports for 10 SOAP notes. Provide a video recording of the final session. MODAK INSTITUTE CERTIFICATE: The Modak Institute certificate is awarded to students upon successful completion of the course, which includes final assessment activities to be submitted within 60 days after the in person training. This certificate is issued by the Modak Institute, the only institute officially authorized and endorsed by Master Kusum Modak to represent her method. It validates that students are fully qualified to work professionally with Prerequisites: While no formal prerequisites are required, physical, mental, and emotional health are essential to participate in the intensive activities. Students will also develop awareness to their clients’ needs and enhance their own mindfulness during practice. Training Price: Modak Institute Certificate: 1650 GBP Level 3 Diploma Kusum Modak Method: + 295 GBP Payment Plan 1 - 100% Payment upfront with discount (50 GBP off) until March 15th 2 - 50% deposit - 50% until May 20th 3 - 4x (Feb, Mar, Apr, May) 4 - 5x (Feb, Mar, Apr, May, Jun) Please feel free to reach out if you need to arrange your payments differently. Cancellation Policy the Kusum Modak MethodSM and ensures their eligibility to obtain therapist insurance, providing recognition and support to practice as certified therapists. Once your final assessment is evaluated and approved, your certificate will be issued and sent directly to your email. Each certificate includes a unique digital code, enabling easy verification of your credentials and affiliation worldwide through Modak Institute website. MODAK INSTITUTE CERTIFICATE + LEVEL 3 DIPLOMA KUSUM MODAK METHOD: Same process as described above + Students may request the UK Level 3 Diploma Kusum Modak Method Certificate for an additional fee of 295 GBP, which requires completing three additional online courses (150 hours) to meet accreditation requirements. The student must request this certificate option at the time of registration. What’s Included: About the teachers: Purnima Full refundable with in two months in advance Partial refundable 50% in a month before starting the training After that is a non-refundable payment. 84 hours of structured and methodically designed training (80 in person + 4 online). Note: the student need to reserve plus 12 hours for assessment. Modak Manual, including photos of all maneuvers and additional insights into the method’s history and references. Official Modak Institute Certification. Access to video lectures. Oil and powder for use during the course. One year of membership in the Modak Institute, including: Participation in an online plataform Access to official graphic materials for promotional use Inclusion in the Modak Institute’s agenda for work promotion Exclusive Q&A WhatsApp group moderate by Purnima and Julia.

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

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.

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

Construction Project Manager 2 Days Training in Leeds

Construction Project Manager 2 Days Training in Wakefield