Home   About us   Contact   T & Cs   Search   Sitemap   News   Room Hire   Links  
Tutor Led Courses | Open Course Schedule  
[Back]
[Up]
[Next]
 Course Options
 
Open Public Courses
Tutor led public courses which are scheduled on a regular basis at our SE1 London training centre.

Company Specific Courses
Company specific courses are available for organisations that have several employees who all need training at the same time or the course required is not part of our normal Open Public Course schedule.  .
These closed courses are ideal where tailoring of the standard course content is required. When compared to the Open Public Course option, they typically provide cost benefits when there are three or more employees who need training simultaneously.
Courses can be run on-site if suitable facilities exist or at our SE1 London training centre.

One-On-One Mentoring -  Personal Coaching
Ideal for individual delegates who have a specific requirement from the software or where previous knowledge makes group training inappropriate. The pace and the content of the course can then be adjusted to the individuals exact needs.
 
Floor - Walking
Where attendance on a course may not be considered appropriate, our trainers will visit clients offices on an ad-hoc or regular basis, resolving  individual issues on a case by case basis - delivering quick training sessions on the "front line" at the desk.

 Other Options
In addition to classroom based courses, we also offer a substantial range of computer (CBT) and web (WBT) based training  courses. C/WBT are alternative education methods for those individuals looking for perhaps a cheaper alternative to traditional instructor led (ILT) training.

 

 

ECDL Logo

   
 Overview
 

A two-day course to develop further techniques for interrogating a database and for developing relational databases.

 Course Prerequisites
 

Delegates require a good understanding of the features detailed in our Foundation / Introduction course. Good keyboard skills are essential.

 Course Content
  Relationships

 

Review of database planning and developing a database's structure
Recognising and handling different types of a relationship
Defining relationships including Referential Integrity and Cascade Options
 

Advanced Queries

 
Join properties
Totals queries
Parameter queries
Query Wizards
Actions Queries to update, amend, delete and copy data 
  Forms Define and customise forms with subforms or linked forms
An introduction to using Form and Control properties
Unbound forms
Using forms to set query selection criteria
  Reports Multi-table reports with customised sorting and grouping
Calculated controls
Using Access functions
  Pivot Table Options Analysing data using Pivot Tables and Pivot Chart views
  User Access Using Switchboard manager
Custom switchboards
Start Up options
  Linking with other Office Applications Transferring data between Access/Excel and Word

All course contents are subject to change with prior notice.

 ILT Course Options Available
  Company Specific Course    
  One-On-One Course including mentoring, coaching and "Floor Walking"  

 Company Specific & One-On-One Course Pricing
  Access Company Specific Courses
  The price for company specific courses is £690 per day for up to 4 delegates, plus £65 per day for each additional delegate. If the course is run at our SE1 London Training Centre, there is an additional charge of £170 per day for use of the training facilities, lunch etc.
  Prices include all course materials and are exclusive of VAT. For courses run outside the Greater London Area at a customer's site, the trainer's travel and and any required accommodation expenses are charged extra at cost.
 

Request a Quote

  Access One-On-One Tuition - Mentoring, Coaching & Floor-Walking
  The price for One-On-One Tuition and "Floor-Walking" engagements is £590 per day.
  Prices are stated exclusive of VAT. For courses run outside the Greater London Area at a customer's site, the trainer's travel and and any required accommodation expenses are charged extra at cost.
 

Request a Quote

View a printer friendly version of this page in a new window.

View a printer friendly version of this page in a new window

[Tutor Led Courses] [Open Course Schedule]
 

 
© 1988 - 2008 Computer Literacy. All rights reserved