40885 Courses

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

This very practical one-day IACCM-approved programme enables participants to manage the process of commercial contracting and contract management effectively and efficiently to ensure value for money, improved service, and appropriate relationships. It covers a wide range of contract types in terms of risk and value. The programme empowers participants with the tools and techniques needed to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the total process of managing contracts Exploit opportunities to extract even more added value Develop appropriate relationships with contractors Understand and use a range of contracting strategies and options Measure and improve contract performance Understand the impact of legislation on contract performance 1 Welcome Introductions Aims and objectives Plan for the day 2 Contract management An overview of the contracting process, mapping the 'territory' 3 Contract managers Skills Knowledge Attributes Responsibilities 4 Critical success factors Defining successful outcomes Effective stakeholder engagement Creating a shared vision of the outcomes 5 Placing contracts How to develop an effective specification and scope of work documents How to develop a robust contracting strategy Appropriate types of contract 6 Customers and stakeholders Customer and stakeholder analysis Managing expectations and the 'shared vision' concept to ensure customer co-operation, satisfaction, and delight 7 Working with suppliers Creating and developing commercial relationships Types of relationship How to manage difficult relationships Contractor motivational issues How to use incentives 8 Negotiation and related skills Introduction to key negotiation skills Persuading and influencing skills to work with stakeholders to improve outcomes for all 9 Dealing with change Claims and variations How to challenge contractor claims and requests for variations by making use of contractual terms Specifications to prevent false claims 10 Performance improvement How to measure and improve contractor performance Developing KPI systems Using contractual terms and conditions and basic legal principles 11 Contract close The importance of effective contract close processes 12 Close Review of key learning points Personal action planning

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

IELTS 7+ Band with 5 STAR INSTITUTE,  Best IELTS Preparation Institute in Islamabad and Rawalpindi. Every Monday a new batch of classes starts. Morning, Afternoon, and Evening time classes are available. The time duration of this course is 1 month, after the Preparation for the IELTS, It will be Institute's responsibility to register you for the exams.  The time duration of the class is one & half hours. In a month there are 2 seminars are also held in our Institute. One is with the British Council and one is with a Consultant, to facilitate the student about the further plan. You can see our previous student's results videos on Youtube Channel. Just write there. 5-STAR INSTITUTE ISLAMABAD and subscribe to our Youtube channel.  Our Previous student record is most of the students get 7+ Band. Listening Reading Writing Speaking Let's come and join us. Regard If you want to check our institute. Write on Google. 5 STAR INSTITUTE ISLAMABAD.  You can come to our Institute through Google Maps easily. You can watch the different student's IELTS videos on our YouTube channel. Just write there. 5 STAR INSTITUTE ISLAMABAD 

Your first steps in Floorwork through our Smart Methodology.

Formally Safeguarding Children Level 1: One Day Course 10am - 3.30pm Working Together to Safeguard Children 2018 & Keeping Children Safe in Education (2022) Updated This Course can also be run within your organisation for your staff group at a reduced cost contact us for a quote or if you have any other questions about this course talk to an adviser now online.

Audit, Compliance Audit, Road Haulage Audit, Transport Audit, Traffic Commissioner Audit, DVSA Audit

