Michael Jillions

Why struggle with MS Excel when MS Access can do a much better job!

MS Access is just a bigger and better version of Excel, it can do everything Excel can do but a lot more and yet I still see people with hoards of spreadsheets all with formulae cross referencing from another. Why are these people still using Excel for this job! There are a lot of people out there that are using MS Excel to house their accounts or... (posted by Michael 2 years 205 days ago.)

MS Access vs. SQL / Oracle

Throughout my years working with Access, initially using it as a glorified spreadsheet package, I have gradually honed my skills but I am still learning new things everyday. Every new project takes my knowledge to a new level and I want the business world to realise just how versatile this product really is. Having built systems as complex as Reinsurance pool ledgers I know just how powerful it can be. It is a shame that the IT... (posted by Michael 2 years 253 days ago.)

How to program a distance check facility between to UK postcodes in Microsoft Access

Being able to calculate the distance between two postcodes is of an enormous benefit in many software applications. We at Mill House Data Solutions have used it to great effect many, many times. There are online companies who can offer automated access to their distance check software but not only will this cost, but will rely on internet access as well. This method will... (posted by Michael 2 years 257 days ago.)

How to Build a Simple Distance Checker between 2 UK Postcodes into Your Access Database

Being able to determine the distance between two places is of an enormous benefit in many software applications. There are simply hundreds of uses and we at Mill House Data Solutions have used it to great effect many, many times. There are online companies who can offer, for a subscription, automated access to their distance check software but this will not only cost... (posted by Michael 2 years 258 days ago.)