IST 331 Final Project - Do Not Call Registry

IST 331 Final Project - Do not call Registry

Fall 2003

V. Matos

In this assignment you will implement a non-web based portion of the “DO-NOT-CALL” registry. In the following description mailing is done using US postal services (snail mail). You may have to make changes to the database schema presented earlier in order to implement the following request.

A. Collecting Requests

Assume you have a Microsoft-Access application for the registry which consists of tables, forms, reports, and VB code. One of its options is to display a Windows form on which the client requests one of his/her phone numbers to be added to the registry. The form must accept four pieces of data

1.  Client Name (a person, company, institution)

2.  Client Address (street, city, state)

3.  Email address of the client

4.  Phone number (area code + number)

B. Processing Requests

Those four values in a request should be gathered to initiate the process of registration which includes the following steps

1.  Check (on-line) if the phone is already in the registry. If not, insert it as a temporary entry and add a timestamp. Otherwise reject the request and display an appropriated message.

2.  Print a letter (MS-Access report) showing the client’s name, address, and phone number. This letter should be mailed to the client using US postal services.

3.  When the client receives the letter he/she must enter the email address, sign the letter, and mail back to you.

4.  You will use the retuned letter to perform a permanent registration of the phone number. To do that, you need to (a) verify it is signed, (b) locate the record using the phone number as search key. If found, enter the email value written on the letter. If there is a match with the email stored in the database request, the phone is finally posted on the registry. Otherwise contact the client asking to repeat step 1.

Your job is to implement the form(s) here described. Your form must use the ADO control to manage the database retrieval/maintenance operations.

·  This assignment will be prepared in groups of no more than two students per team.

·  It is due on the day of final exam (Tuesday Dec. 9 1:00-3:00 PM).

·  Be prepared to demonstrate in the lab the operations of your project.

·  I suggest you try your code in the CBA computer lab before the final presentation.

·  Make sure you have backups of your work.

·  Hand to your instructor (a) printout of the screens and code, (b) a floppy disk with your database