Course information order form

Access

Microsoft Access is a very powerful database application designed to save you time and make creating relational databases easier.

Introduction level

includes:

• Exploring access
• tables
• field properties
• finding & filtering data
• query results
• basic forms
• basic reports

Intermediate level

introduces delegates to more advanced features of the software including tasks such as:

• Creating queries which can search for duplicates in database
• creating calculated fields
• importing & exporting data
• manipulating controls in design view of forms

…and more!

Advanced level

includes tasks such as:

• Advanced report design
• sub-forms
• creating switchboards
• developing a data access page & pivot tables
• database security
• creating and using macros
• exporting data to MS Office

…and more!

(Back to top of list)

Adobe Acrobat

Share information electronically, convert any document into an Adobe Portable Document Format (PDF) file, with its original appearance preserved, and then distribute it for viewing and printing on any system. Adobe Acrobat is the industry standard tool for problem free digital document proofing as well as creating pages for the web and computer-to-plate solutions.

Introduction level

includes:

• understanding Adobe concepts
• creating PDF files
• digital proofing cycle
• file annotations
• interactive PDFs
• search facilities
• Adobe catalogue
• security

(Back to top of list)

CorelDRAW

CorelDRAW delivers graphic design and vector animation software for print and the Web. Unique interactive tools set it apart, saving you time and making the design process easier.

Introduction level

introduces you to the basic commands, functions, and capabilities of CorelDRAW, such as:

• drawing and manipulating objects
• exporting drawings
• printing
• file annotations
• interactive PDFs
• search facilities
• Adobe catalogue
• security

…and more!

Advanced level

covers areas such as:

• customising options
• paragraph text
• special effects
• layers
• styles
• templates
• bitmaps

(Back to top of list)

Crystal Reports

Crystal Reports is a comprehensive web and Windows reporting solution that lets you access, analyze, report, and share data. Crystal Reports, the acknowledged leader among Windows report writers, brings ease-of-use, flexibility and powerful reporting technology to the Web. Whether you are a business user in need of easy e-reporting, an IT professional creating advanced reports and distributing them via a scalable web solution, or a software developer integrating reports into your applications, Crystal Reports is the answer for powerful, presentation-quality reports for the Web and Windows.

Introduction level

includes:

• simple reports
• sorting and selecting records
• grouping and summarising
• parameter fields
• report expert
• linking
• creating formulae
• formating sections
• distributing data

Advanced level

includes:

• conditional formatting
• advanced formulae
• multiple sections
• parameter fields
• advanced cross tabs
• subreport
• SQL/ODBC and Crystal SQL designer
• Crystal dictionaries
• graphing

(Back to top of list)

Dragon NaturallySpeaking

Dragon NaturallySpeaking enables you to create documents up to four times faster than typing and protects against repetitive stress injuries like carpal tunnel syndrome that increase insurance premiums and temporary labor costs. Create documents and e-mails, write reports and fill out forms, without having to type at all. Dragon NaturallySpeaking fully integrates with the Microsoft Office applications you use: Word, Excel, Outlook and PowerPoint, and just about any Windows application.

Introduction level

includes:

• Understanding Dragon NaturallySpeaking capabilities
• voice files
• improoving your vocabulary
• using Dragon NaturallySpeaking in Microsoft Office applications

Advanced level

includes:

• pre-course investigation of user’s requirements
• customising Dragon NaturallySpeaking
• adding words with different written and spoken forms
• creating dictation shortcuts
• creating custom commands in Dragon NaturallySpeaking
• creating custom commands in Microsoft Office applications

SuperTips

…is not just a standard Dragon NaturallySpeaking course. This course teaches shortcuts in Word and Excel, so that you can take full advantage of Dragon within your favourite applications, and includes a pre-course investigation of user's requirements

(Back to top of list)

Dreamweaver

The world's best way to create professional websites is now the easiest way to build powerful Internet applications. Macromedia Dreamweaver has everything you need to develop a professional Web site. It is an exciting and fun package for the creation of professional quality web sites and is extremely easy to get to grips with because it uses the very best WYSIWYG (what you see is what you get) editors; allows simple creation of tables and frames; ability to use layers, animations; full support of cascading style sheets; extensive code-editing support.

