Hi

I am new to excel and was wondering if anyone can please help me setup a database for my business's membership please.

The way my membership works is the customer buys a membership from me,this membership is valid for 4 weekends every Friday morning to Saturday night.I want a way to enter all the members I have or new members to a database but I don't what to see the list of members except when I edit the list,on the main screen I would like a colum that has a place I can enter the members user ID and then there user ID plus the details I have entered are displayed on the main screen on the "active" screen so when someone buys a membership I enter his user ID and his details are displayed in the active screen.But in the same row I would like to enter the first Friday(first date) we have to activate the membership and he should auto fill the other 3 weekends we have to activate the membership.But we what the first weekends to become green on the friday morning and stay green till the sunday morning then be "turned off" and the date to show a line through it or something like that to show that that weekend is done and then do the same for the rest of the weekends but the first weekend should be green,second yellow, third orange and forth one red(the last one) except for the last one that should stay red with a line or something through it to show the weekend is finished but for use to know to take him of the membership the active screen,so when we take him of the active screen we shouldn't be able to she the non active members but there data should be there so when we see they have bought a membership we go to the user ID field and enter his user ID and his details come up on the active screen and we enter the first date and the rest of the dates are displayed and turn the color they should and after every weekend is done should show that weekend is done and the color of that weekend disappears except the last one to show we need to remove him from the membership.

If ANYONE can please place me on the right path or can PLEASE help me it will be greatly appreciated.

Best regards L_O_O_M