ASP/SQL: How do I get a list of tables in the database (what is good reference source)

This may sound basic, but I'm having trouble locating a good reference
source for my ASP site development.

I'm using ASP(VBScript) to quire an Access database.  What I need to know
at this point is: 

How to generate a list of the tables available in a database file?
More to the point the SQL or SELECT statement do find out what the table
names are, I pretty much know how to deal with the rest.  In ORACLE I
recall something like SELECT * FROM DUEL;  

If there is a good quick reference (net or book) that will list commands
and parameters for such things as SQL(for Access and or MySQL), VBS, ASP,
JScript I would be forever greatful for such information.

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA