Hi there, and welcome to the forum!
I routinely use Access as a back end database for storing my data and do the generation/manipulation/reporting in Excel, so yes, I'm certain this could be done. You'd need to flesh out a lot more of the logic to make it happen though. As long as you're willing to do the leg work on it with our advice/tuotoring, we can certainly help you out. (We can also find you a consultant if you just want to pay someone to take care of it for you.)