To make the long story short one could say that MS Access (as a database) is used to collect, store and organize the data. Excel on the other hand is meant for representing data in various ways.
But there is so much more in the background, when we talk about Microsoft Access itself. If we look at
The differences between Microsoft Excel and Microsoft Access - Quora
Excel, a spreadsheet program, allows free form development of data management and/or mathematical calculations starting with a "clean slate," numerous formul...