Display latest date from many in datasheet

I've been developing my database with the assumption that this could work, but I don't actually know for certain so I thought before I continue I'll make sure it's still possible.

I've currently got a spreadsheet, with employee names on the left column, and varying qualifications on all other columns. This spreadsheet displays expiry dates for these qualifications like so:

Name	First Aid	Fire Safety	Vehicle Checks	Driver Assessment
Joe	11/01/15	21/06/15	07/09/17	08/08/19
Steven	11/01/15	25/06/18	16/09/15	30/04/14
Daniel	05/05/13	12/12/14	09/10/19	15/01/14

The problem with this method of saving information is if someone does multiple First Aid courses (or fire safety etc.) the latest one with the latest expiry date is show, and there's no record of that employee doing a course more than once.

So that's why I'm moving to access, with normalised data:

Name	Date Exp	Qualification
Joe	21/06/15	Fire Safety
Steven	16/09/15	Vehicle Checks
Daniel	05/05/13	First Aid
etc	etc	etc

This will now show all the (many) courses they've done and repeated.
But to stop repeated data in different tables. I need to use the normalised table to present a table like the first one, displaying only the latest date.

Is this possible?

You need to tables, tEmps, and tEmpTraining.
the tEmpTraining would track each emps training dates as 1 to many.

Name Date Exp Qualification
Joe 21/06/15 Fire Safety
Steven 16/09/15 Vehicle Checks
Daniel 5/5/2013 First Aid
Joe 20/06/14 Fire Safety
Steven 11/9/2014 Vehicle Checks

Yes I know that. What I'm trying to do is from my many table, is it possible to create a datasheet that looks like my first (unnormalised) table I've shown; displaying the latest date for each qualification

That's not the problem that I am facing at the moment. Although huge thanks for that code as I've still got a lot more data to normalise.

The problem I have is, from my normalised data (which I already have, tblEmpTraining), I need access to be able to build a datasheet that looks like my un-normalised table I showed in my original post.

Thus will be able to show everyones name per row and the date they did their each qualification per column.

N.B I don't need access to automatically add the columns, as I will have pre-made the columns, I just need access to show the latest date the employee did for that course


You might suggest I do a pivot table and change the values of dates from sum to max. But the problem I face with that is I need to build several different datasheets from tblEmpTraining, and these datasheets are depended on another field from tblEmpTraining which is a check box label 'Is_course_CPC_approved'.

So one datasheet will show all the dates (like what a pivot table will do), but another datasheet will only show the dates that have Is_course_CPC_approved marked as yes.

I hope that explains everything.