Inventory Management in MS Access
I am consulting a friend in his small business and he is currently using a paper system to manage his business/inventory, from order entry to invoice. I understand that MS Access is capable of doing this, i.e. create a database for inventory and enter orders that deprecate that inventory, add to that database as new inventory arrives, and eventually produce an invoice for the customer. Is this correct? If so, how? If not, are there other off the shelf software or freeware/shareware (not custom products) available. This is a very small business just trying to get off the ground. I appreciate any help you can offer.
Sincerely
Shoppingeutopia