Find Jobs
Hire Freelancers

Database manipulation to develop report

$30-250 AUD

Completed
Posted over 5 years ago

$30-250 AUD

Paid on delivery
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
Project ID: 18304135

About the project

8 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
I shall do it excel vba for you.
$155 AUD in 3 days
5.0 (115 reviews)
6.4
6.4
User Avatar
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.
$200 AUD in 3 days
4.9 (9 reviews)
5.8
5.8
User Avatar
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
$100 AUD in 1 day
4.8 (31 reviews)
5.3
5.3
User Avatar
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.
$100 AUD in 3 days
4.4 (46 reviews)
4.6
4.6
User Avatar
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.
$94 AUD in 5 days
5.0 (4 reviews)
2.7
2.7
User Avatar
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
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Certified Microsoft Developer with 12 Yrs experience, I can able to perform this project.
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Munruben, Australia
5.0
1
Payment method verified
Member since Jul 5, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.