Setting up of a training database

[Maxine]

Hi

I am new to access. I need to set up a training database for the company.
I need to have info in there on type of training,training provider, duration,
cost ect. Is there a template I can use if not how do I start this database.

I must also be able to draw monthly stats so we can see how many employees
went on training, type of training, hours/days away on training, gender, race
ect.

Is there anyone that can help me.
thanks

 

[Paul Yhonquea]

What type of data will you need to track? Employees/Trainees? Will there be
any information about the trainees that may need to be recorded/tracked?
Will this be a database that will be used by only one person or multiple
users?

The first thing you would want to get together is what type of data you want
to store: Names, addresses, department, contact info (email, phone), training
type, dates and times of training, training provider info, etc. A lot of
this stuff may need to be in different tables, such as the training provider
info (Name of company, address, trainer, phone, etc), employee info, etc.


If you need more help, let me know. We may be able to work on it together.

 

[scubadiver]

You are looking at a project of at least 6 months development if you want to
learn. I tried designing a training datatabase in a previous job and it is a
lot of work. Unfortunately I don't have the database any more.

The best way to start is write down in plain, simple English what you need.
To start off with you need a table for

Employee information
Trainer information
Course information
Training location information

Each employer can attend many courses
Each course can have many employees

Each trainer can train many employees
Each employee can have many trainers

Each trainer can teach many courses
Each course can be trained by many trainers.

Each course can be held in many locations
Each location can have many many courses

Each of these pairs needs a junction table

 

[scubadiver]

On top of that you have departments?

Do you have core courses that everyone must attend? Things like Health and
Safety, fire, induction courses etc etc.

Are certain courses associated with certain departments or would you base it

 

[RH]

I'm working on a training database now as well. You'll also have Training
Subjects that require recertification; ie; HAZMAT 24 Hr Training requires
recertification every 12 months. I'm having a difficult time trying to
determine the best keep up and tie together the initial "Training Subject"
with "Sub-Training".

 

[RH]

Also, If you use a different "Training Provider" to perform the training,
they may give you a certificate with a "Training Subject" that's totally
different from the original training; i.e., Forklift - Train-the-Trainer from
one "Training Provider" and "Coaching the Lift Truck Operator".

 

[KARL DEWEY]

Some make take a course that is not a requirement for them - fill vacant
class position - but you want to record and not require recertification.

 

[jerseygirl54]

Hi Maxine -

I too needed a db for training (Police Dept). I searched without sucess
until I decided to use the "Classroom Management Database" template from
Microsoft (Access 2003). I was able to tweak it to work for me. With a
little help from friends in this forum, I have a simple, but workable
database!

Good luck!