Database Answers Shermans YMCA

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Customers, Inventory and POS   
Back to the Data Model.
The Area being Modelled is :-
Customers, Inventory and POS

Hi Barry,

I am looking to implement better inventory controls for our small camp store.

I am looking about creating an Access database.

I am also looking to have a POS system, customer data and inventory.

We currently have kids parents deposit a sum of money and when the kids go to the
store we manually look through paper to find the kids and their balance and then
manually subtract items off their balance.

I would like to be able to enter customer data with their name and balance and then
have a search function to pull up the kid in the pos and have the inventory updated
as they check out.

Would you have any forms or templates or ideas on a POS, Inventory and customer databases?

Thank you,

Evan


© DataBase Answers Ltd. 2014
About Us Contact Us