Introduction level

includes:

• basic concepts about the internet and the world wide web
• defining a site in Dreamweaver to organise and maintain the web pages
• creating a basic web page
• using site panel to create and organise files and folders
• inserting images
• tables
• linking
• image maps
• uploading a site

Advanced level

includes:

• head content
• style sheets
• forms and libraries
• rollovers and behaviors
• layers
• timelines
• forms

(Back to top of list)

Excel

Use Excel as a spreadsheet, database or graphing application. Create sophisticated calculations and formulae to recalculate automatically. The advantage of using formulas is that when data in the worksheet changes, all the formulas recalculate automatically. This feature assists you in developing budgets, forecasting models, creating sales plans, making financial projections, calculating inventories calculations, generating banking statements, and basically working with any format involving numbers. Excel can sort lists and select specific pieces of information based on specified conditions.

Introduction level

includes:

• spreadsheet concepts
• workbooks and worksheets
• selecting cells
• entering and editing data
• calculations and formulae
• shortcut techniques
• moving and copying data
• printing
• page setup

Intermediate level

includes:

• Managing worksheets
• paste special
• ranges
• charts
• sorting
• comments

…and more!

Advanced level

includes:

• outlines
• database tools
• advanced filters
• charts
• linking workbooks
• scenarios
• macros

…and more!

SuperTips

Learn lots of shortcuts and tips to help you speed up your existing knowledge of Excel.

(Back to top of list)

Flash

Macromedia Flash is the fastest way to create rich Internet content and applications. The powerful video, multimedia and application development features allow the creation of rich user interfaces, online advertising, e-Learning courses and more.

Introduction level

…will introduce you to the basics of creating objects and animating in Macromedia's Flash. You will explore the basics of Flash, including tools and features, and will create different types of animations. Finally, you will publish material for the Web. This course is intended for students with little or no experience creating Flash animations, who want to create animations using Macromedia Flash.

Intermediate level

includes:

• symbols
• instances
• projects
• interactivity
• sound
• flash movie

(Back to top of list)

FrontPage

Microsoft FrontPage is easy to get started with. Built-in templates and wizards allow you to create a web site in only a matter of minutes, and then customize it to make it your own with your own graphics, Photo Gallery, backgrounds, image maps, Themes, fonts, and formatting.

Introduction level

includes:

• working with text
• graphics
• links
• special features
• publishing

…and more!

Advanced level

includes:

• templates
• splash pages
• displaying content
• finding information
• managing a web site

(Back to top of list)

Outlook

Microsoft Outlook is a comprehensive desktop information management program. You can use Outlook as a central inbox for all of your internal and external e-mail messaging systems. You can also use it to manage your contacts, to organise your calendar and scheduling, and to maintain a journal of your activities. Additionally, Outlook integrates a number of system management features that help you manage your files, folders, and system resources.

Introduction level

includes:

• Using email and messaging features
• signatures
• attachments
• saving messages
• tracking messages
• calendars
• meetings
• contacts
• tasks
• journal
• notes

Advanced level

includes:

• categories
• folders
• find
• organise pen
• reminders
• customising views
• message hyperlinks
• saving messages as files
• address book
• personal address books
• distribution files
• rules wizard
• creating a letter to contact
• mail merge
• forms

SuperTips

Learn lots of shortcuts and tips to help you speed up your existing knowledge of Outlook.

(Back to top of list)

Pagemaker

Adobe PageMaker is an excellent design layout program for businesses & professionals who want to create high-quality publications such as brochures, newsletters and other business documents. PageMaker incorporates precision layout and intelligent kerning (letter spacing) plus it includes numerous templates, graphics, and intuitive design tools to give you precise control over your document look and feel so you can produce visual communications that are both powerfully effective and highly creative.

Introduction level

explains the fundamentals of PageMaker including how to produce well-designed documents quickly and easily. Special emphasis is placed on the principles of good design in DTP, as well as giving a thorough grounding in the essentials of operating the package

