Moving On From An Access Database

[cojak]

I'm not advanced enough to use Access, I haven't got beyond excel spreadsheet and dashboards..

[Cirrus]

I'm not advanced enough to use Access, I haven't got beyond excel spreadsheet and dashboards..

Really? Well, why don't you come upstairs and see my QBE grids?

[WTFH]

Simon, how many tables do you have in the current Access database?


How many records per table?


Are you looking for a sledgehammer to crack a nut?




Before suggesting a solution I would like to understand the requirements more fully.

[DimPrawn]

Or another approach I saw at a big bank was to write all the dashboards in Excel and then put calls in the Excel sheets to collect the data from Access.

This is why working in a bank is great. They spend all the money on pay and bonuses and then rely on stuff like this.

[DimPrawn]

This might be worth looking at:

https://www.zoho.com/creator/

Looks very good.

[Cirrus]

Also

https://www.mendix.com/

[_V_]

What is astounding is how MS just sat there and watched the World go to the web, cloud, apps, browser etc and after 10 years of doing nothing with Windows and Office, suddenly realised there was a need to move applications and data away from the desktop fat client.

[Contreras]

Before suggesting a solution I would like to understand the requirements more fully.

Wut!!

[WTFH]

Wut!!

Option 1: Quote them for something which is probably overkill, deliver it in 2x the time and 3x the price, only understanding the requirements half way through and it's your fault.


Option 2: Spend a month doing requirements gathering, then start to deliver exactly to their spec. When they realise they haven't told you it all, you get angry with them and do more requirements gathering. Finally you deliver it in 3x the time and 5x the price and they are cross with themselves for getting it wrong.


Remember, this is a forum for pros.