As long as you have a clear division of labor.

Access is only used to save data, regardless of any problems displayed in the report.

Excel is only used to make reports, only considering the interface and beauty.

Because both Access and Excel are developed by the same company. These two softwares can transmit data to each other.

take for example

Access can export table data to Excel or import from Excel files.

Excel can also run external queries, and the data source comes from Access.