Access courses are delivered at Introduction and Advanced levels only.
The Introduction course is structured to enable delegates to create a database from scratch. Explored, in depth, is how to build Tables, Forms, Queries, and Reports and then to use database tools to establish relationships between these objects.
Advanced level develops further that which was learned in the Introduction course. Delegates learn how to generate interactive and automated objects, such as Forms; as well as developing Queries to perform actions. The course also deals with working with Macro and Command Buttons to automatically perform various procedures.
Introduction, Intermediate and Advanced levels of Excel are offered.
Introduction level provides many useful hints and tips and teaches how to correctly write formulae and analyse error messages. Intermediate level further develops the use of Functions for calculations and demonstrates how to use workbooks more efficiently. Advanced level deals with data analysis features and Pivot Tables. It also takes learners to a position where the principles of multiple-function formulae construction are explored that can be applied throughout Excel.
This course in invaluable to organisations upgrading to the latest version of Microsoft Office. It has been proven to successfully enable learners to make the transition with very little disruption to their workflow. The course provides insight into the latest innovations in Excel, Outlook, PowerPoint, and Word applications. Many useful pointers are given for customising windows and setting-up each application so that it works better for the individual. Customers can nominate which sections should have greater emphasis placed on them and, as further support, floor-walking support can also be requested.
This is a comprehensive course that shows how to customise Outlook so that it works better for the individual. Starting from identifying lesser-known methods of setting-up and using mailboxes and folders more efficiently and looking at messaging aspects and options, this course goes on to explore effective time management; how to share Calendars in various ways, setting up Appointments and Meetings, and comprehensively deals with Personal and Assigned Tasks. Our feedback shows that even experienced Outlook users find the shortcuts and hints and tips a revelation.
These courses are delivered at Introduction and Advanced levels only.
The Introduction course will build a presentation from scratch. Delegates will use different methods of formatting and will create and use many features such as Charts, Organisation Charts and basic Transitions and Animations. Hints and tips can be cross-referenced to other applications like Word. Advanced level develops a more sophisticated slide show including hyperlinking to various destinations and linking with other programmes such as Excel. More complex use of Animations and various ways of enhancing and delivering presentations are also explored.
The Introduction course is for novice users and shows how to manipulate and format text in a document. Terminology is explained, the Word window is customised and hints and tips are given to make using the application easier. Intermediate level looks at the use of Templates, developing Macros, and using Styles effectively are covered. Advanced courses are for those who are creating documents to include a Table of Contents, an Index, and Cross References. Advanced level also demonstrates how Outline View.