Learn how to create and manipulate an Access database.Microsoft Access Distance Learning units have been specifically designed to provide you with the knowledge and techniques needed for the successful creation and manipulation of an Access Database. The accompanying data files provided are designed to help demonstrate the features as you work through the unit step-by-step. What you will experience This course covers the following topics: Replacing, Cutting & Copying Text Calculating Fields Relationships Lookup Fields Default Values Validation Rules Sub-forms & Linking Forms Combo & List Boxes Tab Control Label & Chart Wizard Importing & Exporting Data Advanced Queries Database...

An in-depth introduction to effective use of Microsoft Access Databases.Microsoft Access Distance Learning units have been specifically designed to provide you with the knowledge and techniques needed for the successful creation and manipulation of an Access Database. The accompanying data files provided are designed to help demonstrate the features as you work through the unit step-by-step. What you will experience You will be introduced to key aspects of using Access databases, including: Using the Menus & Toolbars Database Principles Database Window Moving within a Table Changing Table Layout Using Find Creating a Database Sorting & Filtering Data Creating & Using...

An introduction to the principles and practice of Artificial Intelligence (AI). This non-specialist unit is particularly appropriate for learners with an interest in Science, Technology, Engineering or Mathematics (STEM).The unit covers the theory and practice of AI. You would benefit from undertaking this unit if you want to know more about the basics of AI and how it can be used in practice. What you will experience At the end of the unit you will know where AI came from, what it is capable of doing (and not doing), how you can use it in your job, and how it...

Giving you a comprehensive understanding of common mental health problems, and associated issues.One in four British adults experiences at least one diagnosable mental health problem each year? The most common is mixed anxiety and depression, but there are so many other issues which have a huge impact on a person’s life and the people around them. This qualification offers a comprehensive understanding of some common mental health problems, which is of vital importance for anyone who works around people suffering with these conditions. What you will experience The qualification is suitable for anyone who wishes to increase their knowledge of...

Prepare for employment or further study in CAD (Computer-Aided Design) fields and industries that use 3D printing and scanning. This unit will help you learn how to record your design work and make cost estimates and evaluations.This Unit is suitable if you have moderate experience with CAD software packages, with an understanding of both 2D and 3D printing and

Strengthening awareness of the signs, symptoms and treatments available for common health conditions.In the UK today there is an ever growing number of people living with a common health condition. These conditions have varying effects upon those unlucky enough to develop them and all require continual management in order to minimise the impact they have on an individual’s day–to–day life. Ideal for anyone currently working in or seeking a career in the health sector, this qualification will ensure positive development in strengthening awareness of the many signs, symptoms and treatments available for a variety of common health conditions. These conditions...

Allows you to develop your existing Excel skills and knowledge to support workplace demands.Microsoft Excel Distance Learning units have been specifically designed to provide you with the necessary knowledge and techniques for successful creation and manipulation of an Excel Spreadsheet. The data files which will be provided on disc are designed to help demonstrate the different features as you work through the unit step-by-step. What you will experience You will explore a range of key topics, including: Advanced Functions Data Input Tables Manipulating Charts Working with Macros Creating Forms Macros Auditing Data Consolidation Creating Web Pages Hyper-linking Maps Sharing Workbooks...

Learn to create and use an Excel spreadsheet.Microsoft Excel Open Learning units have been specifically designed to provide you with the necessary knowledge and techniques for successful creation and manipulation of an Excel Spreadsheet. The accompanying data files provided on disc are designed to help demonstrate the different features as you work through the unit step-by-step. What you will experience You will explore the following topics: Manipulating Worksheet Views Working with Multiple Windows Using Names Cell & Workbook Protection Hiding Information Working with Templates Advanced Printing Creating Views Linking Sorting Data

Learn to create and use Microsoft Excel spreadsheets.Microsoft Excel Open Learning units have been specifically designed to provide you with the necessary knowledge and techniques to successfully create and manipulate an Excel spreadsheet. The accompanying data files, which are provided on disc, will help demonstrate the different features as you work through the unit step-by-step. What you will experience You will study the following topics: Fundamentals of Excel Open, close, save & delete workbooks Formulas Editing Cells Printing Copying & Moving Cells Formatting Cells Formatting Worksheets Cell Referencing Function At the end of the course you will test your knowledge...

A best-practice introduction to Health and Safety relevant to every workplace.According to the Health and Safety Executive, workplace injuries and ill-health cost UK businesses approximately £16.2 billion per year. The benefits to organisations in lowering this include reduced financial costs, lower employee absence and turnover rates. When coupled with reducing the risk of injury and illness the benefits are clear to see. The NEBOSH HSW Award is the ideal solution for anyone who needs to understand the principles of health and safety in the workplace. Developing these skills will make a real difference in the workplace. You will have the...