Good Day!

My problem is how to store beginning inventory on my table using ms access. Actually the code for this is not hard what i want to know is the best
technique to perform it without suffering the size of my database.

My initial solution is that every end of the day i save the quantity of each item and that will be the beginning inventory for the next day. Does it make me an efficient programmer?

Need your help ASAP!