At first I planned to download a template DB on inventory control, but then decided to start from scratch.
DB I want to build should do the following:
1) Register Inventory Items list based on Category, Sub-Category and Sub-Sub-Category
2) Register inventory items coming IN
3) Register inventory items coming OUT
4) Generate Status Check based on selected items
5) Notify item shortage based on numbers left in stock (=< than X)
I am trying to figure out Relationship Diagram.
Besides, I have learned from Internet that Access is NOT friendly on dependent drop-down lists. Data validation during table filling is crucial for me. Besides, I need dependent drop-down lists during query generation.