UCS Self Taught Training 2014-15

The skills and knowledge acquired in Microsoft Access 2007 Level 1 are sufficient to create robust relational database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data. Microsoft Access 2007 Level 1 is designed for people who need to know how to create effective databases and to manipulate data to provide viable information.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

The skills and knowledge acquired in Microsoft Access 2010 Level 1 are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data. Watsonia workbook tutorials. Files for the exercises are provided on CDs.

Microsoft Access 2010 Level 2 is designed for users who have an understanding of how tables are created, records are entered, modified and deleted, and how simple queries, reports and forms are created.

The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros. Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course is primarily designed for people who need to know how to develop relational databases and automate operations in Microsoft Access 2010

The skills and knowledge acquired in Microsoft Access 2010 Level 3 are sufficient to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2010. Watsonia workbook tutorials. Files for the exercises are provided on CDs.

Adobe Dreamweaver CS5 is designed for users who are keen to learn how to create and maintain a website.

The skills and knowledge acquired in Adobe Dreamweaver CS5 are sufficient to be able to create robust websites. Attention is paid to the initial creation of the website incorporating text and images.

The skills and knowledge covered in this book are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists. This book is primarily designed for people who need to know how to use Microsoft Excel 2007 is designed for people new to the Excel environment. It is ideal for people who work in offices, clubs or charities where there is a requirement to produce reports, budgets and lists, using formulae for automated calculations and the like.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions, and to use the sorting and filtering features to manage and analyse data. This course is intended for current Microsoft Excel 2007 users who wish to extend their knowledge and skills beyond building simple workbooks.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with automation and productivity features. It includes areas such as conditional formatting, validation and consolidation methods, data analysis tools, such as data tables, summarising, goal seeking and PivotTables, and ways of annotating worksheets to help when sharing information with others. This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course is designed for users new to Microsoft Excel 2010 and spreadsheeting.

This course aims to give the new spreadsheet user a thorough grounding in the basics of spreadsheeting and using Microsoft Excel 2010. Particular emphasis is placed on the importance of accuracy, good formula building techniques, and sound formatting and design principles. It is ideal for people who work in offices, clubs or charities where there is a requirement to produce reports, budgets and lists, using formulae for automated calculations and the like.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

Microsoft Excel 2010 Level 2 is designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.

Microsoft Excel 2010 Level 2 is the second of a 3-Level study program for Microsoft Excel 2010. This level extends the learner's basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks. Files for the exercises are provided on CDs.

This course is designed for users who need to use some of the more advanced features of Microsoft Excel 2010.

This course aims to provide skills and knowledge which will allow the attendee to create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver, and create and use macros. Files for the exercises are provided on CDs.

Adobe Illustrator CS5 is an illustration and drawing program designed for users who want to learn how to create vector based graphics for design, webdesign and desktop publishing material.

The skills and knowledge acquired in Adobe Illustrator CS5 are sufficient to be able to create professional artwork and documents.

Adobe InDesign CS5 is designed for users who are keen to learn how to produce high quality and attractive publications when using this powerful page layout software.

The skills and knowledge acquired in Adobe InDesign CS5 are sufficient to be able to use a variety of techniques to create publications.

Introduction to Personal Computers using Windows 7 and Microsoft Office 2010 is designed for users who are keen to extend their understanding and knowledge of the use of computers.

The skills and knowledge acquired in Introduction to Personal Computers using Windows 7 and Microsoft Office 2010 are sufficient to be able to use and operate the software to perform tasks that include starting applications, creating folders, copying and moving files, and personalise Windows.

The IT Infrastructure Library® (ITIL®) is the most widely accepted approach to IT Service Management in the world. ITIL® is a Best Practice framework that has been drawn from both the public and private sectors internationally. It describes how IT resources should be organised to deliver business value, documenting the processes, functions and roles of IT Service Management (ITSM).

The ethos behind the development of ITIL is the recognition that organisations are becoming increasingly dependent on IT in order to satisfy their corporate aims and meet their business needs. This leads to an increased requirement for reliable, high-quality IT services.

This ITIL Foundation e-learning course is designed to enable delegates to understand the disciplines and processes that help service management staff to deliver and support quality products and services.

The eLearning course covers the fundamentals of the IT Infrastructure Library (ITIL) core volumes which provide an end-to-end view of IT and its integration with business strategy. Those core volumes are: Service Strategy, Service Design, Service Transition, Service Operation and Continual Service Improvement. It uses the ITIL IT Service Management Glossary of Terms & Definitions and ITIL IT Service Management Acronyms.

The online course materials are available to you for one year from the date you receive your login details.

ITIL Foundation is the entry level qualification of the ITIL Qualifications scheme.

www.lynda.com is an Online Training Library® that is a constantly growing and evolving body of training video tutorials designed to help you learn what you want, when you want it. You have access to over 1000 courses and 75000 tutorials organized by subject or software and the content is growing every week.

This is a Mac Pro Video tutorial on Mac OS. The DVD can be used on both Macs (although advertised as being usable under Windows, we have had no success in doing so).

This two-hour clinic provides you with an overview of the new and enhanced deployment, security, manageability, and performance features in Windows 7. It describes how these features meet the day-to-day needs of IT professionals.

This two-hour clinic provides you with an overview of key enhancements in Windows 7, which help information workers to improve their productivity as well as work in a more secure environment.

This one-hour clinic provides an overview of key enhancements in Windows 7 that help you work more efficiently and easily with your computers. It describes the new features and tools to organize, find, protect, and share your information. It also describes how these features and tools help you work with your devices and enhance your online experience.

The entirety of the offering is 12 hours but it is designed to be modular, allowing the user to skip to the tracks which are most relevant to them. this clinic will help you understand how to build enterprise-class applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.

This modular 12-hour clinic allows you to skip to the tracks which are most relevant to you. This clinic will help you understand how to exploit the enhancements to SQL Server 2008 with little or no changes to existing applications, how to test SQL Server 2000 or SQL Server 2005 applications for compatibility with SQL Server 2008, and how to plan upgrades to SQL Server 2008.

This modular 12-hour clinic allows you to skip to the tracks which are most relevant to you. This clinic will help DBAs understand how to exploit the new SQL Server 2008 capabilities, how to enable application scalability, and how to manage a database that makes use of the new features in SQL Server 2008.

This modular 12-hour course helps you exploit new business intelligence features in SQL Server 2008. This course provides you with the necessary skills to solve common BI development problems.

This two-hour clinic describes various new features and enhancements that Microsoft SharePoint 2010 provides developers. It describes how you can create and deploy SharePoint 2010 solutions using Microsoft Visual Studio 2010. It also describes how you can develop remote clients for SharePoint 2010 and develop SharePoint 2010 solutions that incorporate data from external line-of-business applications.