Results 1 to 7 of 7
  1. #1
    JLMartin is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2018
    Posts
    4

    Creating List of Completed Training Credentials

    I have several tables:
    Employees - Name, address, phone, email
    Training Classes - list of all available trainings
    Positions - All possible positions


    Employee to Training - employee name, training attended, date completed
    Positions that can be credentialed - selected from positions
    required training for credentialed positions - position, class required, type II or III (lists each position multiple times and links to a required training)

    What I need is to show which personnel have completed ALL of the trainings required for a position, as well as who has started the process and what trainings are left to complete

  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
    Here is a draft data model suggested to a poster a few years back. It may be useful to you.

    Click image for larger version. 

Name:	EmployeePositionTraining.jpg 
Views:	23 
Size:	40.9 KB 
ID:	34899

  3. #3
    JLMartin is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2018
    Posts
    4
    Thank you. I have the tables linked. What I need is how to create a query that pulls the specific information for a report. I have attached the database for an example.EOC Staff Database Example for Forum.zip

  4. #4
    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
    What I need is to show which personnel have completed ALL of the trainings required for a position, as well as who has started the process and what trainings are left to complete
    What signifies training required for Position?
    How do you determine Position? Is that EOC Position? We only know what you tell us, so clarity/completeness is key.
    What does Agency mean with respect to Position?

    Does this query identify all Training for Each Position? It shows 1119 Position*training combinations.
    Code:
    SELECT 
    [EOC Positions].Position
    , [Credential Training].Requirement
    FROM 
    [EOC Positions] INNER JOIN [Credential Training]
     ON [EOC Positions].ID = [Credential Training].Position;
    What does this requirement really mean ICS-200/IS-200?

  5. #5
    JLMartin is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2018
    Posts
    4
    There is a table of "Positions" which is what we call each position in our EOC
    There is a table of "Credentialed Positions" which is what the state calls the positions that they offer credentials for.
    The state has provided us with a list of the training for each position for a Type II or Type III Credential.
    On the personnel table the only important field is name. Agency is which County department that person normally works for.
    We assign EOC position based off normal job duties and skills, but anyone can receive training for any position they wish to be credentialed in. For instance, I am credentialed in 3 positions.
    ICS-200/IS-200 is a class that can be taken online from two different agencies (ICS is from the state, IS is from FEMA, but either class meets the requirement)

  6. #6
    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
    How do you uniquely identify Employees
    given this brief count of Names

    First Name Expr1
    Mike 6
    Kevin 5
    David 4
    Jason 4
    Mark 4
    Jeff 4
    Amy 3
    John 3
    Michael 3
    Joe 3
    Rob 3
    Jennifer 3
    Russell 2
    Cory 2
    Marilyn 2
    Chris 2
    Pete 2

  7. #7
    JLMartin is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2018
    Posts
    4
    I have removed it from this example, but I have last names as well. there is a field titled "full name" that combines first and last name on the personnel table

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

Similar Threads

  1. Replies: 2
    Last Post: 12-11-2016, 01:01 AM
  2. Replies: 2
    Last Post: 05-11-2016, 03:44 PM
  3. Replies: 2
    Last Post: 08-13-2015, 02:14 PM
  4. Replies: 1
    Last Post: 06-18-2014, 12:19 AM
  5. Replies: 3
    Last Post: 09-25-2012, 05:24 PM

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