OBJECTIVE: Create a new database with front-end interface and reports
DESCRIPTION: This Access 2003 database will manage inventory in a warehouse. It will include a data entry form(s) and work order reports. Items stored in warehouse belong to customers; therefore, customer data must be recorded. Data must be recorded to track which employee performed which action(s) for which customers on which items in which locations at what date/time.
DATABASE TO USE: Access
OPERATING SYSTEM: Windows XP
PROGRAMMING LANGUAGE TO USE: Not sure - developer should suggest (if one is needed)
DATABASE SIZE: 5,000- 10,000 records
NUMBER OF SCREENS FOR FRONT END: I'm not sure
NUMBER OF REPORTS: Less than 10
TECH SUPPORT REQUIRED: None required
EXPERIENCE LEVEL OF CLIENT: I have general knowledge about what I need
Customer Table: Customer ID; Company Name; Mailing: Address, City, State, ZIP; Delivery: Address, City, State, ZIP; Contact person 1; Contact person 2; PIN for contact person 1; PIN for contact person 2; Phone 1; Phone 2; Email address; Route.
Item Table: Item ID; Type; Description; Item Retention; Customer ID; Item Status
Item location Table: Location ID; Location description; Location notes; Item ID.
Work Order Table: Work Order ID; Customer ID; Item ID; Location ID; Employee ID; Date/Time; Item action (Add, retrieve, refile, remove).
Employee Table: Employee ID; First Name; Last name.
Call log Table: Log ID; Employee ID; Employee name; Date/Time; Notes
Need form(s) to add, retrieve, remove, and refile items, should include employee ID and date/time of action.
Add: new item comes into the warehouse
Retrieve: item is taken from the warehouse with the intention of returning it at a later time
Remove: item is taken from the warehouse with NO intention of returning it at a later time
Refile: item that has been retrieved returns to the warehouse
Need work order reports to display customers’ orders.
Multiple types of storage items: Small box, medium box, large box, and file.
Locations: 5000 locations total
Small boxes are stored in locations 1-1250
Medium boxes are stored in locations 1251-2500
Large boxes are stored in locations 2501-3550
Files are stored in locations 3551-5000
DELIVERABLES: Access database file(s) and any other files including source code that was used
8 freelancers are bidding on average $81 for this job
Sir, I have +7 years of working experience in MS Access. I could design a clutter free and a decent database for you if given a chance. Regards, B K Kachhap
Sir, We will do the projects as per your requirements. We have professional team for software development, web designs, development & hosting. meccassi.