Solved

Office Supplies Inventory/Stock control

Posted on 2011-09-08
14
1,404 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:protechzm
  • 9
  • 5
14 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36503662
<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
 

Author Comment

by:protechzm
ID: 36508412
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36510530
OK, then that is what the sample I posted is...
a very basic system.
0
 

Author Comment

by:protechzm
ID: 36517414
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36517575
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
 

Author Comment

by:protechzm
ID: 36518856
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
 

Author Comment

by:protechzm
ID: 36518857
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:protechzm
ID: 36518858
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36526696
Then you will need something like this as a start

tblEmpOrders
EmpOrderID
EmpID
OrderDateTime

tblEmpOrderDetails
EmpOrderDetailID
EmpOrderID
ProductID
Quant
0
 

Author Comment

by:protechzm
ID: 36541835
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 36545226
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
 

Author Closing Comment

by:protechzm
ID: 36555681
I have accepted this solution because it points to what i need,many thanks for your help
0
 

Author Closing Comment

by:protechzm
ID: 36555682
I have accepted this solution because it points to what i need,many thanks for your help
0
 

Author Closing Comment

by:protechzm
ID: 36555683
I have accepted this solution because it points to what i need,many thanks for your help
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Creating and Managing Databases with phpMyAdmin in cPanel.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now