Setting up a Soccer League Database to Track Attendance

[Adidasmufc]

Let me first apologize if I am not in the correct thread but I couldn't find any threads which seem to match my problem.

My problem is this - I run a soccer league where we track players attendance for each game. I currently do it on a spreadsheet where each game date is a column and each player is a row. We also track which team they play on at each game (they can play on different teams different weeks). I currently have a second tab in the spreadsheet to record which team a person plays on each week.

Setting up a table of fields for this is relatively easy. The problem comes to data entry. I want to be able to visually see the data like I can in a spreadsheet (names in rows, dates in columns, intersections containing either team name or whether attended) and whilst a cross-tab query gives me the layout, I cannot input data in a cross-tab query.

Any general pointers?

I can provide an example of the database or spreadsheet if required.

 

[plog]

Yes, first and foremost is read about normalization (http://en.wikipedia.org/wiki/Database_normalization). If done correctly, you will be going from one or two tabs in a spreadsheet to 3 or 4 tables in a database with relationships to each other.

I'm sure something like this has been tackled before on this forum, make use of the Search function and feel free to post specific questions when you need help. Good luck.