|
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. |
|
|
 |
|
|
| 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. |
|
|
|
|
|
|
Microsoft Access 97 & 2000 - Foundation
(2 Days) |
|
|
A two-day
course suitable for new or inexperienced Access users to
gain experience of building a relational Access
database. |
|
|
Delegates
require a good understanding of PCs and familiarity with
the use of a keyboard and mouse. A basic knowledge of
Windows is assumed. |
|
|
 |
create the
foundations for a database system |
|
|
 |
add, edit
and delete data |
|
|
 |
select
information based on specified criteria |
|
|
 |
create entry
forms |
|
|
 |
design
presentable reports |
|
|
Introducing Databases |
 |
Flat-file
and relational databases |
 |
Plan a
simple one-to many relational database |
|
|
The Basics |
 |
Start
Access, start a new database, the Database Wizards |
 |
Open and
close a database |
 |
Access
2000 - Personalised menus and toolbars |
|
|
Tables |
 |
Create and
amend tables |
 |
Define fields
and use field
properties to improve data-entry and
performance |
 |
Primary keys
|
|
|
Datasheets |
 |
Add, modify,
delete and view records |
 |
Use the
Find, Filter and Sort features |
 |
Change a
datasheet's layout |
 |
Print a
datasheet |
|
|
Basic Select Queries |
 |
The uses of
select queries |
 |
Create, save
and modify a select query |
 |
Set sorts
and selection criteria |
 |
Include
simple calculated expressions |
 |
Print a
query's output |
|
|
Forms |
 |
Create forms
using Form Wizards |
 |
Basic form
editing |
 |
Data-entry
in forms |
|
|
Reports |
 |
Generate
reports using Form Wizards |
 |
Grouped
reports |
 |
Basic report
editing |
 |
Add
calculated expressions to reports |
 |
Print
a report |
|
|
The Multi-Table
Environment |
 |
Plan and
create a related table |
 |
Define a
basic one-to-many relationship |
 |
Use the Form
Wizard to set up a form and subform |
 |
Write
queries/reports using related tables |
 |
Access 2000
- Use subdatasheets |
 |
|
All course contents are subject to change
with prior notice. |
|
|
|
 |
 |
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 |
[Tutor Led Courses] [Open Course Schedule]
|
|