Homework #2 and #3  ISM 4212 fall 2005 

Homework #2: Convert the system that you built for Exam 4&5 to a client-server, batch entry system like the sample system payroll 1. Email 2 mdb files with the names HW2client and HW2server. Include DFD and ERD.

Homework #3: Convert the system that you built for Homework #2 to interactive processing of a single transaction with source data validation like the sample system payroll 2. Use update-through-view to maintain aggregation totals in the salesman table of the number of cars sold, the total sales value, the total profit, and the total commissions due. Have a button on the main menu which can zero these aggregation totals to begin a new period. Use a form to furnish a parameter value to a query and a report. Email 2 mdb files with the names HW3client and HW3server. Include DFD and ERD.

Email the ACCESS mdb file to wleighwleigh@yahoo.com .  Put "ISM 4212 Homeowrk 2 and 3" and your name in the subject line of the email. (Use of the Yahoo mail account should avoid security screening problems with the university.)