When would it make more sense to use a databse application (Access, for example) instead of an Excel spreadsheet?

when one wants to store relative data its considered best since its nt redundant and it can store huge piles of data with best formatting