Anucool

Hye guys(N Gals)

I am new in vb programming and I have few queries.

1 Does sql queries work on access?
2 How to add a Database(access) column to vb combobox?
(Eg if dbs file is abc.mdb ; table is student, attribute needed to be added in
combo box is student_name)
3 how to add keypress event (Actually the event may be different, what i want is in an combobox Or text box when i type letters for each letters typed vb should run select query for entire string
or
I want the effect that when a string is being entered similar data existing in dbs files should show up as in google search box when u enter something it shows previous searches those are similar)

ie. in combobox in question 2 if i type "M" it should show all names begining with M
i e sql query will be
select student_name from student where student_name like M%;

please help...