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.

0. Create a database on your A: diskette drive, don’t use save as later.

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 plastic 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.

4. To get full credit, create a report that works with a filter, so that only retired people are listed.

The two reports, a screenshot of your form and your raw table data should all be printed out and handed in on paper. Do not turn in your disk.