Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Unanswered: Q regarding Access capabilities (Newb)

    My dad asked if I could help him build a database to store inventory of parts for his small business. Here's a brief description of how they work:

    They receive parts from a company (complete with barcode) and builid large devices using them. There are numerous different kinds of devices so in total there may be about 10,000 parts. They've had issues regarding lost parts so they'd like to keep an inventory of every part that is shipped in and then every part that is used to build a device. They would like to scan in the parts using a barcode scanner when we receive them and update the quantity in the inventory database. Each time they use a part, they could then scan it again to remove it from the database.

    Before I set out on figuring out how to build something like this, it might be good to know if it's practical to do it. Could this all be done entirely with Access including integration with a barcode scanner (model is Symbol LS2208 if it helps)? Would something else besides Access be a better choice?

    Any help would be greatly appreciated. Thanks!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    All of your requirements, as stated, can be handled using Access, including the use of a bar code scanner.

    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

Posting Permissions

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