Scanning

[Amin]

can anyone inform how a super market scanning machine will work with an excel
application or even access database. i dont if these are the programs they
use when items are scanned befor customers pay. i will like to know how that
is done thanks

 

[Arvin Meyer [MVP]]

Yes, it's called bar code scanning and Access (and Excel) can receive output
from a bar code scanning device. Here's a good source of information:

http://www.adams1.com/share.html

 

[Ron Hinds]

can anyone inform how a super market scanning machine will work with an
excel
application or even access database. i dont if these are the programs they
use when items are scanned befor customers pay. i will like to know how
that
is done thanks

They definitely aren't using Excel! They are using some sort of database
application, though I doubt they are using Access. The scanner is merely an
input device, just like a keyboard. In fact, handheld scanners exist for PCs
that can be plugged into the keyboard interface, though most newer ones are
USB. The scanner scans the UPC barcode in and it is used in a lookup in the
database which returns the price of the item. We use scanners and barcodes
extensively with our Access (front-end) application. It's very efficient and
less error prone. The scanner simply fills in a textbox on a form - the user
could also type in the same info but the scanner is faster and more
accurate.