17809 Courses delivered Online

This full course and exam package is designed for those working on construction sites and is a requirement for those wishing to apply for a CSCS Green Card. In accordance with CITB anyone who is a labourer on a construction site must be a CSCS Green Card Holder.In this package you will get: 100% online training, 120 minutes course plus online assessment Accredited Online Invigilated Exam by ETA Awards Stop & start at anytime No time limit Target Audience The course is aimed at people in the Construction Industry or want to get a job in the Construction Industry. Course Description Each year in the UK, people are killed, injured and suffer work-related illnesses while carrying out their jobs. So Health & Safety is a significant concern. The government, employers and workers all have an essential role to play in reducing deaths and accidents and preventing ill-health at work. This RQF Level 1 Health & Safety in a Construction Environment online course and exam package provides you with a qualification in its own right, it will also form part of your CSCS green card application. The course starts with an introduction to the legal aspects of health and safety before covering the basics of risk assessment and safe working practices. It then goes into detail to cover the most common hazards encountered in construction environments from Working at Height and Respiratory Hazards to electrical and chemical hazards. Advantages This package, Level 1 Health and Safety in a Construction Environment - online training and Accredited Online Invigilated Exam is aimed at people starting out in the construction industry and can be used as part of their induction process, as preparation for the level 1 award in Health and Safety in a Construction Environment or as part of CSCS green card application. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training in around their work and personal life. Further Progression For more detailed information on key health and safety issues we offer a wide range of courses including Asbestos Awareness, Manual Handling, Electrical Safety, COSHH, Working at Height, Risk Assessment and many more. Online Invigilated Exam We provide you access to our online invigilated examination which can be taken anywhere. Our market leading examination system delivers the final assessment direct to you via the internet, invigilated using screen sharing and web cam, allowing to receive your accreditation quicker and easier without the stress and hassle of visiting a training and exam centre. As a UK Registered Learning Provider, our online exam is fully accredited by ETA Awards Process from taking the course to get the certificate Candidate completes the Online Level 1 Health and Safety in a Construction Environment course If a pass is achieved the candidate is issued with an informal certificate Candidate logs into the exam page and are asked to fill out an exam registration form and given a 2-week window in which they can sit the exam. The system will not allow you to choose a date earlier than 72 hours from when you received the informal certificate. After the 72 hours, instructions are emailed to candidate to set up the proctor online recording system. Depending on your email settings you may need to check your junk folder. If you still don’t receive it you can contact Dirextra directly to resend the email. (write to master@dirextra.com) The system will display instructions to begin the exam. When you click the exam link you then need to use the same login ID and password that you used to access the course. The candidate then proceeds to answer the questions in the exam. During the exam, the candidate is required to ensure they have a stable internet connection if it drops out it will result in an automatic fail. Once the candidate has completed the exam they can then close the exam tab and recording tab. If a pass is achieved the record is uploaded to ETA awards on a Friday afternoon, ETA awards will then automatically email a certificate to you 7 to 10 working days later. The candidate can then apply for the Green Card.

Course Overview Do you sometimes zone out in meetings? Do you want to become a better communicator at work?  The Listening Skills: The Ultimate Workplace Soft Skills course will teach you how to be a better listener and communicator to form positive working relationships and improve the way you retain information. It includes tips and guidance for listening on the phone, reading people's body language, improving your attention, and much more. This course is open to anyone who wants to learn important soft skills to sharpen their communication skills at work. On completion, you will be able to implement active listening to take more efficient notes, strengthen working relationships and understand spoken information delivered. You will become a more focused person, with the ability to create better connections with those around you. This best selling Listening Skills: The Ultimate Workplace Soft Skills has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Listening Skills: The Ultimate Workplace Soft Skills is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Listening Skills: The Ultimate Workplace Soft Skills is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Listening Skills: The Ultimate Workplace Soft Skills is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Listening Skills: The Ultimate Workplace Soft Skills, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Listening Skills: The Ultimate Workplace Soft Skills will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Listening Skills: The Ultimate Workplace Soft Skills to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

