Build a Database

[xeen20]

Hi,
I'm new to access, i have a class project to be submitted soon. i am really trying to do my best to complete that but i couldn't. i thought of take some help from u guys
The Project is just like a library project.
where we need to maintain the students records.

The students gives a book to covert into different formates like word, text, rtf, Audio. etc

so 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.

i have to do two serch options
like
1) if i type the students name i need to get the books he has given to covert.
2) if i type the Book title i need to get the students names who gave the same book. ( 1 book can be brought by many students and one student can bring many books)

i have to create a report at the end like
how many students brought how many books

i am attaching what i have done.
plz help me in completeing my project

 

[selvsagt]

Hi.

Your design does not support many-to-many, a student can bring more than one book, and a book can probably be brought by many students.

A course probably has more than one student, and a student probably attends more than one course.

I have added 2 tables in your db, and changed the relationships so that it supports many-to-many relations.

I have not altered any of your forms and queries, and your probably have to redo a lot of work.

 

[xeen20]

Thank You for the reply.
To be frank i am very very new to ms access. I am using Access from only 2 weeks. I have gone through urs table and relations. But i could not get into my week brain. When i saw the tables i found sudents id, and book id but we are not entering those infomation into table.
Could u explain me why cant i do only with 3 tables as i posted, sorry if this is a basic question.

 

[The_Doc_Man]

Using your browser, Google-search (or other favorite search engine) for topic "Database Normalization." Use Access Help on this subject too. You can do with 3 tables if and only if you don't care whether the DB is properly designed.

 

[xeen20]

Can this relation be used to get :
1 course can have no of book.
Add i would like to know how to create a form to enter all the data(Fields) once.
and how can i know whether the student i am entrying is new or old i.e ( have i already entered the students info)
i need to do like
1)i need to create a form to enter all the feilds.(first form
2)search by first name : to give only book title( sencond 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.

Plz give some guide lines so i can research and do.. i am working from 2 week and there is no progress in my work.
thanks in advance.