Week 4 Project

I will create four ASP files that accomplish the following tasks by connecting to a database and performing an SQL statement.

Add a new record to the table created in Week 2. Place data in the following fields:
- Username (could be their email address)
- Password
- Name
- Address
- City
- State
- Zip
- Phone
- Email Address (or use this as the username)
- Newsletter? (a boolean field...Yes/No field in Access terminology)
- Type (a combo-box/drop-down menu containing the choices HTML and Text)
- Gender (a text entry for Male or Female)
Retrieve and display the data from [the very first record, all records and] the last record -- the record you just added.
Change the phone number for the record you just added.
Delete the record you just added.

For each snippet above, create a separate small .asp command file that performs the desired action. Then tie it all together with a simple HTML page that has 4 hyperlinks that process the steps above by manually clicking on the hyperlinks. This is the file you should give me access to when you are done. I should be able to click on each link and perform the desired operation.