I have a small business doing online sales and would like to get a database developed to keep stock control and sales etc. Currently I am using excel but it is becoming tedious and I know that a database can do this more effeciently. Look at my website w w w ukshopsite dot com. These are the product that I sell.
The database will need a form to enter supplier details etc and then a form for purchase orders. Then forms for sales and finally reports of purchase sales and inventory.
Need to be able to calculate per item cost as well after adding delivery charges/taxes/ etc.
The database should be able to handle variations e.g gloves in s m l and xl size etc. bags in different colours etc.
Example of the excel sheet that I use is attached to give an idea what I am currently doing.