SQL Server - How to create a Table for the Following Details.

Asked By aman on 10-Nov-11 09:33 AM
hi all,


i have to create a Table soo that i can bind the data to the form  like following diagram.



please help me.

 thanks,
dipa ahuja replied to aman on 10-Nov-11 09:53 AM

Firstly you have to desing the database structure: 

tables will be : 

1. Users, 

2. Question/Ans , 

3. Result , 

4. checking

in user records of users who are giving test, question ans where you can store your all question and answers, then in checking check the ans which user has given and finally the result which contains result of users.

Now after creating Databases and table work on design of forms how much forms you will need which controls you required.. for question you will take lable and for options you can take radioButton list so user chose 1 option from that option.

Do this and then move to programming code 

Hope you get idea :)