Location: Courses
/ Oracle DBA Project
|
FORMS:
A. Main menu:
1. List all options.
2. Being user friendly; easy to read and easy to use; avoid being too
colorful and fancy.
B. Customer Order Detail Form:
A tab master-detail form contains information for all
customers and their orders including order items, quantity, unit price
and etc. The form should be able to:
1. show detailed order information about a particular customer;
2. update customers order information;
3. insert and validate new order records;
4. show detailed product information;
5. show detailed shipping information;
6. show detailed suppliers information.
C. Customer Balance Form:
A tab master-detail form contains all information about
customer's balance. The form should be able to:
1. show balance summary and detail information for a particular customer,
2. show detailed information for customer's salesperson.
D. Product Form:
A master-detail form contains detailed information about all company's
products, including unit price, discount, and so on.
REPORTS
Sales reports
The report should have options to sort in different order, either by country,
or by sales person or by category.
DELIVABLES:
User friendly forms and reports
Previous
page <<
page 1 page 2
page 3 PAGE
4 page 5 Next
page >>
|