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.
Budget €30-250 EUR
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.
Awarded to:
Hello, I'm a data analyst from France. I'm used to work everyday with Excel/VBA & databases. I can build you a Dashboard with all the requirements you need for you to follow this training courses. I will have some More
14 freelancers are bidding on average €172 for this job
Hi, As I understand you would like to read the data from two MS Access databases and write to Excel Dashboard. Also creation of Google appointment. It would help to discuss on this. I am well versed with Excel VBA as More
Good afternoon. What other platforms do you want to host it on? Do you want to add plugins there? To make sure they will buy your product, you need to conduct an analysis, this can be done using the program. Do you hav More
Hello, introduce my name is Deddy. I am interested in participating in your project. I have long time used [login to view URL] as a tool to create custom database applications. I have included several applications in my portfoli More
Hi there, Gone through your requirement and yes i can help you to get the required details. I am a Microsoft Certified Professional. Awaiting your response to get more details on this project. Regards, Karthick G.
Hello! I have read your requirement carefully, so I am very interested your project. I have rich experience with data processing using Excel VBA. I will finish your Excel VBA project in time with high quality Hope your More
Hello. I'm an expert of this field. Especially I have good skills in C# and Excel VBA. If you give me a chance, I will do my best for you. Thanks. Rustam.
Hi, My name is Ankur, LinkedIn Profile: [login to view URL] I have done designed so many MS access based automation, i am sure i can share the solution with you in 2 days or 3 days More
