Reading with VBA of 2 connected Microsoft access databases and writing of monthly installments to an Excel dashboard. Creation of an appointment / deadline on google calendar and removal at the time of payment.

On the Access database, after entering an expected payment date, an appointment / deadline on google calendar and the removal of the same after having flagged the payment. Excel Dashboard Creation: I have to read 2 connected database access to find the expected installments of a training course to be paid in that month and report them in a column of the month "Expected Installments". Once paid, update the dashboard with another "Paid installments" column of the same training course. In another column enter the total number of students of that training course. Of course, there are several training courses to report on the dashboard and make the sum of the installments expected to be collected and those already collected in that month.