Office Supplies Inventory/Stock control

Hi,
I have been tasked to develop a stock control/inventory system for our office  stores.This stores keeps office supplies like toner,bond paper,cleaning materials,pencils,beverages etc all for office use.Management wants to be able to monitor usage and generally to help stores officer plan well.
I searched the database and found a similar question asked but the answer/solution does not meet my expectation hence decided to ask again.A web based system would be very good.
The link for the question is:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22119451.html?sfQueryTermInfo=1+10+30+inventori+offic+softwar+suppli

Its almost exact,i will be glad if anyone is able to help.
Any open source software  is highly preferred since freedom is GOOD for everyone.

Nb:If i have misplaced zones for this question please help by re-directing it
Thanks you.
protechzmAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Well the addition of needing "Department" level info, moves this well beyond the original question.

So now you obviously need an "Employee" table and a related "Department" Table.
tblDepartments
DeptID (PK)
DeptName
...etc

tblEmployees
EmpID (PK)
DeptID (FK)
EmpFN
EmpLN
EmpAddress
...etc

<i can compensate you if have time to help,>
As Experts, the only compensation we can accept is the points you assign to a question.

If you need help with an issue "outside" of this site, you can browse all of the profiles of the top experts here.
Most will have a "Hire Me" button.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
<Its almost exact>
What is "almost exact"?

There were two posts accepted in your link, which one are you referring to?


If it were me, and I was new to database design, I would start with the MS Access template:
http://office.microsoft.com/en-ca/templates/inventory-control-database-TC001047741.aspx

Just be aware that inventory management Database can end up being some of the most complex databases to develop.
(They will be commonly be called on to interface with Sales and HR systems)
So I would not recommend you doing this alone if you are new to database design.

JeffCoachman
0
 
protechzmAuthor Commented:
The link i am talking about is the accepted solution,there is also an assisted solution,generally,there are no sales issues on our part.All we want is to monitor the flow of items issued to staff from the storeroom by the stores officer and to also know how to control usage and to help the stores officer plan the re-order levels of the items.I do not really need something very complicated.

Thanks
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jeffrey CoachmanMIS LiasonCommented:
OK, then that is what the sample I posted is...
a very basic system.
0
 
protechzmAuthor Commented:
I have looked at the one you,suggested,looks ok on the part of the inventory but there is no part where products are issued,is there a way to edit this to include the issuing part of the items to members of staff?
0
 
Jeffrey CoachmanMIS LiasonCommented:
The database manages the inventory.
In that respect the database is functionally complete.
(example: An employee is assigned to a Purchase order)

So you will have to clearly define what you mean by "Issue".
0
 
protechzmAuthor Commented:
Okey,what i mean in simple terms is this:every employee fills in a request form where they say what they want from stores,the stores officer then records qty issued.we have 2 departments,each with their requisition book.we want to be able to track the issuing of items from stores and if possible know who uses alot of bond paper for example or who uses alot of toner.i hope i have given u the clear picture!
0
 
protechzmAuthor Commented:
Okey,what i mean in simple terms is this:every employee fills in a request form where they say what they want from stores,the stores officer then records qty issued.we have 2 departments,each with their requisition book.we want to be able to track the issuing of items from stores and if possible know who uses alot of bond paper for example or who uses alot of toner.i hope i have given u the clear picture!
0
 
protechzmAuthor Commented:
Okey,what i mean in simple terms is this:every employee fills in a request form where they say what they want from stores,the stores officer then records qty issued.we have 2 departments,each with their requisition book.we want to be able to track the issuing of items from stores and if possible know who uses alot of bond paper for example or who uses alot of toner.i hope i have given u the clear picture!
0
 
Jeffrey CoachmanMIS LiasonCommented:
Then you will need something like this as a start

tblEmpOrders
EmpOrderID
EmpID
OrderDateTime

tblEmpOrderDetails
EmpOrderDetailID
EmpOrderID
ProductID
Quant
0
 
protechzmAuthor Commented:
Thank you for the support,these fields make up two tables that will need forms not so?how about the dept usage as a whole,please shade abit more on the ideas,looks like i wud use alot of your help,i can compensate you if have time to help,
0
 
protechzmAuthor Commented:
I have accepted this solution because it points to what i need,many thanks for your help
0
 
protechzmAuthor Commented:
I have accepted this solution because it points to what i need,many thanks for your help
0
 
protechzmAuthor Commented:
I have accepted this solution because it points to what i need,many thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.