Hi guys!
I have searched for weeks and need some help finding the right solution.
First I’m a beginner to intermediate in Excel and more of a beginner in Access but understand the principals of VBA. I need to create a program for employees to create, search and edit orders. The orders need to be track by status of payments, location (NOT geographical!) completion etc. I don’t want the users to deal with the data directly so I want to create forms to accomplish all the task, they need to calculate prices in real time. And it all needs to be accessed through the web, preferably on a browser. I am basically creating a POS… but not as complex. Is no small task but I know the calculations are not extremely complicated.
We are very limited on cash and can’t afford a custom solution for $20,000+ not to mention the $500 monthly server fees. I feel like a solution that large is not meant for a company like ours. Those are enterprise level solutions and our database won’t hit the 50,000 rows in a year and that’s accounting for all the tables (I’m tracking many aspects on an order)
Right now I am thinking that I can pay for an Azure sql server, create an Access DB (maybe a web app?) and import the tables into excel so I can use PowerPivot for reporting (effectively avoiding access reporting because PP is awesome!). keep in mind that I have never used Azure, nor uploaded access to an SQL DB. Im not sure if I am thinking of all this the right way.
I also thought of just using Excel and PowerPivot plus the forms for the users. Putting that into SharePoint for everyone to use.
Another solution would be to use Caspio but I feel like it would be just as much work to create something with them and I would get as much for my money. Anyone used or is using Caspio?
So what do you guys think? Maybe I haven’t heard of a solution that can solve all my problems and that is easy to use.
I have searched for weeks and need some help finding the right solution.
First I’m a beginner to intermediate in Excel and more of a beginner in Access but understand the principals of VBA. I need to create a program for employees to create, search and edit orders. The orders need to be track by status of payments, location (NOT geographical!) completion etc. I don’t want the users to deal with the data directly so I want to create forms to accomplish all the task, they need to calculate prices in real time. And it all needs to be accessed through the web, preferably on a browser. I am basically creating a POS… but not as complex. Is no small task but I know the calculations are not extremely complicated.
We are very limited on cash and can’t afford a custom solution for $20,000+ not to mention the $500 monthly server fees. I feel like a solution that large is not meant for a company like ours. Those are enterprise level solutions and our database won’t hit the 50,000 rows in a year and that’s accounting for all the tables (I’m tracking many aspects on an order)
Right now I am thinking that I can pay for an Azure sql server, create an Access DB (maybe a web app?) and import the tables into excel so I can use PowerPivot for reporting (effectively avoiding access reporting because PP is awesome!). keep in mind that I have never used Azure, nor uploaded access to an SQL DB. Im not sure if I am thinking of all this the right way.
I also thought of just using Excel and PowerPivot plus the forms for the users. Putting that into SharePoint for everyone to use.
Another solution would be to use Caspio but I feel like it would be just as much work to create something with them and I would get as much for my money. Anyone used or is using Caspio?
So what do you guys think? Maybe I haven’t heard of a solution that can solve all my problems and that is easy to use.
Last edited:
