Look in the FrontPage help files for the word 'database' and see what you get. There are tutorials and examples in there which show you how to create forms that send their results to an Access database.
FrontPage creates the database for you in a locked down folder and obligingly also creates the ASP and Global.asa pages for it all to work properly.
The database will be created in Access 2000 format but that shouldn't be a problem since that's the default database format that Access 2002 [or XP] uses with the option of updrading 2000 databases to 2002 format if required. This is normally only necessary for very large and/or comlex databases and it can help performance.
Anyway, I digress. Check out those helpfiles then come back here with specific questions. Look for the database results wizard as well, and take a look at this site click here
Your web host will need to support an Access database and FrontPage generated ASP pages - not the same as .NET, so be warned.