Hi! i am required to make a microsoft access query or visual basic program to find records from the tables. The program i am currently using is microsoft access.

For example if i want to find a record call 'snake' from a table and i do not know the spelling so, i type 's' or 'sn' in a form, and the the program will search records from my table for any relevant records with the character i type into the form. Then show the results of the records.

Anybody can kindly help me or provide me with the sample program?