I recently have made a Lifeguard Employee Management Database and I am in the process of changing some small things for the better.
I wanted to add a constraint to the Date Column for example.
current date is November 29th, 2016
If (the current date) is approaching the expiration date of the employee by 4 months,
Change employee date Cell to RED
Lifeguard certifications expire after two years. I have their expiration dates in the "lifeguard Expiration Date" column and would like to have a better visual cue when they will expire.
It has been an easy journey to make the database but the code behind access is what gets me.