Microsoft Access- is it really that powerful?

Recently I was asked if Microsoft Access is actually very powerful. It is! We have created systems that contained more than a million records in some of the tables-