How to Read Barcode Data Into MS Access Databases

By Emily Ediger

Speed up your bookstore, retail or library processes by inputting data using a bar code 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 bar code 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 barcode data into an appropriate Microsoft Access database field.

Step 1

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.

Step 2

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.

Step 3

Select the number, text or memo field that your bar code 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.

Step 4

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.