help me making database for trainees and courses (1 Viewer)

[abubasil]

Hi everyone
I hope this is the right place for this post and it won't be deleted
I need to create a database that manage the courses and trainees, I made one myself but couldn't get it works properly, there must be table for courses contain course_id,course_name, date_start_,date_end, lecturer_id ; another table for lecturers and and another for trainees.Of course there must be relations between these tables , I made them too, what I need is to make the search-based reports that depend on date , course name,lecturer , I also have search the net but couldn't find the suitable projects
thank you in advance
(Access 2003 is preferred)

 

[jdraw]

There are free data models at www.databaseanswers.org

This one may be helpful to you
http://www.databaseanswers.org/data_models/student_rosters/index.htm

 

[abubasil]

Thanks ALOT
that was wonderful site.
I did my best and made this database in the attachment, it was written in Arabic but I've translated it so fast , this time it deserves your attention
I still have some problems the fast search returns duplicate values
and I have no idea which is better building reports or exporting results into MSword

 

[abubasil]

For my own sake this is the final touch

 

[jdraw]

I downloaded an opened your data base, but got the attached error message on opening

 

[abubasil]

press shift as you open the database so as to enter and make changes
I'v used some short script that hide the menus of access 2003, this is the only thing in open form event , remove it

 

[jdraw]

see Martin Green's site for ideas to making a dialog form to select reports based on criteria

http://www.fontstuff.com/access/acctut19.htm