Visual Basic Group Project Clint Schramek Jennifer Webb Mark Puffer
Project Sponsor Dr. Rob's Salsas Inc. , Dr. Rob. 2700 Bay Area Boulevard Houston, Texas 77058 (281) 283 - 7600
Project Summary n Dr. Rob’s is a vendor who rents shelf space from area grocers in the Houston area. The salsa is supplied and inventoried by Dr. Rob employees. An inefficient manual process is currently used for inventory ordering and counting. This process is time consuming and inefficient. Currently a company representative visits each store location and physically counts the inventory, and then records it on paper. The order is called in to the home office to be placed. At the home office once an order is placed, it is manually recorded. This completely manual process needs to be improved. The solution is to develop an automated system that will allow for electronic ordering, tracking, and invoicing.
The Business Solution Develop an automated system that will allow for electronic ordering, tracking, invoicing, and reporting.
The Requirements Number of Forms Required: 20 Number of Reports Required: 05
The Requirements Database: Dr Rob’s Salsa Tables: Customer • Cust_id • Cust_Name • Address • City • State • Zip • Phone Inventory • Prod_id • Customer_id • Previous_On_Hand • Current_on_Hand • On_Hand • Shrinkage • Max_Quantity Product • Prod_Id • Prod_Name • Cost • Profit_Margin • Selling_Price • Units_Sold
The Requirements Database: Dr Rob’s Salsa Tables Continued: Order • Order_id • Order_desc • Client_id • Prod_id • Quantity • Price Log_On • user_id • password • User_Name
Hardware Requirements n n n n Tablet PC (Client Only) Management Workstation (Client Only) 802. 11 Wireless LAN (Client Only) Routers (Client and Corporate) Firewalls (Client and Corporate) Server (Corporate Only) Internet connection (Client and Corporate)
Hardware Requirements
Opening Screen Login Screen – User logs into application
Opening Screen Continued Log – In Flow Chart:
Main Menu Screen
Form Hierarchy Customer Form: Customer Data Product Form: Product Data Orders Form: Order Data Inventory Form: Inventory Data Management Form: System Maintenance Update database tables
Customer Form
Product Form
Order Form
Order Form – Place Order
Inventory Form
Management Form
System Maintenance Form
Output Reports
Output Reports - Hierarchy
Management Reports
Database Design
Conclusion `Comments? `Suggestions? `Critiques?
Скачать презентацию Visual Basic Group Project Clint Schramek Jennifer Webb
8def887e96612ed413fb7a142e5eb7bf.ppt