Intermediate level

teaches how to create a multi-page publication using PageMaker's automatic layout and adjustment features. These include using multiple master pages and paragraph styles to streamline the production of a publication.

Advanced level

includes learning how to prepare publications for the Web, converting your document to HTML, optimising graphics and adding hyperlinks for navigation on line.

(Back to top of list)

Paintshop Pro

Paint Shop Pro is a first class image manipulation package which can achieve very professional results! With this software you can retouch, repair, and edit photos with easy-to-use, high quality, automatic photo enhancement features; create and optimise Web graphics with built-in Web tools and artistic drawing and text tools; design animations for web pages.

Introduction level

includes:

• How to select, edit, crop and clone images
• create shapes
• define preferences
• use channels
• create and manipulate layers and masks
• enhance images
• prepare graphics for the web

(Back to top of list)

Photoshop

Adobe Photoshop introduces the next generation of image-editing capabilities with powerful features that offer something for every user.

Introduction level

will teach delegates how to use several tools for selecting parts of images, to move, duplicate, and re-size images. They will learn to use layers, and to apply layer effects and filters to create special effects, including lighting and texture effects, painting tools and blending modes to create shading effects, and will perform adjustments to contrast and colour balance.

Advanced level

will further your understanding of isolating image areas by creating and saving masks with specialised tools, commands, modes, and layer elements. You'll learn how to use vector paths for a variety of purposes, including masking, clipping paths, and illustration. You'll also learn to create and apply creative elements such as gradients, patterns, and colour overlays, and to save them along with effects in easy-to-apply layer styles.

(Back to top of list)

Powerpoint

Microsoft PowerPoint is a presentation graphics program that produces dynamic and powerful slide shows containing text, graphics, and charts. You can use PowerPoint for formal and informal presentations and meetings, as well as for presentations on the Internet. Whether you are presenting an idea, plan, or complex report to a group, you can use PowerPoint to combine essential data, dramatic illustrations, animation, special effects, and timed sequences that convey your important points in an informative and convincing visual presentation.

Introduction level

includes:

• Basic presentation skills
• outline view
• text
• bullets and numbers
• printing
• formatting
• slide sorter view
• graphic images
• drawing objects
• slide show view

Advanced level

covers the more advanced topics, including:

• Masters
• chart customisation
• animations
• transitions

…and more!

SuperTips

Learn lots of shortcuts and tips to help you speed up your existing knowledge of PowerPoint.

(Back to top of list)

Project

Microsoft Project is the world's leading project management program. Microsoft Project makes it easier than ever to manage schedules and resources, communicate project status, and report project information. With dynamic scheduling, you can instantly see the impact of a schedule or resource change on your overall project schedule.

Introduction level

covers the critical skills necessary to create and modify a project plan file that contains tasks, resources, and resource assignments, such as:

• projects
• tasks
• filtering and grouping
• resources

Advanced level

teaches how to:

• Track project work
• analyse and adjust schedules
• set up project messaging
• links to the web
• import and export data
• manage multiple projects
• customise projects

(Back to top of list)

Publisher

With Microsoft Publisher you can create a document from one of the many publication designs in the design catalogue, using the layout and design elements that come with it or you can start with a blank document and create your own. Publisher gives you the freedom to create interesting text design elements through the use of different fonts and text formatting, to enhance the layout of the page with custom graphics, clip art, and graphic elements.

Introduction level

teaches how to:

• Create and modify one and multi page document using a publication design
• format text
• use drawing tools
• insert and modify graphic elements
• add and modify tables

(Back to top of list)

QuarkXpress

QuarkXPress has been the leading layout and design software for publishers worldwide. Its advanced features support you throughout the publishing process, from page layout to the final print. QuarkXPress is the electronic publishing tool of choice for graphic designers, typographers, publishers, and printers for creating everything from advertisements and newsletters to annual reports, technical documentation, magazines and books.

Introduction level

includes:

