I have a couple of questions. I want to build an inventory program for my jewelry store. These are the requirements can anyone tell me if this program is possible.
1) There is going to be an inventory table with these fields: Item, Item number, weight, supplier code, price, cost code, and a random number to be the primary key. The first question I have is I need to make the random number a barcode to print onto the jewelry tags. All the other info will be on the back side of the tag. In access is there a way to turn a field into a barcode?
2) After I sell something I need to scan the barcode and have that item removed from the inventory into the sales table. The problem is I never get the price thats listed on the tag so after i scan the item i need to enter the price i recieved and the date sold.
3) The scanned item has to go into the sales table and i want to make reports like weekly sales and sales by item or sales by supplier.
Basically is this system possible in access or do I need to use another system? Any help will be appreciated.
Thanks
1) There is going to be an inventory table with these fields: Item, Item number, weight, supplier code, price, cost code, and a random number to be the primary key. The first question I have is I need to make the random number a barcode to print onto the jewelry tags. All the other info will be on the back side of the tag. In access is there a way to turn a field into a barcode?
2) After I sell something I need to scan the barcode and have that item removed from the inventory into the sales table. The problem is I never get the price thats listed on the tag so after i scan the item i need to enter the price i recieved and the date sold.
3) The scanned item has to go into the sales table and i want to make reports like weekly sales and sales by item or sales by supplier.
Basically is this system possible in access or do I need to use another system? Any help will be appreciated.
Thanks