Inventory db that checks bulk units in and out
- or -
Post a project like this2382
$$
- Posted:
- Proposals: 10
- Remote
- #1731714
- Awarded
Husband & Wife Team - Software Engineer, Public Relations Guru & Graphics Designer
Ypsilanti
27026940596361675829064149679716460921656664179998918115391848411
Description
Experience Level: Intermediate
I would like an access database or even an excel table would do. Where I could show the current amounts of my inventor and project future levels based on orders.
There are about 2000 pieces of inventory and about 13 different types of inventory.
The inventory is checked out for a specified amount of time to cover an event and then checked back in once that event is over.
I typically handle about 200 events a year.
Most of the events overlap so I need to be able to project inventory numbers in order to know what I have available to support each event.
Plus I need a dashboard. I don't want to look through numbers and try to figure out if I have an overlap.
We will need a way to log customers and their contact information too. No need to worry about sales. I have another system for that.
Everyone in the office will have full rights to the database. I just want to have it where you need a password to get in if you're not on of those 5
All the users of this database will be co-located and will be using windows 10 64-bit workstations.
Finally, this thing needs to be able to have user accounts so that we can tell which person enters in data. There will only be about 5 folks at the most entering data into this thing
There are about 2000 pieces of inventory and about 13 different types of inventory.
The inventory is checked out for a specified amount of time to cover an event and then checked back in once that event is over.
I typically handle about 200 events a year.
Most of the events overlap so I need to be able to project inventory numbers in order to know what I have available to support each event.
Plus I need a dashboard. I don't want to look through numbers and try to figure out if I have an overlap.
We will need a way to log customers and their contact information too. No need to worry about sales. I have another system for that.
Everyone in the office will have full rights to the database. I just want to have it where you need a password to get in if you're not on of those 5
All the users of this database will be co-located and will be using windows 10 64-bit workstations.
Finally, this thing needs to be able to have user accounts so that we can tell which person enters in data. There will only be about 5 folks at the most entering data into this thing
Joseph M.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
31 Oct 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies