Forum

Notifications
Clear all

Using excel to create a database

3 Posts
3 Users
0 Reactions
135 Views
(@private-benjamin)
Posts: 10
Eminent Member
Topic starter
 

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

 
Posted : 01/05/2021 5:22 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Andrea,

I wonder if custom data types could work for this task.

Mynda

 
Posted : 01/05/2021 7:17 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Andrea

Possible to supply some sample data and your expected result?

Sunny

 
Posted : 03/05/2021 12:38 pm
Share: