Share via

Creating a Database for Trainees

Anonymous
2018-08-03T02:30:33+00:00

Hi, I work in the training arm of a local company. I am attempting to build a database in Access 2016 to create and maintain trainees' training records. We have past data to input, as well as new data to enter into the database.

Our system is structured in a way that a bunch of courses with different course codes make up one curriculum. A trainee is supposed to complete the curriculum before being marked as completed. I would like to be able to see what courses a trainee has yet to complete for his job title, as well as the courses he has completed.

Please bear in mind I have no Access experience, and neither does anyone in my office. That being said, after reading the forums and watching some videos, I gather that I would need tables for "Curriculum", "Course", "Personnel Info". I am still in the process of learning about queries and relationships but I am struggling with this part.

My questions are - am I on the right track? And how would I link the "Course" to "Curriculum", and for the "Curriculum" to count the number of completed/incomplete courses for the job title, so that it would appear in the "Personnel Info" table as completed or not yet completed his training?

Thank you for your help and advice.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-08-03T05:22:10+00:00

    Hmm, you are missing a few tables there.  Have a look at...

    https://www.access-diva.com/dm7.html

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-08-03T03:19:46+00:00

    Hi Tom,

    Sure, here are all the tables I have.

    CompletionStatus

    Course

    Curriculum

    Personnel

    Let me know if there is anything else I should show.

    Thank you!

    Was this answer helpful?

    0 comments
  3. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2018-08-03T03:13:26+00:00

    Can you please add all tables to the diagram. It helps in the future conversation.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-08-03T03:07:39+00:00

    Hi Tom,

    I literally have almost nothing, just this:

    To be honest, I have no idea if this is correct.

    I added a "CompletionStatus" table with the values for Completed, Incomplete, and Waived since these are the only three values for course completion. Not sure if this is required though?

    Was this answer helpful?

    0 comments
  5. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2018-08-03T03:00:24+00:00

    Can you please post a Relationships diagram of your database, so we can understand what you have so far?

    Was this answer helpful?

    0 comments