All University Computing Service courses

SVI workbook tutorials on the database package Microsoft Access 2003. Files for the exercises are provied on CDs.

This set of 3 CDs by LearnKey takes you step-by-step through the functions and features of Microsoft Access 2003.

This is an introduction to the popular database software Microsoft Access 2007 for support staff. The course is aimed at those who have never used the package before and who would like to gain an overview of the package to get up and running. There is a fee for this course, see below.

This is an introduction to the popular database package Microsoft Access 2007. The course is aimed at those who have never used the package before or have just started using it. There is an Access Fast Track course that is a shortened version of this course for those who learn at a faster pace.

This is a fast paced and shortened version of the 2-session Access 2007: Creating a Simple Database course and thus is more suitable for those who are quick learners. This course will be taught using Access 2007 on PCs (Windows XP) - note that this version is quite different from previous version.

This course is intended for those already using Microsoft Access 2007 to store and retrieve data who wish to explore queries, forms and reporting. Those who have attended the Access Intro course will find this follows on seamlessly from where that course ended.

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.

This VTC Training CD can be used under Windows or on the Macintosh.

This is a set of 3 tutorials by Mac Pro Video on Logic, Apple's audio editor. The DVDs can be used on Macs (although advertised as being usable under Windows, we have had no success in doing so).

This course will teach cabling Ethernet LANs.

A course in basic C programming intended for beginners to programming only. The aim of the course is to get everyone to the stage of being able to write small utility programs in C for carrying out simple calculations and data manipulation.

The Cisco Certified Network Associate (CCNA) programme is open to University IT Supporters. It covers network technology, protocols and theory at deeper levels reflective of university practices. There is a fee to attend this course.

You will learn the basics of routing, switching, and advanced technologies to acquire the skills required to provide a robust and secure network in your institution and it prepares you for CCNA certification.

We offer this program as instructor led with remote access to the curriculum and an online networks laboratory called NETLAB. There is a mix of lecture, demonstrations and a heavy emphasis on practical activities using live lab equipment and a simulation package. Further details and pricing information are available.

This is the first module of four modules in CCNA.

1. Networking Fundamentals 2. LAN Switching and Wireless 3. Routing Protocols and Concepts 4. Accessing the WAN

The Cisco Certified Network Associate (CCNA) programme is open to University IT Supporters. It covers network technology, protocols and theory at deeper levels reflective of university practices. There is a fee to attend this course.

You will learn the basics of routing, switching, and advanced technologies to acquire the skills required to provide a robust and secure network in your institution's and it prepares you for CCNA certification.

We offer this program as instructor led with remote access to the curriculum and an online networks laboratory called NETLAB. There is a mix of lecture, demonstrations and a heavy emphasis on practical activities using live lab equipment and a simulation package. Further details and pricing information are available.

This is the second module of four modules in the CCNA programme.

1. Networking Fundamentals 2. LAN Switching and Wireless 3. Routing Protocols and Concepts 4. Accessing the WAN

It is expected that this module will run January 2011, dates to be confirmed. Please register your interest if you would like to attend. There is a fee to attend this course.

The Cisco Certified Network Associate (CCNA) programme is open to University IT Supporters. It covers network technology, protocols and theory at deeper levels reflective of university practices.

You will learn the basics of routing, switching, and advanced technologies to acquire the skills required to provide a robust and secure network in your institution and it prepares you for CCNA certification.

We offer this program as instructor led with remote access to the curriculum and an online networks laboratory called NETLAB. There is a mix of lecture, demonstrations and a heavy emphasis on practical activities using live lab equipment and a simulation package. Further details and pricing information are available.

This is the third of four modules in the CCNA programme.

1. Networking Fundamentals 2. LAN Switching and Wireless 3. Routing Protocols and Concepts 4. Accessing the WAN

It is expected that this module will run May 2011, dates to be confirmed. Please register your interest if you would like to attend. There is a fee to attend this course.

The Cisco Certified Network Associate (CCNA) programme is open to University IT Supporters. It covers network technology, protocols and theory at deeper levels reflective of university practices.

