So... what... you need help to learn Microsoft Access? I would be looking for "microsoft access training" in google, not on a forum
Makes me want to finish mine though
You could post your ERD (relationship window) and a statement of what it is you are trying to achieve with the database and I am sure you would get tips that might nudge you in the right direction.
Try to bear in mind that not everyone knows what you are really trying to do. For example, you said you would like to track Activation Date... what exactly is an activation date when it comes to lotto? Same with "settlement date".
And glad to hear you are sticking with it and not reverting back to Excel!!