Need access database for inventory

Asked By ignov_pavel 0 points N/A Posted on - 10/21/2011

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?

• Status: Open
• Question Views: 873
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Christian Bower

Go To Solution

Best Answer

Best Answer

Answered By Christian Bower 0 points N/A #95226

Need access database for inventory

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

.

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

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

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.

About Christian Bower

Questions
0

Answers
3

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/25/2011
• Question Category: MS Access

Answered By Osimeon 0 points N/A #95227

Need access database for inventory

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.

About Osimeon

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Access