Need access database for inventory

Asked By 0 points N/A Posted on -
qa-featured

I need to create access database for my company for managing my inventories in my stockroom.

I need it to have 5 categories and in each one of them I want it to have a couple of items.

I tried with a template, but when I entered different items in each category it showed me the total amount of items in the entire category, but i want it to show me the count of each item separately.

Any ideas how to achieve this?

SHARE
Best Answer by Christian Bower
Best Answer
Best Answer
Answered By 0 points N/A #95226

Need access database for inventory

qa-featured

It sounds confusing at the bottom of your statement. When you create a database and divided into categories of course you need to have is to relate your table to each other. I will give you an illustration to follow when you create a database like to want you want.

For example we have a database name Products, and we have two tables which are tbl_category and tbl_products. In tbl_category we have two fields which are Category_ID and Category_Name

.create a database and divided into categories

And we have also a table which is tbl_products. In table products we have fields Category_ID, Product_Name and Product_Code.

table products

Category_ID is the primary key of the tbl_category which is also included to the tbl_products to know what category they are.

Category_ID is the primary key of the tbl_category

As you can see the Category_ID has tree products which are David’s Book, The Children and All my Life. Which means those products have the same product ID which is 1? But if you want to count every item you must need to count the items filter by product code.

Answered By 0 points N/A #95227

Need access database for inventory

qa-featured

Can you send me the blue print of your database design and then I can try to work it out and simplify it for you.

I have been working lately close with database designs and implementation.

Related Questions