Using excel to create a database|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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