To complete the assignment, you will have to create tables, queries, reports, and forms. You will also be expected to populate the database with a sufficient amount of sample data to prove that your database meets the specifications with respect to reporting and data entry.
When developing the system, you should come as close as you can to meeting the specifications. Due to technical or time limitations, it is not always possible to figure out how to exactly meet every last requirement a business might have. It is usually still worthwhile to have a system come close and provide most of the capability desired.
Name both the MDB and ZIP files using your last name, first initial, and the option number. For example, if your name were Hugh Jasse and you were submitting the first option, the ZIP file should be named "jasseh_1.ZIP".
Please use this address: rfhomework@katz.pitt.edu
In the subject: put the following information:
Submissions without that information will be returned.
For more information, check out the BAA that was done by Katz Klassic Kars in anticipation of these system development efforts.
You are not to use a database creation wizard to start your database. There are 2 main reasons for this. First, the purpose of this project is for YOU to design the system. Second, the databases generated do not particularly well meet the requirements of Katz Klassic Cars. You may also not use a databse creation wizard as a starting point for Option #4.
You may (and are encouraged) to use the report, form, and query wizards.
Create a database and application to manage a mailing/telephone/email list. It should be able to store and retrieve records to generate mailing lists, telephone call lists, fax lists, or EMail contact lists.
Specifications:
This project can be implemented in a single table. Although using more than one table is possible, it would add complexity and cause you to need more queries. You will need to store names, addresses, various phone numbers, email addresses, etc. Make sure to give yourself sufficient flexibility to deal with various name, address and phone number styles and formats.
Data maintenance form to allow records to be added, edited, and deleted.
Provide access to all system features
Create a database and application to store and retrieve the information necessary to calculate sales commissions for the sales force at Katz Klassic Kars. It should have the flexibility to individually assign a different commission rate for each sales person (perhaps senior sales people would earn a slightly higher rate than those with less time on the job). The commission should be calculated as a percentage of the profit of each sale.
You will need to store information about each sale, such as the date, the item sold, the dealer's cost for the item sold, and the selling price. You will also need to store information about each sales person, including at a minimum their name and their commission rate.
Please note that the system should calculate the commissions, not the user.
Specifications:
This database will require at least two tables. Using more than two would add complexity, but could allow you to provide additional features beyond the minimum required here.
Data maintenance forms to allow records to be added, edited, and deleted for sales people, sales, and any other data you are maintaining.
Provide access to all system features
Create a database and application that Katz Klassic Kars could use to enhance business in the service department of the dealership. The types of information that should be available would be:
The system should include forms to allow all data in the system to be maintained.
Specifications:
You will need multiple tables for this application. They will include, but not be limited to:
You will have to use different selection and grouping approaches for the reports. Some of this can be done in queries, some in the reports themselves. Use your best judgement with respect to which layouts would be most useful to management. Bear in mind that it can be acceptable to generate certain "reports" as forms; make sure the data cannot be edited if a form is to be "view-only".
Provide access to all system features
Create a database and application that does something really cool, totally awesome, or possibly even useful. You must get my approval on a topic for this option. Based on what you suggest, we will agree on the maximum possible points and the breakdown.
Point maximums:
As needed to support your requirements.
As needed to support your requirements.
Data maintenance form to allow records to be added, edited, and deleted.
Provide access to all system features