Print PDF
Print Page

Pringle Training

Bookmark and Share

Microsoft: Access

IT Training Courses General

IT Premium

Microsoft Access Training CourseAccess is a great tool for database development if used correctly. PCS has a dedicated Solutions team that provide commercial systems for many international clients. Utilising the knowledge and skills of our PCS Solutions team we offer 5 stages of training which will give you the tools you need to be able to quickly master this industry standard database application.

ITD04 Stage 1: Inside Access (Introduction )

Scheduled Training Courses

 20/06/2012  20/07/2012  20/08/2012  20/09/2012  19/10/2012  20/11/2012  20/12/2012

This training course can also be run on request as a One to One or a Classroom Booking.

Overview

The first stage aims to give users the knowledge and confidence to start using and understanding Access databases. This part explains the differences between flat and relational databases with primary and foreign keys. This will help the user to learn and understand database structures and start producing linked Tables – Queries – Forms – Reports. Even people with previous Access experience will gain invaluable, practical knowledge from the experience and expertise of our PCS trainers.

(Courses Overview)

ITD05 Stage 2: Relationships (Introduction )

Scheduled Training Courses

 21/06/2012  23/07/2012  21/08/2012  21/09/2012  22/10/2012  21/11/2012  21/12/2012

This training course can also be run on request as a One to One or a Classroom Booking.

Overview

Anyone can use a wizard to create a database but how do you amend what has been created? Even though Stage 1 covers topics such as “1 to Many”, this course is based on how to set up and start using a working relational database. The course concentrates on different types of Relational joins 1 to 1, 1 to many and many to many.

(Courses Overview)

ITD06 Stage 3: Queries And Reports (Intermediate )

Scheduled Training Courses

 24/05/2012  22/06/2012  24/07/2012  22/08/2012  24/09/2012  23/10/2012  22/11/2012

This training course can also be run on request as a One to One or a Classroom Booking.

Overview

This course is aimed at users that have attended the previous stages or who are very experienced and understand Primary and Foreign Keys (1 to Many). This course is perfect for people needing to question, append, delete data and produce professional reports on an existing database.

(Courses Overview)

ITD07 Stage 4: Forms that Work (Advanced )

Scheduled Training Courses

 23/05/2012  23/07/2012  23/08/2012  23/10/2012  23/11/2012

This training course can also be run on request as a One to One or a Classroom Booking.

Overview

Creating user-friendly forms is sometimes very hard to achieve. This course uses all the experience from the PCS Solutions team by showing all the possible and impossible solutions. Introducing Macros and subforms from queries.

(Courses Overview)

ITD08 Stage 5: Access Masterclass (Advanced )

Scheduled Training Courses

 24/05/2012  24/07/2012  24/08/2012  24/09/2012  24/10/2012  24/12/2012

This training course can also be run on request as a One to One or a Classroom Booking.

Overview

This course takes every element from all the previous stages to the next level. One of the main topics covered is Embedded SQL Queries into Tables, Forms and Reports. The techniques learnt will enable a User to create a more stable solution, with a rapid reduction on debugging as well creating alibrary of resources that can be re-used within future development projects.

.

(Courses Overview)

Find Training Courses

Search The Pringle PCS Training Brochure View All Training Courses

Single Booking £175.00

£105.00 40 % Discounted Price
Normal Price £175.00 ex vat  
One delegate in a mixed group at Skywalker House
*Discounts Apply When Booking More Than One Person On The Same Scheduled Course

One To One

Price £395.00 ex vat  
One delegate one trainer either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House

Company Classroom

Price £445.00 ex vat  
A dedicated trainer for your company either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House