Run Macro to generate report in Access from excel data, then print PDF from Excel?

Hi
I have set up a link between Excel and Access, so that I can create the report, however I want to be able to press a button in excel, say in a Tab called January, that will run a macro that looks in access for that linked table, generate the report, Hopefully behind the scenes, then open in PDF in Excel for printing or saving...

I'm being picky and think the access reports look "Prettier"

OR

I have managed to create a macro in Access to do the report part automatically, is there a way to import or put this macro into excel????

Is this possible, I am fairly new to using VBA and Macros, so any solutions, very gratefully accepted..

Thanks