You will learn the basics of routing, switching, and advanced technologies to acquire the skills required to provide a robust and secure network in your institution and it prepares you for CCNA certification.

We offer this program as instructor led with remote access to the curriculum and an online networks laboratory called NETLAB. There is a mix of lecture, demonstrations and a heavy emphasis on practical activities using live lab equipment and a simulation package. Further details and pricing information are available.

This is the fourth of four modules in the CCNA programme.

1. Networking Fundamentals 2. LAN Switching and Wireless 3. Routing Protocols and Concepts 4. Accessing the WAN

Basic computing skills for beginners

CorelDraw is a professional graphical illustration package for Windows.

Speak, don't type: reduce RSI and increase work productivity by dictating text and controlling your PC by voice. This course, is of particular benefit to users wishing to prevent or reduce the impact of RSI, however it is also useful for those who would like to type less and eventually increase their productivity once the softwre is familiar. It gives an introduction to Nuance's Dragon NaturallySpeaking voice activated software. At the end of the course, the student will be able to control his/her PC and produce notes and documents by voice.

« Description not available »

This VTC Training CD can be used under Windows or on the Macintosh. Dreamweaver provides facilities for Web site design and production. It is curently the only tool to offer Roundtrip HTML between visual and source editing for fast creation of great looking, cross browser Web sites. Features include advanced table editing, site management tools, Dream Templates, and extensibility.

In Module 1 the candidate will learn about some of the main concepts of IT at a general level. The candidate will learn about the general make-up of a personal computer in terms of hardware and software and about some of the concepts of Information Technology (IT) such as data storage and memory. The candidate will also learn some basic troubleshooting concepts and techniques and how to identify the setup and components of their computer. The candidate will gain an appreciation of health and safety issues as well as some of the environmental factors involved in using computers. The candidate will also learn about some of the important security and legal issues associated with using computers.

• Chapter 1: General Concepts

• Chapter 2: Hardware

• Chapter 3: Basic System Maintenance

• Chapter 4: System Interrogation

• Chapter 5: The Use Of IT In Everyday Life

• Chapter 6: Health and Safety and the Environment

• Chapter 7: Security

• Chapter 8: Copyright And The Law

In Module 2 the candidate will learn about some of the common functions of a personal computer and its operating system. The candidate will learn how to adjust main settings, use the built in help features and deal with a non-responding application. The candidate will learn how to operate effectively within the desktop environment and work with desktop icons and windows. The candidate will learn how to manage and organise files and folders, and how to duplicate, move and delete files and folders, and how to compress and extract files. The candidate will also learn what a computer virus is and how to use anti-virus software. The candidate will also learn how to use simple editing tools and the print management facilities available within the operating system.

• Chapter 1: Getting Started

• Chapter 2: Working With A Window

• Chapter 3: Desktop Icons

• Chapter 4: Using Applications

• Chapter 5: Data Storage In Windows

• Chapter 6: Windows Explorer

• Chapter 7: Working With Folders

• Chapter 8: Disks

• Chapter 9: Working With Files

In Module 3 the candidate will learn about word processing and will be able to demonstrate the ability to use a word processing application on a computer. The candidate will be able to accomplish everyday tasks associated with creating, formatting and finishing small sized word processing documents ready for distribution. He or she will also be able to duplicate and move text within and between documents, and demonstrate competence in using some of the features associated with word processing applications such as creating standard tables, using pictures and images within a document, and using mail merge tools.

In Module 4 the candidate will learn about the concepts of spreadsheets and will be able to demonstrate the ability to use a spreadsheet on a computer. The candidate will be able to develop, format, modify and use a spreadsheet of limited scope ready for distribution. This will involve creating formulas and using standard functions, and creating and formatting charts/graphs.

This publication is intended for people who wish to prepare for Module 5 - Database of the ECDL/ICDL Syllabus (Version 4.5) using Microsoft Access 2007. In Module 5 the candidate will learn about the main concepts of databases and be able to demonstrate the ability to use a database on a computer. The candidate will be able to create and modify tables, queries, forms and reports, and prepare outputs ready for distribution. The candidate will be able to relate tables and retrieve and manipulate database information using the query and sort tools available in the application.