Results 1 to 3 of 3
  1. #1
    nidecker is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2019
    Posts
    2

    Candidate Qualifications - Multiple Prerequisites

    I'm trying to set up an employee training database.

    I have an employee table, courses table, and training records table.

    I would like to create a query based on several required courses being completed, and set the expiration date for the qualification based on the most conservative training date.

    I'm not sure how to go about this, but I would like something like this where Qual_1 = Course A + Course B + Course C.

    EmployeeTable
    EmployeeID_PK FirstName LastName


    JSmith James Smith

    CoursesTable
    CourseID_PK Validity
    CourseA 12 months
    CourseB 12 months
    CourseC No Expiration

    TrainingRecordsTable

    EmployeeID_FK CourseID_FK Date Taken
    JSmith Course_A 7/13/2019
    JSmith Course_B 7/10/2019
    JSmith Course_C 7/12/2019


    Desired Query Results:

    EmployeeID Qualification Expiration
    JSmith Qual_1 7/10/2020

    Do I need to create a separate qualifications table in order to perform this query? or add the qualification to the courses table? or use some kind of if statement in a query to get the results I'm looking for?

    I have several qualifications that I will need to create, some require only one course and others require two or more courses to satisfy the qualification. Some courses have an annual retraining requirement and others are valid for lifetime of the employee like Course_C in my example.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Is the training required associated with employee/position as
    in diagram?

    Click image for larger version. 

Name:	EmployeePositionTraining.jpg 
Views:	10 
Size:	40.9 KB 
ID:	39075

  3. #3
    nidecker is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2019
    Posts
    2
    Quote Originally Posted by orange View Post
    Is the training required associated with employee/position as
    in diagram?

    Click image for larger version. 

Name:	EmployeePositionTraining.jpg 
Views:	10 
Size:	40.9 KB 
ID:	39075
    Some of the training qualifications required are tied to the position and some are required of all employees.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Candidate Qualification Database
    By Talion78 in forum Access
    Replies: 1
    Last Post: 07-12-2018, 02:47 AM
  2. Replies: 6
    Last Post: 02-12-2018, 12:01 AM
  3. Replies: 3
    Last Post: 01-05-2018, 07:41 PM
  4. Replies: 14
    Last Post: 03-21-2017, 07:00 AM
  5. Replies: 1
    Last Post: 08-06-2014, 02:22 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums