Database Problem

[darrel]

hi there vb masters. i have some few questions.. i'am building a time scheduling system for a school, its a subject time and rooms assignments, i have created my database now with access 2003, but i have difficulty on how i can populate. i hope you can picture what i'am trying to say. its like this i have a table created in access and it has all the subjects and units of all the courses in my school it is place in a table called "SUBJECTS", we have 9 different courses, and has 90+ different subjects. i know how to bind database with vb, i'am planning to use a ADODC for my database connection but i dont how i can able to able filter the data in my table "SUBJECTS", if the user of the system want to schedule the subjects and rooms for one course for a particular semester the must display it in one form or a grid maybe, that my problem, how? how can i do that there are so many subjects that are stored in my table, how can i filter it!

hope you understand my pro vb masters.. hope you can help me with this.


thank you in advance.

[debasisdas]

First of all u need to Normalize the database

then it will be easier to maintain.

and to filter, u need some simple SQL queries

thats all.

[darrel]

thank you for the advice,,, i have normalize my database.. but the thing is i dont have any background of SQL language,, can u site me some examples on how i can filter all my data in just a click... please i badly need your help! i hope you can help me,,, thank you!