Excel (PowerPivot) vs MS Access vs SQL Server

I've been searching the web high and low to help me explain, compare, and differentiate between data manipulation using various Microsoft Office tools. I've found many links and articles pre-PowerPivot and PowerView days, but cannot find anything more current.

Please help me understand the MAJOR differences between Excel, Access and SQL Server.

The basics that are known is that Excel is king for analysis of data, and quick-adhoc calculations and visual manipulations.
Access can store and link more data more effectively than Excel (PowerPivot), but has now lost pivot tables etc, but can feed INTO excel.
SQL Server (at least of these 3) is KING when it come to LARGE data sets, tables, connections, relationships, etc.

CROSSPOST