Restaurant Billing System

[dharminderarora]

Hi All,
I am a moderate level excel and VBA user, I want to create a billing system for one of my friends restaurant, I need suggestions from experienced excel users in the forum, how should I go about this. I mean what should be the approach for this system

 

[RexCampbell]

Re: Need suggestions for Restaurant Billing System

My honest opinion would be to use a back end database like MySQL or the free version of SQL Server and design an app using .NET. I would avoid using VBA all together as it would be easy to break for end users. Personally, I would use .NET and a third party free application called NPOI (which does a great job of importing and exporting to Excel) and does not cause issues like HTML to Excel. 2nd advice, Use Squirrel or Aloha which are the most popular restaurant based applications and are not that expensive.

 

[Joe4]

Re: Need suggestions for Restaurant Billing System

Welcome to the Board!

I find database programs are usually better for this kind of task (which Excel is not). The previous reply mentioned SQL or MySQL. For a little simpler version, you could also just use Microsoft Access, and have everything contained within.

My only recommendation is to make sure it is well-designed, which usually means understanding Relational Database theory & design. If you are not familiar with these concepts and Access, you probably wouldn't be able to create a well designed database yourself, unless you acquire those skills first.

 

[dharminderarora]

Re: Need suggestions for Restaurant Billing System

Thanks very much for your quick replies, I will be starting my work on access, thanks again