Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Question Unanswered: Advice for New Database

    I'm looking to build a custom database for a small health and medical supply business. The database should be allow us to manage inventory, maintain customer records, and execute cash register transactions. A primary goal of the software is to be able to use a scanner so that inventory can be more easily managed. It will be managed on a single computer (right now).

    I am familiar with MS Access and have made relational databases using the application; however, I have never integrated the databases with a barcode scanning system or a cash register.

    That being said, I have the following questions:
    1. Do you know of any information as to how to setup MS Access to work with scanners or register? For those of you that have done this, is this a difficult setup process?

    2. As the business grows, what are some other data management approaches would you recommend?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    If you google "MS Access" and "Scanners" you'll get about a gazillion hits on the subject. Here's one

    How to Read Barcode Data Into MS Access Databases

    The main thing to understand is that entering data through a scanner is treated by Access as if the data were entered through the keyboard. In practical terms this means that all of the events associated with a given Control, such as the Control_BeforeUpdate, Control_AfterUpdate and other events, will fire, just as if you had physically typed the information in, and can therefor be used to accomplish tasks.

    At the most basic level, you place the cursor in the Textbox, on the Form, do the scan, and the data will be entered into the Control.

    I haven't done this in years, but I would expect there to be documentation that comes with the scanner. Using a scanner is a common approach, these days, and I'm sure that there are off-the-shelf answers for much of this, many of which are probably Access-compatible, out of the box. And they may actually be less expensive, in the long run, than trying to do all of this yourself.

    As for the future, you'd probably do well to split your app into a Front End/Back End configuration from the git go, even though everything will be run from a single machine, in the beginning. It'll make things easier down the road, when you'll probably need this to be set up for a Multi-User Environment.

    Assuming, of course, that there will be a 'down the road!' Sadly, DME companies are getting to be endangered species!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •