Please help me!!

[Coach]

Hi guys so basically what i have to is to develop a sample MS Access database for organizing the football league. The database should be able to generate reports such as:

- A list of teams ranked by number of wins
- A list of bookings and suspended players
- A list of the most popular venues
- A list of fixtures with the assigned referee to each
- The League Table
- Schedule/Fixtures which would prevent double booking; there are only
3 locations/facilities where the games can be played

In addition, the administrator requires the following capabilities:
- Add teams and referees to the system
- Delete teams and referees from the system


It's a college project, but the things is that i have never worked with Microsoft Access before and i don't know really where to start and in what way it should be completed. Could u give me any tips or advises for how to start this bloody thing cause i really don't have any idea of access.
I also looked up some of the topics on this forum related to my project but unfortunately they aren't any help for me...
I would be very grateful for any help
Thanks !!

 

[neileg]

Do a search. Lots of football/baseball/cricket league table questions in these forums.

 

[John_W]

Coach

You could start by creating tables to store data on:

Teams
Players
Referees
Venues
Fixtures

Think about the relationships between those tables, what data you need to store in each and what fields will provide the links between the tables.

 

[Mile-O]

Why would you get a college project to do in Access if you have never used Access? Surely something is going wrong there? Or do you mean that by never using Access you just haven't turned up to the classes?

 

[vangogh228]

A search on this gives dozens of threads.

 

[Coach]

Vangogh your right search engine shows a lot of threads but some or none of them is directly related to my project. There's nothing said about preventing double booking, adding/deleting teams/referees to the system or how to generate those reports. I'm a complete novice and it's really hard for me to figure out anything from other threads.

SJ McAbney this project is for MIS (Management Information Systems), we actually had few tutorials and we were able to work with Microsoft Access but this stuff wasn't exactly very practical and useful. Most of those problems were financial based and had rather nothing to do with Organizing a Football League.