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?
Bookmarks