December 16, 2020
Hello brains trust
Hoping someone can give me some advice as I'm a bit stumped at the moment, and need some guidance. Not sure if I will get the best result from using excel or whether I should use microsoft access what do you think?
I need to create a database which will hold a number of supplier's each with approximately 20 items, we have approximately 50 customers, (i'm a volunteer in a community group) we currently place 1 monthly bulk order with one of the nominated suppliers ordering from their products only for that order, then the next month we will rotate to a different supplier and place the order with them and so on.
Currently the admin is only using a straight forward excel spreadsheet with the customer name in column A running down and the products types in col B onwards, then they manually insert the quantity into each cell. The s/s is big and to be honest everything is done manually and I cant get me head around it.
I'm thinking that a database with the customer names and supplier details set up would be the way to go, so we would simply click on the persons name , select the products and quantity required and then it would combine all the info and then create the order - but I'm having a complete mind fart on how to start in excel. Any one offer some words of wisdom...please....thanks
July 16, 2010
I wonder if custom data types could work for this task.