you can do it very easily. just put a data control. in properties slelect connection type access (if you want to connect office 2000 or next version you need service pack 6). and select the location of file. and then in record source select the table.
There is another way depending upon what version of VB you have.
Start new standard exe project
Goto vb's ide menu Add-Ins > select add-in manager.
Look for VB 6 Data Form Wizard, highlight > Look at frame in bottom right corner with caption Load Behavior > select Loaded/Unloaded so check mark displays in check box. > OK
VB IDE Menu Add-Ins > Data Form Wizard
Run through wizard selecting your access database via browse button on screen 3.
On next form enter the name of the form you want, the style, and the type. I would suggest to start off with the ADO Code unless this is the first time you have ever played with VB.
Actually I would suggest that you use each option with each type and save that as a test project for reference. Then you will have it for reference.