CMPSC 201

DATABASE Project

Telephone Scam Database. Let's say you're running one of those half-legitimate (or entirely criminal) scams that use phone calls and junk mail to sell trinkets and promises. Telemarketing it's called, and it would be impossible without a computer database. This database will be a database of customers. Each entry would describe a known gullible mark by his/her description and the type of junk product they tend to go for.

1. Create a database Table which includes information on a group of fictitious customers. This information should include the following fields:

Lastname text, 20

Firstname text, 15

Age number

Widowed Yes/No

Retired Yes/No

City text, 20

State text, 2

FavoriteProduct text, 15

NumberPurchases number

LastPurchaseDate Date/Time

Example:

Lastname Firstname Age Widowed Retired

Larson Grandma 92 Y Y

Enter data for at least 15 fictitious "customers" with a variety of names, ages, conditions, favorite products (such as lawn animals, appliances, jewelry, dolls, contests, etc.) and locations. Print out the contents of the file in the order in which you entered it, and then retrieve the following information:

2. Create a Form to enter a data record. It must look nice and allow the input of every field.

3. Create a Report that lists the name and address, retired status and age of every customer. Make sure the list is sorted based on their last names. Of course, you should make sure you enter data in your file so that the report has meaningful data to display.

Your final results for all these tasks should be turned in on Disk. This project is due the date of the final exam.