1593 Courses in Sheffield delivered Live Online

Access Introduction generally navigate through Access Database, get data fast, update data records by entering, update data and delete data. Run available report, use available forms, create simple forms and reports via wizards. This style tuition helps to maximise the value that you get from the day.

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. Tailored in company 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

PARTICIPANTS WILL ENGAGE IN A TRAINING SESSION TO IMPROVE AND REFINE THEIR RÉSUMÉS. OPPORTUNITIES TO ENGAGE IN ONE-ON-ONE RÉSUMÉ BUILDING & REVIEW SESSIONS CAN BE OFFERED AS WELL. It’s time to move on—or maybe you’ve been “in transition” for too long. Either way, you need some input so that you know what others see when they look at your résumé, and what they hear when they interview you. Participants will engage in a training session to improve and refine their résumés. Opportunities to engage in one-on-one Résumé Building & Review sessions can be offered as well. Part I Data Collection and Organization – assessing work/activities and IMPACT (results) Success Story Format (Situation, Action, Results) Writing With Impact – how to tie actions to results Choosing The Right Words – transferable skills and powerful words Sales 101 – How will these skills benefit the hiring person’s organization? Part II UB4I Writing (“YOU”/ “YOUR,” not “I,” “me,” “my”) Reference list Principles of networking Cover Letter and Résumé Formats – margins, font, type size, small caps, etc. Role Play – Mock Interviews Participants will be able to: Create a complete and correct résumé, a marketing device to attract attention, generate interest, describe accomplishments, and invite contact. Discover, correct, and improve self-marketing messages, leading to a systematic assessment of specific work-related skills. Examine transferable skills and increase personal alignment with prospective organizational mission and goals. Online Format—Résumé Writing, Networking, & Interviewing Workshop 4-hour interactive virtual class. Register for this class and you will be sent ONLINE login instructions prior to the class date. After a two-day seminar, our attendees remained in their seats wanting more from Dr Atkins. His direct, yet challenging approach to presenting topics seemed to mesmerize the participants. Many very lively discussions were part of our workshop’s context. Personally, I am very interested in re-booking this type of experience every year for new leaders to undergo! Michael J. Whitlock, Director of Fay Corey Union & ConferencesSUNY Cortland

Historical Association webinar series: Practical approaches to disciplinary concepts in primary history Presenter: Emmy Quinn This session will explore introducing cause and consequence to students in both explicit and implicit ways. The session will show specific events and unit ideas which will help children grasp the concepts and show teachers how to introduce ideas of long and short term. To use your corporate webinar offer for this webinar please complete this form: https://forms.office.com/e/95945xGxdh

Unconscious biases are social stereotypes about certain groups of people that individuals form outside their own conscious awareness. Course Category Relationships Racial bias Description Unconscious biases are social stereotypes about certain groups of people that individuals form outside their own conscious awareness. Everyone holds unconscious beliefs about various social and identity groups and these biases stem from one’s tendency to organise social worlds by categorising. So join us on a reflective, engaging day where we tackle real life issues in depth and create action plans for future practice. Learning Objectives Increased confidence and understanding regarding Unconscious Bias Action planning New skills and processes to strengthen the inclusion of diverse groups Opportunity to reflect and understand more deeply on what might be happening due to unconscious bias’ Who Is It For? Any professional, carer or parent Course Content We will explore what is known about:Restorative JusticeDiversityAttitudes and ValuesProfessional dutiesReflective practice

