Newbie and I need help

[Neli]

Hello!

I have just started exploring databases and I am very new in the area. However, I have this quite advanced (to me anyway) task where I have to create a form for a rather large database.

The database in question is about Soccer and the organization within, and the form needs to be able to register teams to tournaments in a good way.

I have no real experience with forms, and this seems alien to me. Anyone who can help me out here?

I can provide my database for you if you want.

 

[dkinley]

Check out these links - they should get you started down the right - and correct - path for db development. Also, would be a good idea to check the local library for books, etc.

http://www.techonthenet.com/access/index.php
http://www.sienaheights.edu/personal/csstrain/Access2007.htm
http://www.functionx.com/vbaccess/
http://knol.google.com/k/andrew-comeau/data-entry-in-microsoft-access/35v6n7dr8r5i3/7#

Please post back if you get stumped on anything. Good luck!

-dK

 

[Mike375]

It sounds like you would have a main form that was based on Teams and a subform based on Tournaments.

Search on One to Many Access and also Normalisation.

Basically a Team might have 8 tournaments. The 8 tournaments are 8 records that relate to that team and they are linked by and ID field. The subform displays the tournament details in a tabular format.

 

[DevastatioN]

I think it may also be the inverted way, he may have a main form where he can add and edit tournaments, and then a subform where he can select each team that is signing up for the tournament.

The one to many relationship would still be the same I believe, each tournament can have many teams signed up.