Hi
1) A solution can be designed that will check scanned bar-code and query ASIN/SKU from Amazon to extract prices for provided condition (Used Like New & Very Good)
2) If ASIN or any other ID is not available in the bar-code, we have to extract the information for that UPC
3) Why limit the features to MS Access. We can have reports and databaes in MS Access, but the front-end can be in some better format, (e.g. Application)
4) If you are a seller, do you want to know prices of your listings, or you want to have all the listing?
5) I will appreciate if you could provide sample bar-code so I can provide you a sample output, that may further give you confidence of what we can achieve, and may be a more clear picture to you of what can better be done.
6) Introducing myself, I've been with many Amazon Sellers, and have automated their entire systems [From creating listing, searching, black-box pricing, comparing with competitors, inventory management, sales management, FBA reporting, Inventory forecasting, advertising and marketing etc. over Amazon platform through different Amazon APIs :)]
Hope to hear from you
Thanks