Search results

  1. A

    Question Access Training Database

    The examples you gave are correct. My concern is that I would need to modify a lot of things every time one of the 140 different training courses is updated. Like forms and other points of entry. Or is there a way to ease that pain. My purpose for creating this is to make training audits a...
  2. A

    Question Access Training Database

    That would be correct. My problem with that would be during data entry. I wouldn't want to be constantly updating forms to the current version of the training if possible. There are about 140 different training courses in my department and I would like this database to be a low maintenance...
  3. A

    Question Access Training Database

    Mark, #3 is correct. Training is normally good for 5 years. Revisions would make that timeline shorter. I supervise a Manufacturing plant and want a better system to help keep control of my employees training. Thank you in advance!
  4. A

    Question Access Training Database

    The Revision Date and Revision # are done when work processes change to ensure that the employee understands the slightly modified tasks that they need to complete. The overall TrainingID will stay the same, but all employees that have taken the course previously will need to retake it to be...
  5. A

    Question Access Training Database

    I hope this works, hopefully I have attached an idea of the design using your structure.
  6. A

    Question Access Training Database

    jdraw, I feel that your description is nearly exactly what I am trying to do. I guess I am still trying to get the basics down for how to structure everything and then link the needed parts together. On your model, would it be possible to have a revision of training that would use the...
  7. A

    Question Access Training Database

    Basically I will have the following major categories: EmployeeTable EmployeeID FirstName LastName Position Shift Active TrainingTable TrainingID TrainingDetails TrainingRevisionDate TrainingRevision# My confusion at this point would be linking this data so that each position automatically...
  8. A

    Question Access Training Database

    Hi, I am attempting to build a database that will track training of employees in my department. I am struggling with some things in the creation part of it. My struggle is that I am needing to have about 70 different training courses (each course would have a Revision date and revision #)...
Back
Top Bottom