skip to Main Content

How to Read Barcode Data into MS Access Databases

Author:

You are here:

Speed up your bookstore, retail or library processes by inputting data using a barcode scanner. Bar codes offer efficient and accurate data input, removing the risk of incorrect number entry. A Microsoft Access database is an ideal application to input and store this information. Several types of barcode scanners are available on the consumer market; some require software to interface with the database and some need no configuration at all. But any type reads bar  code data into an appropriate Microsoft Access database field.

Barcode Scanner

Barcode Scanner

  • Open the table, query or form in Microsoft Access that the bar code data will be input into. Any field that allows alphanumeric entry will read bar code data, such as book ISBNs, UPC codes and staff ID badges.
  • Plug in a wand or laser scanner into either the keyboard or computer tower, depending on the model of the computer. Connection types include USB, keyboard wedge and serial. Install any additional software as needed by the bar code scanner; the software will pass data between the scanner and the Microsoft Access database.
  • Select the number, text or memo field that your barcode data will be entered into with your cursor. Yes/No, Currency, AutoNumber, Date/Time and OLE Object fields will not allow bar code data because of their information restrictions.
  • Scan the bar code into the selected field, either using a “keyboard wedge” or “serial” type output. A keyboard wedge scanner outputs data as if typed through a keyboard. A serial bar code scanner requires additional software and adds an extra step to input data into the Microsoft Access field, but it allows you to edit the data before storing it in the database.

 

If you are facing any kind of issues call us on our toll-free number 1-800-293-9401.

Tags:
Was this article helpful?
Dislike 0
Views: 12

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top