Inventory for IT

[have0]

First of all i would like to say thanks to people who help me in this endeavor and those too who read it but don't have time to help

So i should start with my problem now



i have to make an inventory in which i have to manage stock and issue these stocks to costumers with respect to adding or subtracting.
so far i have created 3 tables
1. Location

2. Costumer

3. Stock


if i should add anything in it or any thing there has to be done please feel free to tell me
your help will be appreciated

[CJ_London]

your stock table should be at least two tables. One for details such as name and location and another for transactions (stock in/out/stocktake adj/opening stock) etc where you record the quantity, the stockID, transactiondate and other details such as customer and supplier id's.

[have0]

is it okay or do i change it more.

[CJ_London]

you have one table for stock in/stock out

[orange]

have0,

Do you have a more complete set of requirements for your proposed database?
My advice is that you identify and write down all the processes involved. Then identify the things required for each process. Stock in and Stock out is usually considered a transaction(s). Don't get too deeply involved (entrenched) in Access and a physical database design before you have a data model that you can test (with paper and pencil).

Also, when you define field names in Access, it is best to avoid embedded spaces within such names.

Here are some links to free resources that may be useful to you.
http://www.databaseanswers.org/data_...ales/index.htm
http://www.rogersaccesslibrary.com/T...lationship.zip
https://www.youtube.com/watch?v=4Z9KEBexzcM



Good luck with your project.

[have0]

can you please elaborate a little
i am new to Access and data base planning
besides there are two tables such as
stock in and stock out
isnt that what you asked for ??
should i include more options ??

[Homegrownandy]

one table is for the information relating to that stock item. Then another is each "transaction" relating to that item. Every time you get stock in/out that needs to be recorded as a new record. (on the same table). Then a calculation will give you the information you need about levels of stock.

Remember the system is only as good as the information you put in. If you miss any transaction then you have bad data.