Spreadsheet or Database

[HappyChappy]

Consortium spreadsheet traffic lights 2.docx.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Centre	Start Date	Number of Trainers	Activity	Jaupt Audit			Consortium Audit			Attendance sheets		Course bookings			Processings	Training Courses	Complaints
2					Requirement Notice	Action Points	Continuous Improvements	Requirement Notice	Action Points	Continuous improvements	Incorrect	Late bookings	Under 48 hours	Not booked	Not Cancelled	No Bus/Lorry	Repeated
3	Driver CPC 4U Ltd	01/09/2010	5	weekly		1	2				1	2	4	3	1		13
4	CM00475/11
Sheet1

Hi been tasked with setting up a 3 year rolling account of members possible 400 who will be given tasks to complete and scored on weather they achive them this will be shown as a traffic light RED AMBER GREEN
after one year points will deminish by .50% after two years 75% and after 3 years 100% is this something which requires a database route or can it be done with a spreadsheet solution.
The aim is to be able to keep track of who is RED, AMBER, or GREEN at any one time.
Thank you.

 

[HappyChappy]

Which way should i be leaning to Excel or Access?

 

[HappyChappy]

Lots of views but no advise.. Which way should I go Excel or Access?