Database for "Trading Post"

[CampGuy07]

Any help or suggestions would be greatly appreciated!

I work for a summer camp, and we have a "Trading Post" - where we sell pop,
shirts, etc... to the kids during the week they are there

At the beginning of the week, the kids give some amount of money to add to
their "account" - and, currently, when they buy a pop or candy, we write it
down on their trading post card, and at the end of the week, we subtract all
purchases from the amount they deposited to give the balance back to parents.

I want to design something using Access that will do all of this for me...

I want the following:
I want to use a barcode scanner to scan the items - should be easy to take
care of...
The database must be able to open a camper's account, and when an item is
scanned, subtract the amount from their deposit, record what item was
purchased, and then at the end of the week, a report would have to show the
remaining balances in all the accounts.

Any suggestions on how to go ahead with this??

Thank you in advance!

 

[Dennis]

First, I aasume that you actually HAVE a bar-code scanner that you've already
connected to yout PoS computer? Assuming that's true, and assuming that
you've enabled UPC code to be recognized by it, You need the following:

Create a form where you can key-in the kids' ID number. (If you prefer, you
could print out a bar-code card for each kid with their number on it, and
simply scan it when they present it to you.) So now you have the kid's ID
number. Simply scan the product and have code to look up the cost.

You'll of course need to keep a table of items by UPC code and the cost.
You'll also need a table of kidss ID numbers, names, etc. Then you'll need a
table of their account balance bvy kid ID number.

Pretty simple really.