About this Virtual Instructor Led Training (VILT) The 5 half-day Piping Stress Engineering Virtual Instructor Led Training (VILT) course will systematically expose participants to: The theory and practice of piping stress engineering, with special reference to ASME B 31.1 and ASME B 31.3 Standards. The basic principles and theories of stress and strain and piping stress engineering, through a series of lessons, case study presentations, in-class examples, multiple-choice questions (MCQs) and mandatory exercises. Principal stresses and shear stresses which form the backbone of stress analysis of a material. Expressions for these quantities will be derived using vector algebra from fundamentals. Thermal stress-range, sustained and occasional stresses, code stress equations, allowable stresses, how to increase flexibility of a piping system, cold spring. The historical development of computational techniques from hand calculations in the 1950s to the present-day software. Training Objectives On completion of this VILT course, participants will be able to: Identify potential loads the piping systems and categorise the loads to primary and secondary. Determine stresses that develop in a pipe due to various types of loads and how to derive stress-load relationships, starting from scratch. Treat the primary and secondary stresses in piping system in line with the intent of ASME Standards B 31.1 and B 31.3 and understand how the two codes deal with flexibility of piping systems, concepts of self-springing and relaxation/shake down, displacement stress range and fatigue, what is meant by code compliance. Understand the principles of flexibility analysis, piping elements and their individual effects, flexibility factor, flexibility characteristic, bending of a curved beam and importance of virtual length of an elbow in the flexibility of a piping system. Learn stress intensification factors of bends, branch connections and flanges. Understand how the stresses in the material should be controlled for the safety of the piping system, the user and the environment. Examine how codes give guidance to determine allowable stresses, stress range reduction due to cyclic loading, and effects sustained loads have on fatigue life of piping. Confidently handle terminal forces and moments on equipment. Understand the supplementary engineering standards required to establish acceptance of the equipment terminal loads and what can be done when there are no engineering standard governing equipment terminal loads is available and learn the techniques of local stress analysis. Get a thorough understanding of the concepts and the rules established by the ASME B 31.1 and ASME B 31.3 Standards. Perform flange load analysis calculations based on Kellogg's Equivalent Pressure method & Nuclear Code method. Perform the same using a piping stress analysis software and check for flange stresses and leakage. Confidently undertake formal training of piping stress analysis using any commercial software, with a clear understanding of what happens within the software rather than a 'blind' software training and start the journey of becoming a specialist piping stress engineer.   Target Audience The VILT course is intended for: Recent mechanical engineering graduates who desire to get into the specialist discipline of Piping Stress Engineering. Junior mechanical, chemical, structural and project engineers in the industry who wish to understand the basics of Piping Stress Engineering. Engineers with some process plant experience who desire to progress into the much sought-after specialist disciplines of Piping Stress Engineering. Mechanical, process and structural engineers with some process plant experience who desire to upskill themselves with the knowledge in piping stress engineering and to become a Piping Stress Engineer. Any piping engineer with some pipe stressing experience in the industry who wish to understand the theory and practice of Piping Stress Engineering at a greater depth. A comprehensive set of course notes, practice exercises and multiple-choice questions (MCQs) are included. Participants will be given time to raise questions and participants will be assessed and graded based on responses to MCQs and mandatory exercises. A certificate will be issued to each participant and it will carry one of the three performance levels: Commendable, Merit or Satisfactory, depending on how the participant has performed in MCQs and mandatory exercises. Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your expert course leader is a fully qualified Chartered Professional Engineer with over 40 years of professional experience in Oil & Gas (onshore and offshore), Petrochemical and Mining industries in engineering, engineering/design management and quality technical management related to plant design and construction. At present, he is assisting a few Perth based oil & gas and mining companies in detail engineering, piping stress analysis, feasibility study and business development work related to plant design. He is a pioneer in piping stress engineering in Western Australia. His recent major accomplishments include the following roles and challenges: Quality Technical Support Manager of USD 54 billion (Gorgon LNG Project). This encompassed management of quality technical services connected with Welding, Welding Related Metallurgy, Non-Destructive Examination, Insulation /Refractory /Coating, AS2885 Pipelines Regulatory Compliance and Pressure Vessel Registration. Regional Piping Practice Lead and Lead Piping Engineer of Hatch Associates. In this role, he was responsible for providing discipline leadership to several mining projects for BHP Billiton (Ravensthorpe), ALCOA-Australia (Alumina), Maáden Saudi Arabia (Alumina), QSLIC China (Magnesium), COOEC China (O&G Gorgon). He was actively involved in the development of piping engineering practice in WA, including training and professional development of graduate, junior and senior engineers. This also includes the formation of the Piping Engineering Specialist Group. Lead Piping/Pipe Stress Engineer on ConocoPhillips' (COP) Bayu Undan Gas Recycle, Condensate production and processing platform. He was able to develop several novel design methodologies for the project and provided training to engineers on how to implement them. These methodologies were commended by COP and the underwriters of the project Lloyds Register of Shipping, UK. Creator of Piping Engineering Professional Course aimed at global engineering community. Professional Affiliations: Fellow, Institution of Mechanical Engineers, UK (IMechE) Fellow, Institution of Engineers, Australia (EA), National Register of Engineers (NER) Member American Society of Mechanical Engineers, USA (ASME) Honorary Life Member, Institution of Engineers, Sri Lanka (IESL)   POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Level 2 Food Safety for a Catering Environment Approved Online Training

