Dear Experts
Thanks for truly useful links. I used them and my mind really cleared on the subject.
Here are the requirements:
Create the database for saving the data from individual student and grades and the faculties, department and … each student relate to it.
Each student has some personal information related to each person and some information about the faculty, department and so on.
I have to track which grades are for each student as well as each class grades apart from each other.
Moreover, the department relate to each faculty and classes in each department.
One more thing is penalty session. Each student that failed in two courses, he/she introduced to this session. The result of this session must be documented and the student must pass another exam or … .
Then I use another grade for saving the second or third grades each failed student received.
Please look at the relationship I produce for tracking these requirements. The attachment is the access file for looking at the relationship.
If something is wrong, please let me know because this database is my first work.
Thanks in advance
Afi

How do you plan to record the grade a student has for each of his/her classes? What is the difference between class and course?

I feel a lot of your relationships are backwards. For example, student and major. In your design, each major can only have one student. Also, each class can only have one student and each field can only have one student.

Again, I would recommend starting with the design I gave you; once you have that set up correctly, then work on adding the additional tables you didn't mention in your original post.

Here is my last attempt for creating this database please take a look at that.
Also How can i force the auto number to start from 1 after each adding and deleting records.

Thanks in advance for your helps.

Your database design is a lot closer to what I was expecting. Please note that my original design included course sections in case there were different sections for each course; if you don't need to track course sections, then your design is fine.

As far as the autonumber... the easiest thing to do is copy the table structure as a new table, delete the original table and rename the copy of the table. However, there shouldn't be any need to have the autonumber start at 1. The autonumber is usually used simply to track relationships between data.

Just join the grade table to the section table and then join that to the course table.