Automate MRP System with Easy System (invoice automation) using "VBA code in Microsoft Access"

I need to automate an Horizon MRP Plus system with Easy System for invoice automation using VBA code within Microsoft Access to streamline several key processes.

The system should be capable of automating the generation of invoices, tracking inventory, and creating purchase orders efficiently. It will also need to handle data input through integration with external systems via SFTP.

****Project Goal: Integrate our "Horizon MRP Plus software" with external resource called "Easy System (https://www.easysystems.nl/en/)". Need to handle/ exchange data via SFTP (Cloud), format can we JSON/API format

Ideal Skills and Experience:
- Strong proficiency in VBA code in Microsoft Access
- Experience with SQL/ DBMS in access to manage databases/ tables
- Background in the automotive manufacturing sector
- Proven track record in invoice automation and enhancement to "integrate our Horizon MRP Plus software with Easy System (https://www.easysystems.nl/en/)"

Note: Need to deliver with 2-3 Weeks from start (by end of OCT 2025)

Please provide examples of similar projects you've completed and your approach to handling such tasks.