Need a quick access database to generate purchase orders of customers.
We have an excel file with list of items our customers purchase. we would like to be able to select each item from a category. Each item has information on price, size, how many the customer ordered, how many are available to be supplied, how many are backordered and comment.
We want to be able to maintain this database according to customer number, purchase order number. Each customer number also has address, phone number, date associated with it.
this should be a small task for someone who knows what to do. All entries are already in excel so data transfer is easy.