Find Jobs
Hire Freelancers

Database manipulation to develop report

$30-250 AUD

Fullført
Lagt ut over 5 år siden

$30-250 AUD

Betalt ved levering
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
Prosjekt-ID: 18304135

Om prosjektet

8 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
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 om 3 dager
4,8 (130 omtaler)
6,0
6,0
8 freelancers are bidding on average $132 AUD for this job
Brukeravatar
I shall do it excel vba for you.
$155 AUD om 3 dager
5,0 (115 omtaler)
6,4
6,4
Brukeravatar
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 om 3 dager
4,9 (9 omtaler)
5,8
5,8
Brukeravatar
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 om 1 dag
4,8 (31 omtaler)
5,3
5,3
Brukeravatar
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 om 3 dager
4,4 (46 omtaler)
4,6
4,6
Brukeravatar
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 om 5 dager
5,0 (4 omtaler)
2,7
2,7
Brukeravatar
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 om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Certified Microsoft Developer with 12 Yrs experience, I can able to perform this project.
$155 AUD om 3 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

AUSTRALIAs flagg
Munruben, Australia
5,0
1
Betalingsmetode bekreftet
Medlem siden jul. 5, 2018

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.