By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

Database Problem

P: 72
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.
May 3 '07 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
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.
May 3 '07 #2

P: 72
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!
May 4 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.