Problem with saving Records

[xeen20]

Hi all,
I am new to Ms Access and i am doing a class project now. can anyone fix the saving record problem. the add form in the attachment is not working correctly. i gave some fields to be compulsory but sometimes i could see some blank coulmn in the tables.
Some friends here advice me to change the Relations of the table but i havent done that because i am really short of time and even i could not understand how to do that.
i would like to explane my project here:
i need to create a database to store all the information.like

Student name details, course he is taking, book details he has given, and formate to covert.
1 student can have any number of books
1 student can take any number of courses
1 course can have any number of books
1 course can any number of students

and

1)i need to create a form to enter all the feilds.(first form)
2)search by first name : to give only book title( second Form)
3)search by Title: to get all the information like students detail, course and book details(Third form)
4)Delete fuction, edit function.
5) generate a report showing no of students and no of books for quater
6) export few few coulmns from all the tables to one excel sheet.

I already posted my Problem in Theory and practice of database design

But i am not sure i have posted in right place or not.so i am posting it again.

 

[RuralGuy]

Your honesty about the class project is appreciated *BUT* it is not fair or useful that someone here do the work. There are tons of people here that would love to *help* and *teach* some techniques about Access and VBA but will need something specific to work with. Your request is very general. Do you have something specific that we can help with?

 

[xeen20]

Thank you RG for understanding.
i am attching the details of the project