Microsoft has a great article addressing Access and Excel, as does FMS. I have my own ideas as to why a Compensation professional would want to use both Access and Excel. Links to both articles:
Microsoft – Top 10 Reasons to use Access with Excel
FMS – Microsoft Access versus Microsoft Excel for Data Analysis and Reporting