Hi Dineth,

Because you have a set number of staff and fields and programs, Access seems appropriate. In Excel you will need to retype the staff, field, program, etc on each row to Pivot the data. Excel is easier to use and learn. More people know and use Excel than Access, ie more help with questions. Access is harder to learn. Pivots in Access can show text in the values while in Excel it can't.

I'd say to start collecting the data in Excel and Access can link to these Excel files and even convert or merge them (called append) into a huge table if/when needed.