The COLP role goes beyond just ensuring your firm follows the rules in the SRA Standards and Regulations, it also comes with a personal accountability factor that demands your attention. Fear not! This 3 hour course will usher you through the intricacies of being a COLP, ensuring you not only meet but excel in your regulatory obligations.  The course will cover: Navigating the Regulatory Landscape: Understanding the Framework for COLPs Dive into the intricate regulatory framework that Compliance Officers for Legal Practice (COLPs) operate under. Shouldering the Responsibility: Unpacking the Duties of a COLP Explore the multifaceted responsibilities that come with the role of a COLP. Choosing the Right Leader: Identifying the Ideal COLP Candidate Learn the criteria for selecting the most suitable individual to take on the crucial role of COLP. Cracking the Codes: Key Elements of Codes and SRA Principles Delve into the essential components of the Codes and SRA Principles that form the backbone of legal compliance. Building a Robust Foundation: Understanding Compliance Systems for All Firms Explore the concept of compliance systems, what they entail, and why every firm should have one in place. Reporting Matters: Recognising 'Serious' Issues, SRA Enforcement Strategy, and Reporting Protocols Uncover the definition of 'serious' matters, grasp the SRA Enforcement Strategy, and gain practical insights on making effective reports to the SRA. Paper Trails Matter: Effective Record Keeping, Including Non-material Breaches Master the art of comprehensive record-keeping, including strategies for recording non-material breaches, and understand why it's integral to compliance. Personal Liability: Understanding and Mitigating Risks Navigate the landscape of personal liability for COLPs and develop strategies to mitigate associated risks. Staying Ahead: Keeping Abreast of Regulatory Changes and Guidance Develop effective strategies for staying up to date with dynamic regulatory changes and evolving guidance. Planning for Compliance: Crafting a Robust Strategy, Assessing Risk, and File Reviewing Formulate a comprehensive plan for tackling compliance, including risk assessment, maintaining risk registers, and implementing effective file reviewing. Across the Board: Legal and Regulatory Compliance Areas Every COLP Must Master Gain a high-level overview of crucial legal and regulatory compliance areas, including AML, transparency rules, and other pivotal aspects that demand the attention of all COLPs. Target Audience This online course is suitable for those new to the COLP role, or those supporting the COLP and for those that would like a refresher of the role and their responsibilities. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

Total PHP training course description PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions. What will you learn Create dynamic web sites using PHP. Write PHP programs. Debug PHP programs. Examine existing code and determine its function. Total PHP training course details Who will benefit: Anyone creating dynamic web sites. Prerequisites: Software development fundamentals Duration 3 days Total PHP training course contents What is PHP? PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues. A first PHP web page A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML. PHP forms HTML forms, taking values from forms. PHP and HTML Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript. Variables operators and expressions Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables. Operators Arithmetic, logical, relational, Boolean, others. Control statements Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit. Functions Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name. Arrays Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions. String handling What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs. PHP and databases Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling. File I/O Opening, reading, writing files. Permissions, ownership, locking, directories. PHP, cookies and sessions State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs. PHP and email Emailing from servers, attachments. Objects OOP, PHP classes, constructors, instances.

Emotionally Focused Therapy (EFT) is a highly effective form of couples counseling that addresses emotional needs and attachment styles. EFT is ideal for resolving issues such as anger, loss of trust, and emotional injuries. This therapy helps couples form secure bonds, fostering long-term relationship stability. Key areas: emotional needs, attachment styles, anger issues, trust loss, secure bonds 3 x 1 hour sessions

Sales and trade exist because people need and are looking for that which is better than what they have. Sometimes, they don’t even know that they have a need. The critical piece of this process is “connecting the dots.” We must demonstrate that we have listened respectfully, and, as experts, show how the needs are tied directly to our answer. Just because they have a need and we have a solution doesn’t mean that it’s a guaranteed sale. Connecting their needs to our solution is precisely what the Sales Presentation Skills class is all about. Outcomes – Participants will be able to: Research and understand each unique customer to demonstrate expertise; Conduct productive meetings to discover useful information to formulate the most effective solution(s); Propose plans that are fully aligned with the target’s situation and needs; Increase abilities to engage and motivate the prospect/client through compelling presentations; Convey emotional intelligence enthusiasm and sincerity to get client buy-in; Strengthen professionalism through dynamic story-telling, elevating the level of rapport; and Create positive messages even from negative, modeling a problem-solving, can-do attitude for the audience.   Online Format—Sales Presentation Skills is a 4-hour interactive virtual class. Register for this class and you will be sent ONLINE login instructions prior to the class date. Overall, your professionalism, your teaching style, and the content of the course kept it interesting and easy to follow. We believe in what you have taught us, having tried it first hand, I can honestly say, your course works; your methods and ideas have proven themselves. I look forward to working with you again and again in the future. Alan M. Kriegstein, PresidentALA Scientific Instruments, Inc.

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