Duration 2 Days 12 CPD hours This course is intended for This in an intermediate-level Java development course geared for students experienced with Java and Spring programming essentials. This course does not cover Java or Spring development basics. Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in core Cucumber and web testing skills, coupling the most current, effective techniques with the soundest industry practices. Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will: Learn the request-response cycle of REST requests Implement a REST controller using Spring Map URLs to service endpoints Use Spring's template class to develop a REST client Bootstrap a Spring REST applications Return different media types for a service Setting the response headers Discuss Exceptions and HTTP Status codes Handle exceptions thrown by a service Spring REST focuses on providing an understanding of the fundamental principles and technologies that are used in the development of RESTful services and clients. This understanding is critical to being able to diagnose, troubleshoot, tune, and perform other lifecycle activities.Working with Spring REST is a two-day, fast-paced coding course geared for experienced developers who have prior working knowledge of Java. Throughout the course students learn the best practices for writing Restful services in Java using Spring Boot. The course provides an in-depth view of the APIs provided by Spring to develop both the REST service and the REST client. Implementing REST with Spring REST principles Introduction to RESTful Services in Spring Introduction to REST Clients in Spring Bootstrapping the REST application Content Representation Implementing the REST Service Error Handling Security and RESTful Services Securing Untrusted Input Defending RESTful Services Additional course details: Nexus Humans Working with Spring REST (TT3358) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Working with Spring REST (TT3358) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for individuals in a variety of job roles whose primary responsibility is not project management, but who manage projects on an informal basis; who contribute as members of a project team; or who wish to incorporate project management practices into their personal work. It is also beneficial for anyone who is considering a career path in project management and desiring a complete overview of the field and its generally accepted practices. Overview In this course, you will identify the elements of sound project management and apply the generally recognized project management practices to successfully manage or participate in projects. You will: Identify the key processes and requirements of project management. Initiate a project. Use a Predictive approach to plan for time and cost. Use an Adaptive approach to plan a project. Plan for project risks, communication, and change control. Manage the execution of a project. Close a project. This course teaches the fundamentals of project management and its underlying structure and elements, including project phases, project life cycles, stakeholders, and areas of expertise. These, coupled with the ability to identify the project management processes that are recognized industry wide as good practice, will help you to apply effective project management techniques to improve the efficiency of your projects and ensure their success. This course is designed to cover various project management approaches and is not intended to focus on a single methodology or framework. Lesson 1: Getting Started with Project Management Topic A: Identify the Characteristics of a Project Topic B: Identify the Project Approach Topic C: Identify the Leadership Roles in a Project Lesson 2: Initiating a Project Topic A: Create a Project Scope/Vision Statement Topic B: Identify the Essential Skills for a Project Team Topic C: Identify the Risks to a Project Lesson 3: Planning for Time and Cost in Predictive Projects Topic A: Create a WBS Topic B: Create a Project Schedule Topic C: Determine Project Costs Lesson 4: Planning for Adaptive Projects Topic A: Create Epics and User Stories Topic B: Build a Product Backlog Topic C: Create an Initial Release Plan Topic D: Conduct a Sprint Planning Meeting Topic E: Replan the Project Lesson 5: Planning for Project Risks, Communication, and Change Control Topic A: Analyze the Risks to a Project Topic B: Create a Communication Plan Topic C: Develop a Change Control Plan Lesson 6: Managing a Project Topic A: Begin Project Work Topic B: Execute the Project Plan Topic C: Track the Progress of an Adaptive Project Topic D: Report Project Performance Topic E: Implement Change Control Lesson 7: Closing a Project Topic A: Close a Sprint, a Release, or an Adaptive Project Topic B: Close a Predictive Project Topic C: Create a Final Report

Duration 5 Days 30 CPD hours This course is intended for This is an intermediate course for people who need to write and maintain Rexx programs in the z/OS system environment. Overview The objectives of this course are as follows:- Write programs using the Rexx language- Use various data parsing techniques- Use built-in Rexx functions- Create user-defined internal and external functions and subroutines- Issue host commands from within Rexx execs- Code programs that read and write data sets- Use instructions and commands that manipulate the data stack- Use Rexx debugging tools- Write error-handling routines This course is designed to teach you the basic skills required to write programs using the REXX language in z/OS. The course covers the TSO extensions to REXX and interaction with other environments such as the MVS console. Day 1 Unit 1 - Introduction Unit 2 - Getting started with REXX (start) Lab exercise 1 Unit 2 - Getting started with REXX (finish) Lab exercise 2 Unit 3 - Programming in REXX (start) Day 2 Lab exercise 3 Unit 3 - Programming in REXX (finish) Lab exercise 4 Unit 4 - Functions and subroutines (start) Lab exercise 5 Day 3 Unit 4 - Functions and subroutines (finish) Lab exercise 6 Unit 5 - Debugging and error handling Lab exercise 7 Unit 6 - Executing host commands Lab exercise 8 Day 4 Unit 7 - Compound variables and the data stack Lab exercise 9 Unit 8 - Reading and writing data sets in REXX Lab exercise 10 Unit 9 - The parse instruction Day 5 Lab exercise 11 Unit 10 - Using REXX: REXX compiler, REXX in batch, MVS console commands Lab exercise 12 Additional course details: Nexus Humans ES52 IBM z/OS REXX Programming Workshop training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the ES52 IBM z/OS REXX Programming Workshop course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.