VOICE - Mail Order Sales and Services

What should be in the final report?

This project has two different stages: (a) design and (b) implementation.

Design

• Order entry screen and sales report definition: Use a word processor or text editor to create screen and report layouts.
• Data Base design: create a relations diagram, represent the data base in relational notation, then use PowerPoint to represent the data model and print it.

Implementation

• Create the tables and load the test data: use Access, or equivalent, and code your tables.
• Create a form to handle order entry: again use Access, or equivalent, to create your form. Use some new orders, similar to the ones given, to test your form.
• Create a report to print daily sales by product: one more time use Access, or equivalent, to create the sales report. Use the case data to print a test of the report. In order to join tables, I suggest that you use queries and save the answer as the Sales table, and then print the report based on the Sales table.

Organize your project report as follows:

1. management summary: a one page description of the system.
2. data base design: the relations diagram with the relational notation of the DB, and table definitions.
3. data base structure and data printouts: a printout of the table structure and simple report.
4. examples of inputs and outputs: printout of order entry form and sales report.

This page is maintained by Al Bento who can be reached at abento@UBmail.ubalt.edu This page was last updated on January 16, 2004. Although we will attempt to keep this information accurate, we can not guarantee the accuracy of the information provided.