Assignment #5               C S C 1 0 1                                       50 Points

Mohammadi                                                                           Due Date: 1/17/01

 

Build a database in MS-Access and create a form letter in MS-Word in order to perform a mail-merge with your database.

 

1.   Build a table that contains at least seven fields. Use meaningful types for your fields.

·        first name

·        last name

·        street address

·        city

·        state

·        zip code

·        at least one other field that would be useful, such as, age, marital status(M,S,D), own a home(Y,N), etc.

 

  1. Enter 10 records in this table.
  2. Create a report and print it. Your report must include the first name, last name, and any fields you added that are not listed above. You must have the appropriate report and column headers. Note that the address is excluded. (1st print out, one page)
  3. Create a query to choose a subset of the records in your database. Your criteria should be based on the extra field(s) that you chose to add to the database. This query should yield exactly 3 records. Update the values in the database to ensure that the query produces only three records. No print out from this step.
  4. Create a form letter for a piece of junk mail. Assume that the recipient has "won" a three-day weekend vacation in your hometown! Let them know all of the wonderful things they will be able to do! Sell your hometown! Make them glad they won first place, and not second place. Creativity will be rewarded. This form must include the name and address in the upper left corner of the letter. Print out this form letter. DON'T mail merge here; just print the form letter. (2nd print out, one page).
  5. Generate junk mail using the mail-merge process based using your form letter and the query developed earlier. Turn in these printed letters. (3rd print out, three pages).

 

Write your name on the top of each page of output - there should be five; the report on the database, the form letter, and the three mail-merged letters.

 

********** EXTRA CREDIT **********

************ 5 Points ***********

Print a set of address labels for those whom we will be sending junk mail to. You don't have to actually print on a label form, normal paper is fine. You must write a paragraph describing how you generated the labels (i.e. Just typing a bunch of mail addresses in the word processor won't get you the points). (extra credit print out, two pages).  Each label should have the following format:    First Name Last Name                                                                                                                                                                                                          Street Address

                                                                                                City, State      Zip