Overview This comprehensive course on Landing Page Design and Conversion Rate Optimisation will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Landing Page Design and Conversion Rate Optimisation comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Landing Page Design and Conversion Rate Optimisation . It is available to all students, of all academic backgrounds. Requirements Our Landing Page Design and Conversion Rate Optimisation is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 48 lectures • 10:47:00 total length •Download all Section One Slides (s1): 00:48:00 •Welcome to this course! Let's lay the groundwork for good landing page design: 00:13:00 •The Myth Of The Perfect Landing Page Conversion Rate: 00:12:00 •Common Business Models and Understanding Your Conversion Actions: 00:19:00 •The AIDA Sales Funnel and The Online Decision Making Process: 00:17:00 •The Awareness Stage of the Funnel: Where It All Begins: 00:18:00 •The Interest Stage of the Funnel Tell Me More: 00:14:00 •The Desire Stage of the Funnel I Want What You Sell: 00:13:00 •The Action Stage of the Funnel I'm Going to Buy What You Sell: 00:09:00 •The Fogg Behavior Model and how it Applies to Good Landing Page Design: 00:20:00 •Making Your Landing Page Design Memorable: 00:14:00 •Download all Section Two Slides (s2): 00:06:00 •The Primacy of Product and The Concept of Usability in Landing Page Design: 00:15:00 •Eschew Obfuscation: Clarity and the Quest for Fewer Question Marks: 00:11:00 •The 5 Second Usability Test in Landing Page Design (and how you can use it now): 00:13:00 •The Art and Science Behind Designing High-Converting Calls To Action (CTA's): 00:19:00 •Readability and Visual Hierarchy Landing Page Design: 00:20:00 •Respecting Web Conventions in Landing Page Design: 00:13:00 •Using Videos, Graphics and Imagery to Increase Landing Page Conversion Rates: 00:20:00 •Information Architecture and Accessibility - Landing Page Design Best Practices: 00:20:00 •Trust, Safety and Credibility (Part 1) Landing Page Design Best Practices: 00:14:00 •Trust, Safety and Credibility (Part 2) Landing Page Design Best Practices: 00:09:00 •Dedicated Landing Page Design Best Practices (Part 1): 00:15:00 •Dedicated Landing Page Design Best Practices (Part 2): 00:12:00 •Download all Section Three Slides (s3): 00:32:00 •Using Scarcity to Improve Conversion Rates on Your Landing Pages: 00:10:00 •Principles of Persuasion - Reciprocal Concessions & Reciprocity in Landing Pages: 00:12:00 •Principles of Persuasion Anchoring and Cognitive Dissonance Theory: 00:19:00 •My Favorite Landing Page Builders and Getting Started With Our Unbounce Page: 00:10:00 •Getting Familiar With the Unbounce Page Builder and Adding Our Header Section: 00:07:00 •Creating a Logo in Photoshop and Using the Unbounce Image Uploader Tool: 00:16:00 •Working With Background Imagery in Landing Pages and Developing Our Hero Section: 00:16:00 •Creating a Form, Action Block, and Finishing the Hero Section in Unbounce: 00:19:00 •Discussing Landing Page Design Changes and Creating our Primary Content Section: 00:16:00 •Finishing Page Content, Adding Icons, Footer and Working With Buttons Unbounce: 00:11:00 •Publishing Your Unbounce Landing Page on Your Custom Domain: 00:04:00 •Adding Custom CSS in Unbounce to Create Professional Drop Shadows: 00:06:00 •Making Your Landing Page Design Work Better With Custom Javascript Snippets: 00:08:00 •Mobile Site Layout in Unbounce Based on Mobile Landing Page Design Guidelines: 00:03:00 •Designing Your Form Confirmation Dialogue in Unbounce and Testing Your Live Form: 00:04:00 •Assigning A/B Testing Variants in Unbounce and Assigning Traffic Weights: 00:12:00 •Integrating Your Unbounce Form Submissions With Your Mailchimp Account: 00:09:00 •Goodbye For Now I Will Miss You Dearly: 00:03:00 •Western Computer Audit Part 1: 00:08:00 •Western Computer Audit Part 2: 00:09:00 •Western Computer Audit Part 3: 00:15:00 •Western Computer Audit Part 4: 00:14:00 •Assignment - Landing Page Design and Conversion Rate Optimisation: 00:00:00

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Description: Microsoft Access is a database management system application; it stores data in its own form on the Access Jet database engine. This application is used by mainly software developers to develop application software. Microsoft Access 2016 Beginner to Advanced course is a complete collection with all the contents necessary to give you an overview of this application. In this course, you will learn about its interface, create and edit databases, sorting and filtering data in a query, performing calculations, summarization of data, data normalization, advanced reporting, etc. By the end of this course, users should be comfortable with navigating the Access 2016 interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more. Learning Outcomes: Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Access 2016 Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Access 2016 Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module - 1 Orientation to Microsoft Access 01:00:00 Create a Simple Access Database 01:00:00 Get Help in Microsoft Access 00:30:00 Modify Table Data 00:30:00 Work with Records 01:00:00 Sort and Filter Records 00:30:00 Create Lookups 01:00:00 Join Data from Different Tables in a Query 01:00:00 Sort and Filter Data in a Query 01:00:00 Perform Calculations in a Query 00:30:00 Create Parameter Queries 00:30:00 Create Action Queries 00:30:00 Create Find Duplicate and Find Unmatched Queries 00:30:00 Summarize Data 00:30:00 Create a Report 01:00:00 Add Controls to a Report 00:30:00 Enhance the Appearance of a Report 00:30:00 Prepare a Report for Print 00:30:00 The Access Options Dialog Box 01:00:00 Relational Database Design 00:30:00 Create a Table 01:00:00 Modify a Table and Fields 00:30:00 Create Table Relationships 00:30:00 Create Query Joins 00:30:00 Join Tables That Have No Common Fields 00:30:00 Relate Data within a Table 00:30:00 Work with Subdatasheets 00:30:00 Create Subqueries 00:30:00 Data Normalization 01:00:00 Create a Junction Table 00:30:00 Import Data into Access 00:30:00 Export Data to Text File Formats 00:30:00 Export Access Data to Excel 00:30:00 Create a Mail Merge 00:30:00 Organize Report Information 00:30:00 Format Reports 00:30:00 Include Charts in a Report 00:30:00 Add a Calculated Field to a Report 00:30:00 Add a Subreport to an Existing Report 00:30:00 Create a Mailing Label Report 00:30:00 Publish a Report as PDF 00:30:00 Activities - Microsoft Access 2016 for Beginners 00:00:00 Module - 2 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Access 2016 Beginner to Advanced 00:30:00 Final Exam Final Exam- Microsoft Access 2016 Beginner to Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Gain expert internal audit skills by enrolling in the Internal Audit Training Diploma course.Internal audit is a vital part of financial management. This Internal Audit Training Diploma course will provide you with a thorough understanding of internal auditing. It will introduce you to the auditing form and assurance best practices, teaching you a range of internal auditing procedures. It will also teach you about UK internal audit standards as well as how to conduct audit interviews and report on audit outcomes.Kickstart a high earning career in the internal audit sector with the Internal Audit Training Diploma course. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Internal Audit Training Diploma. It is available to all students, of all academic backgrounds. Requirements Our Internal Audit Training Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 8 lectures • 02:54:00 total length •Auditing as a Form of Assurance: 00:11:00 •Internal Audit Procedures: 00:22:00 •Technology-Based Internal Audit: 00:23:00 •Internal Control and Control Risk: 00:36:00 •Audit Interviews: 00:18:00 •Reporting Audit Outcome: 00:23:00 •UK Internal Audit Standards: 00:24:00 •Career as an Auditor: 00:17:00

Duration 3 Days 18 CPD hours This course is intended for Students receive comprehensive Microsoft Dynamics exam preparation, becoming familiarized with the Dynamics CRM customization and configuration tools. Aspirants also learn to leverage the platform tools to create custom objects, automate tasks, modify user interface, and perform other such customizations. Overview Configure the Dynamics CRM settingsConfigure different entities and fieldsImplement entity relationships, custom actions, workflows, and dialogsIdentify scenarios for utilizing multiple forms, and design considerations for chartsSet default share views and public views, and configure and manage dashboardsIdentify role-based business processesIdentify and manage business requirements and teams This course explains everything you need to know about customizing and configuring the Dynamics CRM 365 system in accordance with a company?s specific requirements. Introduction to Customization and Configuring Dynamics CRM Talent and Course Introduction Module Overview CRM Overview What is Dynamics Customization and Configuration? CRM Architecture Customization Methodology Module review Obtaining a Dynamics CRM Trial TEST YOUR KNOWLEDGE MODULE 1' Manage Microsoft Dynamics CRM Online Subscriptions Module Overview Configuring CRM Overview of CRM Security User Administration Mailboxes Teams CRM Security Model Module Overview Purpose of the CCRM Security Model Privileges Access Levels Security Roles Hierarchy Security Hierarchy Types Module review Introduction to Solutions Module Overview Solutions Overview Solution Detail Creating and Working with Solutions Working with Solution Assets Exporting Solutions Importing Solutions Module review Entity and Field Customization Module Overview Types Entities Entity Ownership Entity Properties System vs Custom Entities Custom Entities and Security Roles Overview of Fields Field Properties Module review Additional Field Customization Module Overview Creating Fields to Meet Client Needs Calculated Fields Rollup Fields CRM Option Sets Alternate Keys Field Level Security State and Status Reason Transitions Module Review Configure mobile devices Module Overview Types of Relationships How and where they are created Many to Many Relationships Hierarchical Data Entity Mapping Connection and Connection Roles Module Review Customizing Forms Module Overview Form types Qualities of a good form Building a Form Specialized Form Components Access Teams and Sub Grids Working with Navigation Additional Form Types Multiple Forms Form customizations and Mobile Clients Module Review Business Rules Module Overview Business Rules Business Rule Scope Trigger Rules Condition and Actions Else Conditions and Actions Occur When Conditions Are True Module review Views and Visualizations Module Overview Using Views View Customization System View Types Quick Find Customization Charts Customizing Dashboard Themes Module Review Introduction to Processes Module Overview Processes and Automation Workflow Basics Module review Business Process Flows What are CRM Business Process Flows Enabling Business Process Flows Steps Stages and Categories Conditional Branching Module Review Bringing it all Together Module Overview Review of Customization Topics Covered Senario Packaging in a Solution Module review

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification