Hi< I am a trainer/assessor for Vocational Qualifications. The company that I work for uses a database (Axcelerate) as a data management system, from which, I can request reports that can be exported in Excel.
Typically, I get one line for every unit of competency a student is undertaking. Typically 16 lines per student. The outcomes have three possibilities CA - Not yet completed, CT - Completed by Credit Transfer, and C - completed.
I wish to run this report and based on the results, I wish to send an email to each student at a convenient time each month, this email should show the following information,
Units completed so far and how achieved - Unit Code, Unit description, then "C" or "CT" as appropriate
Number of units not yet completed (CA) and then listing the Unit Codes and Unit Descriptions for these units remaining to be done.
Frankly, I do not know where to start, I suspect Access report may be required, but am open to suggestions.
The database example that I can extract as the source each month is attached for your perusal.
Hoping you can bring wizardry and magic to the table to help me out.
Looking forward to hearing from you.
Regards
Kevin
I am an Excel and VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel.
You may check some of my projects here: [login to view URL]
$100 AUD in 3 days
4.8 (130 reviews)
6.0
6.0
8 freelancers are bidding on average $132 AUD for this job
hello,how are you. i read your bid carefully.
i am C#, .Net expert and have full experience for 7 years.
C#, .Net is my top skill and my interested skill.
I can provide most quality and high fast.
if you want to success, please contact me.
Then, I will give you good result.
hire me.
Hi,
I am a professional MS Access and SQL database. I can provide you best support on your project.
I have gone through your requirements. The possibilities are below:
Create a function to generate appropriate data and export to excel. We may require an Excel template to perform this. Excel template would be modified on run time.
There will be a setup form with few command buttons like Send email and Generate Excel Report. At the detail view list all the students with a selection option. You can select all or a few and click on the button.
Let's have a chat and show me your database. I can provide best solution and complete within few hours.
Thank you
Hi,
I am an Excel Expert with very good knowledge of VBA. I can make this as an excel based software.
Please come on chat for more details.
Thank you
Awaiting your response.
I need to know if the axcelerate. database can be accessed directly si that I can code a PHP or Java program and pull the data and dynamically generate the report.
the report can be formatted as per the conditions you have given.
PHPmailer functions can be used to send emails to the students.
we also need student details like email is name to forward the emails.
Thanks and looking forward to work on the project.
The PHP system can be run locally in your desktop.
We have read your project description and will surely develop a modern project for your business as per your specifications. In the past year we have developed 50+ sites for business like your requirement