Hi VBA Experts,

I am a new guy here.

My boss asked me to think/create a small database for our start-up business. I'm an electronic engineer and have no clear idea how to do that, as Google search indicated there are so many possibilities. The first thing in my mind is using Excel to make one to solve the current problems. Does anyone of you experts could give me some advice? A template would be highly appreciated

The database has two parts, one should something like a Production-line Information Registration, and the second part should be a database to collect large amount of technical data generated by customers machines everyday. The second part is the major issue and the data would be used for post-processing based on various queries. I am thinking to use VBA plus Power BI to do the second part. Any good ideas are welcome!

Many thanks.

Best regards,
Ji