Database manipulation to develop report

$30-250 AUD

Teljesítve

Kiadva ekkor:

több mint 5 évvel ezelőtt

$30-250 AUD

Teljesítéskor fizetve

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

Projektazonosító: 18304135

A projektről

8 ajánlat

Távolról teljesíthető projekt

Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@aubrey03

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 3 napon belül

4,8

(130 értékelés)

6,0

8 szabadúszó adott átlagosan $132 AUD összegű árajánlatot erre a munkára

@periyannas

I shall do it excel vba for you.

$155 AUD 3 napon belül

5,0

(115 értékelés)

6,4

@ITPyramid85

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 3 napon belül

4,9

(9 értékelés)

5,8

@VBAautomation

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 1 napon belül

4,8

(31 értékelés)

5,3

@prasannjeetp

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 3 napon belül

4,4

(46 értékelés)

4,6

@ksab

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 5 napon belül

5,0

(4 értékelés)

2,7

@Evergreenshivi

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 3 napon belül