Create Access project database from Sage with built in Excel reporting

We need to create an Access database from Sage line 1000 base data.
The database will be used to track the costs associated with individual projects.
Will need to import data from our Sage SQL server and from our locally saved files. Sort this data by project code and show a summary of invoices, purchase orders, man hours expended.
Database should then automatically create a formatted Excel report in keeping with predefined company template.
We're looking for a solution that's fully or almost fully automated.
Full scope will be made available to those who can prove top class VBA/Access skills.