need help with me project plz

[The_Prince]

hi every one,
how r u all
i really need your help
i asked my friend and he told me about u guys
my problem is :
i want to create a database for entering student marks ^^
but i don't know much in access so could u plz help me
i want to u make the Relations so that i can make any form to enter the data i made the relationships but there is problem " i can't enter marks for new student "

Please help i have to submit it this Saturday

i will appreciate for u guys if u make as soon as possible

The prince

this is my file

http://www.tntup.com/file.php?file=1fa534bffc053e8cc460cb9d27c34c5c

 

[DJkarl]

Here's a free Access tutorial to get you started.

http://www.functionx.com/access/index.htm

 

[HHUK]

Asamalaycum,

I think you need to look at your databases abit.

Students is fine at the moment.
Teachers/Subject repeat each other abit.

I would do:

Students table
Subjects table
Lessons table

The Students data you have is held in students.
Subjects contains subjectID, subject name and teacher's name.
Marks would contain lessonID primary key, a students foreign key and a subjects foreign key.

Your marks table would be your "transaction" table.
You would make a form based on the marks table, with a dropdown which looks up the student table and gets the names.
You could then have another dropdown which looks up the subjects from the subject table.

When you get more experience with relationships and lookups you can start to make everything more based on it, e.g. you could make a nationality table and when you make a form to add new students you could choose the nationality from the dropdown.

I'd explain about relationships but I need to leave the office now, good luck on this.

 

[The_Prince]

thanks alot guys i really appreciat it.

dear Mr.HHUK
u r right and i understand what u wrote i will try to make and i will upload it again


but i have a question what should i put in lesson table???


thanks again for ur time