• creating multi-page documents
• working with text
• images
• colour
• bezier curves
• freehand tools
• preferences
• printing

Advanced level

includes:

• working with master pages
• document pages
• libraries
• lists and books
• graphics
• pictures
• bezier shapes
• tips

(Back to top of list)

Sage Line 50 Accounts

This course is designed for beginners as an introduction to Sage Line 50 and aims to teach the use of the main features of this accounting package. It assumes that the student has a basic understanding of bookkeeping procedures and an understanding of the double-entry principal. We do not teach how to set up an accounting system from scratch nor attempt to teach bookkeeping.

Introduction level

teaches how to use the main functions of Sage Line 50 including:

• Nominal ledger
• bank accounts
• bank reconciliation
• bank transfers
• recurring entries
• customer & supplier modules
• products
• invoicing
• statements
• receipts & payments
• vat reconsiliation
• correct error postings
• profit & loss
• balance sheet and trial balance reports

(Back to top of list)

Sage Line 50 Payroll

Sage Payroll is the UK leader in payroll software for small to medium-sized businesses. Calculates tax, National Insurance and net pay in minutes. Automatic SSP, SMP and pension calculations. Complying with the latest government legislation, it deals easily with complex tasks.

Introduction level

includes:

• Payroll overview
• company settings
• pension schemes
• absence and holidays
• government legislation
• pay elements
• new employees
• applying rates of pay
• ytd values
• processing date and payments
• pre update reports
• updating records
• employees paid by the hour
• company cars
• absences
• SSP and SMP
• criteria and outine view
• updating month 12 and week 52
• when an employee leaves
• reports
• year end procedures

(Back to top of list)

Microsoft Visio

Visio helps you transform your ideas and information into understanding and action. In this course, delegates will learn the fundamental skills while creating several types of diagrams. Delegates will create a directional map, a block diagram, a basic and a cross-functional flowchart, and an organization chart. As you create these drawings, you will learn techniques to drag and manipulate Visio master shapes, create connections between shapes, and apply styles to shapes, text, and pages.

Introduction level

includes:

• directional map
• diagram skills
• flowcharts
• organisation charts
• floor plans

Advanced level

includes:

• customising Visio
• drawing tools
• custom shapes
• advanced stencil techniques
• templates
• styles
• layers
• sharing work
• printing

(Back to top of list)

Microsoft Word

Microsoft Word is a full-featured word processor in which you can create and design documents such as letters, memos & reports. When creating documents, you can choose from a variety of type sizes and fonts. You can edit documents, as well as enhance their appearance.

Introduction level

includes:

• Basic document skills
• document views
• text editing
• spell check
• printing
• character formatting
• paragraph formatting
• indenting
• styles
• document formatting
• tabs
• numbers and bullets

Intermediate level

includes:

• Dates and symbols
• autoformat
• tables
• borders and shading
• headers and footers
• section breaks
• autocorrect
• autotext
• comments
• find and replace
• templates
• managing files

Advanced level

includes:

• Mail merge
• labels
• linking with Excel
• macros
• forms
• tracking changes
• document map
• indexes
• table of contents
• bookmarks
• footnotes and endnotes
• master documents
• word preferences
• macros

SuperTips

Learn lots of shortcuts and tips to help you speed up your existing knowledge of Word

(Back to top of list)

SQL Server

This course teaches you how to use the SQL language to query and program Microsoft SQL Server in a Windows Server environment.

(Back to top of list)

VBA for Access, Excel & Word

Gain an in-depth knowledge of the Visual Basic programming language to automate complex or repetitive.

(Back to top of list)

Visual Basic

Visual Basic is a fully featured programming language that combines a smooth learning curve with transparent integration of third-party components. As such it is the language of choice for many enterprise level application developers.

(Back to top of list)

Web site development

Whether you know how to click the buttons but need help with the principles of good web design, or you are a newcomer to web design and want to learn the rules before you start to design, this is the web design training course for you.

(Back to top of list)

Special introductory courses

• Understanding the PC and Microsoft Windows
• Using the Internet

…and more!

(Back to top of list)