Urgent ASP.net Database Help Required...

I am fairly new to ASP.net, so can someone show me how to connect to an Access database, pull a record from a table, and then use that record to identify a second record in a different table?

Hopefully that is understandable...

In short, this is what I said,
1.) Connect to database
2.) Select an ID from Table1
3.) Select a name from Table 2 where TheID = ID from table 1

I hope someone can help me with this... I have been working on this for two days now...

P.S. Can someone do this as an example for me, hopefully connecting in ADOB format? Thanks.