inventory desing

[julio213180]

Hi guys;
can you please help me in desing a very simple database?
I just want to keep track of a inventory when a make a sale.
howmany items i have after a sale,things like that. It is for a very small store. it has been such a long time since that I don`t use Ms Access.
I don`t know if I have to use vba to make the calculations, and how to set up the tables. If you could please help I will be very gratefull.
thank you
julio213180

 

[RuralGuy]

If I were you, I would start with one of the Microsoft templates that sounds close and start modifying it to suit your needs.

 

[julio213180]

Hey thanks, Rural Guy.
But I did not see any of the samples that do the calculation that I want.
or how to make it, i just want to keep track of howmany item is on my stock after I ake a sale.

 

[RuralGuy]

That sounds like Inventory Control: Quantity on Hand to me.

 

[julio213180]

Hi there, RuralGuy.
Thank you very much this is what I was looking for.
now I can start my project.
if you ever come this way (brasil) look me up.
I will show you around.
your new buddy julio.
juliodemedeiros@gmail.com