Hello to everyone.
I have created a database with several products and I don't know how to keep the stock register in ms access.
Can you please help me with this?
I must complete this database and I am stuck here.
Don't know exactly what are the solutions.
How to maintain a stock register in ms access database
Before making a stock register make sure that you have a complete version of Ms Access
Create a design as same as when creating normal data bases
Make sure of appropriate fields and tables of your stock register. Understand what are you going to do through the data base.
Each table must create in design view and make sure that you complete the description. That will help you in further in completing wizards
Make Primary keys properly and relationships correctly. If you are feeling stuck again try using Assets register.Â