ASP/Access Data Retrieval

I am fairly new to ASP and have just recently started projects to take advantage of its functionality.  I am creating a new web form with which my customers can enter their ZIP codes and from their response I have an ASP engine that queries an Access database for the results.

I have developed a good connection to the DB.  The table includes: ID (key) | NAME | Address | EMAIL.  How would I word the retrieval of the entire row of information?  How do I word the ZIP Code-To-key scripting?

Thanks for any help you can give.

Sorry for the confusion:

I read the tutorials and that was how I figured out how to connect to the database.  From the tutorials, I learned how to return all the values in the Access database using the  DO WHILE - LOOP command.  I can do that fine, I have just not been able to find any literature explaining how to retrieve one row of information from a table.

To be more specific:  I have an HTML form that allows a user to enter their Zip Code.  That form posts to an ASP page.  I was going to use SELECT CASE statements to list all the possibilities for ZIP Code entries for my state. (have already used this method on another project and had good results). 

Using this setup, how can I reference "example" Zip Code: 65101 to automatically pull all the information from the row that has the key value of 2?  Within row 2 I have columns NAME | ADDRESS | FAX | EMAIL

Thanks for your quick response.

Thanks for your help.  I ended up with the following to resolve all the queries:

Example:

Case 64422, 64430, 64447, 64469, 64474, 64490, 64494, 64497
 'Dekalb County
 
  strSQL = "SELECT * FROM CropAgents WHERE ID = 1"
  Set rsCropAgents = Server.CreateObject("ADODB.Recordset")
  rsCropAgents.Open strSQL, adoCon
  response.write("<left><br>")
  response.write("<b>" & rsCropAgents("NAME") & "</b>" & "<br>")
  response.write(rsCropAgents("ADDRESS") & "<br>")
  response.write(rsCropAgents("CITY") & "<br>")
  response.write(rsCropAgents("ZIP") & "<br>")
  response.write("Phone Number: " & rsCropAgents("PHONE") & "<br>")
  response.write("Fax Number: " & rsCropAgents("FAX") & "<br>")
  response.write("Email Address: " & rsCropAgents("EMAIL") & "<br>")