Help with football database

[dc123]

Hi, first of all sorry if I posted this in the wrong section, but I think I'm ok!

Secondly, I don't have much knowledge in access, so anything may help me

I want to create a football spreadsheet something like this one:
http://www.databasedev.co.uk/user_interface_3.html

It doesnt need to be too similar, but it needs to have somewhere for the user to put in results of matches - like on the form on that one.

All I have so far is two tables - one for team names and one for player names.

Do I need to make a form as a place where results can be put into the database?

Also, I need to create a league table, based on the results. 3 points for a win, 1 for a draw (real football rules) but I don't know how to make the table. Would it be a table, a query, a report? I'm clueless on that part really So any help would be good.

Any help on the relationships I need would also be great

 

[dc123]

Anyone? Any help at all....

 

[Mile-O]

You probably aren't getting a response because it's one of those questions that comes up time and time and time again. I'm sure if you had just went to the forum's search function and entered 'football database' you would have had a plethora of results to aid you.

 

[dc123]

Sorry, I did search, I spent about an hour looking through it all and it helped me with some things -but not with creating the league table.

The trouble Im having is that I dont know how to make a league table at all, whether its a form, query or table, and how to get the data.

I need it to calculate Games Played, Wins, Draws, Losses, Goal For, Goals Against, Points.

So, for Wins, it might be something like
iif([Results]![GoalsFor]>[Results]![GoalsAgainst],1,"")

If Results was the name of the table and Goals For and Against was as they say. But I dont know how to do that - I dont know if i'm using the iif function correctly and I dont know if it should be "1" if true - as it needs to add one every time there is a win.

Sorry its not a very clear explanation.

 

[Mile-O]

The trouble Im having is that I dont know how to make a league table at all, whether its a form, query or table, and how to get the data.

I need it to calculate Games Played, Wins, Draws, Losses, Goal For, Goals Against, Points.

Having never made such a database, I can only speculate. The way I would do it is to have tables for matches, teams, fixtures, and players (if you want that level of detail).

Your league table would be calculated upon the information held in the fixtures table.

 

[Red_Roo]

I have decided to teach myself HOWTO use MS Access 2003, by creating a Football Tracking Database. I have developed a manual system that has worked perfectly for me for the last 2-3 years.

I decided to automate it by creating a database in Access 2003.

How did you go withy your attempt?

Regards

Red_Roo

 

[statsman]

Your Teams table should consist of the following:
TeamName - Text
MatchesPlayed - Number
MatchesWon - Number
MatchesLost - Number
MatchesDrawn - Number
GoalsFor - Number
GoalsAgainst - Number

For your teams input form, use an option group to record the match result (as there is only 1 of 3 possible outcomes) and add the Goals For/Against.

 

[statsman]

Having a look at the database on your supplied link, why not just buy it (unless the cost is prohibative).