Sir, My room partner and i are making a project named 'online examination' in which we require to connect to access. we are planning to get questions from records in access files. but i don't know how to fetch records from access tables. can you please help me. i know it is not possible to learn database connectivity in a single answer. but if you can suggest some methods, it will be helpful. Also if you can suggest another way to get questions in the forms, please suggest. Thanks a lot! NdAkOtA
Code: Select * from Questions should give you all the questions from the Questions table. Instead of going for such questions I would suggest you get hold of some books or an e-book at least.
create a table that contains the different fields of the database, eg: question, option1,option2....,correct answer In VB , create a function searching for the condition the the answer given by the user is correct or not