Hi All,
I'm a complete novice and I need to set up a training database from scratch. I know what information I require but I don't quite know how to put them together, the database is needed to store Permanent, Agency & Contactors Staff. I need the database to be able to produce reports on how many courses were trained over each month, and the total duration of the course completed (in hours),
If anyone has sometime to help me, I would be very grateful.
I envision these tables:
tStaff
-------
firstName
lastName
StaffType - Agency, Permanent & Contractor
WorkLocation
WorkDepartment
TotalCostofTraining
Totalhourscompletedoftraining
tTrainCourses
---------
trainID
CourseCode
CourseName
CourseCostperDelegate
tStaffTrain (each persons training history)
---------
CourseCode
CourseName
DateOfTrain
DurationofTraining
RefresherDate
I would like to have it work by opening up a individual record and when you enter the course code the record automatically for some courses enters the name and duration of training, and automatically adds a refresher date.
If anyone up for the challenge of helping this damsel in distress I would be most grateful.
Thank you in advance