POS Abilities of Access?

[conroy125]

Hi guys,

Do you mind me asking a quick question about the possibilities of using access for stock control. I've downloaded some templates but they are way in excess of what we require.

We are a motorcycle and garden equipment shop selling everything from the machines themselves to parts.

We have an expensive stock system in place but don't use over 5% of its capabilities.

Basically we just want a simple system.
7 columns:
Part No
Description
Category
Brand
Stock Qty
Cost Price
Selling Price

Then we want to be able to print label stickers with a barcode and be able to scan them or else use original barcode.

Then if a customer comes in:
We scan the items
The total price comes up on the screen


It automatically reduces the stock numbers when the sale is closed.

So my questions, Is this possible? Is this difficult to set up?

Thanks in advance,

Patrick

[rpeare]

The database itself is not hard to set up, nor is printing barcodes. here's a video of how to do it in access 2007

http://www.youtube.com/watch?v=q3t-4KKgnf8

If you've got a scanner that you intend to use with your access application you'd have to find out if you could use that scanner with access, I don't think there would be a huge issue, scanners are just read/write devices that should spit out the barcode easily.

However, I just want to warn you that you do not want to do this on a single table.

You'll want a table for your items (what you currently have)
A table for your USAGE. the barcode scanner would write data to your USAGE table
A table for your RECEIPTS. when you receive items into inventory they could be scanned or manually entered.

Depending on the requirements you probably can put both the usage and receipts on the same table and save yourself some effort. Then the current inventory level would be the sum of the receipts minus the sum of the usage.

if you can get your scanner to dump data to an access table the rest is fairly simple. I don't have a scanner to play/test with so I can't help you with that part.