Terminé

Build me a awards points database

Hi,

I am looking to automate an awards point system. Each week we have an excel spreadsheet that automatically generates from our system listing the following information:

NameID (unique number)

Name

Points

The points update everyweek - I want to upload this points data into a database that can automatically update the records already contained in the system. From this I want the system then to have the ability to determine if the person gets a medal or trophy

E.g. John Smith has 1001 points and now is eligible for a Bronze medal

I want to be able to set the levels that database flags that person now gets a medal

E.g Bronze = reached 1000 points

Sivler = reached 2500 points

I also want to have the ability to have a yes/no option for each level of the medal/trophy when the person reaches that level

e.g.

Award prepared?

Award given?

Photo taken with Award?

Photo posted to Social Media?

I also want to have the ability to 'inactivate' a person's data if they leave the compertition. I want to have the data still there if they return, but not on an 'Active' list of participants.

After this is all set up of, I would like a GUI that can easly show the current medal recipients and the information about the award prep/given/phototaken etc, a function that allows data update, see a list of participants and area to mark inactive participants, the ability to have a logo included at a future time and some sort of lock that does not allow staff to see the backend and accidentally delete data.

If more information is required, I will be able to provide it.

Compétences : Excel, Programmation de bases de données, PHP, Microsoft Access, Architecture Logicielle

en voir plus : build online form database, build secure online database, build payment gateway database, build property website database, build organization chart database table vbnet, build sql server database driven photo gallery website, build auto part database mysql, build executable access database, build extensive excel database, build sql 2005 database, database creation program java gui interface, build email capture database, build real estate database, plot map points database using, build yahoo store database upload, build sports statistics database, dvc points database disney, build website customer database login, build auto parts database, let's build a simple database

Concernant l'employeur :
( 1 commentaire ) Kenmore, Australia

Nº du projet : #21809348

Décerné à:

Nouyana

Hello! I suggest you a two ways to make your awards point system: 1. Access database + Access forms; 2. Access database + stanalone application (no needs Access at all). I have fifteen years of experience in Visual bas Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 5 jours
(1 Évaluation)
2.6

42 freelance font une offre moyenne de $430 pour ce travail

uhjk

Hello, I can create this database using php and mysql. If you want I can host this system in my hosting for free too (I have unlimited package at godaddy). Also, pleaning to use some ready-made admin templates found on Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(893 Commentaires)
8.3
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(357 Commentaires)
8.0
branislavm

Hello! Will MS Access database work for you? There I can make requested quite easily and with a fully customized, user-friendly interface. I will need just a few more details and a sample (or real) Excel file. Regard Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(308 Commentaires)
7.6
latatestTech

With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) Hello, A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(165 Commentaires)
8.0
coolguyinus2004

I am an expert in PHP/MYSQL/JS/Jquery programming and i do the backend work like admin and staff login,Users data add or update or delete. CSV upload to update points via an interface. Pic upload for award etc.I dont d Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(345 Commentaires)
7.7
tranngocanh1702

Hi, I am able to build the awards point database to update automatically for nameid, name, points. Do you want to update weekly or daily? There will be the admin panel for you to set up level, yes/no option. I am read Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 21 jours
(182 Commentaires)
7.8
hjabeen972

I am expert website developer and designer i am ready to build your website within your budget and [login to view URL] can have a look my profile feedback by clicking on my name.I am ready to work on your project from right a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(184 Commentaires)
7.6
kodecubeinfosys

Hi, Greetings of the day! I read your requirement the need of a developer . i understood your idea well and can deliver same. We have done similar level of enterprise development before. We have developed 300+ enterp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(154 Commentaires)
7.2
fabest

*** I AM EXPERT IN MS ACCESS DATABASES *** Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I wil Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(99 Commentaires)
7.4
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(226 Commentaires)
6.9
ITPyramid85

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am software developer with enough experiences on PHP for 13 years. I can work by full time for your project and trying to satisfy the requirements. [login to view URL] www.b Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(28 Commentaires)
6.9
workerbee1974

Good day, My name is Donna. I have read your project description and I feel with more detail I could complete it to your vision.  I am a expert Microsoft  access database developer, I am also an expert in Microsoft Exc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(44 Commentaires)
6.6
VladimirLilenko

Hello dear sir! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirL Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 6 jours
(167 Commentaires)
6.6
peterkurt

Hi, I can build this system for award points with PHP 7.3 and Nette Framwork. Will need to know if you ant add points after excel upload/ if you want to store some history of points etc. Also will need to know if the d Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(31 Commentaires)
6.2
v2x5111

can we discuss? i am expert [login to view URL] we discuss? i am expert [login to view URL] we discuss? i am expert developer.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(131 Commentaires)
6.7
priyank086

Hello Dear Sir/Maam I have read project details carefully and understand that you are looking for a awards points database I have worked worked with some big companies of Central india . delivery on time and client sa Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(60 Commentaires)
6.3
lavizsolutions

Hi there,   Greetings, kindly share me some details so that can estimate time and cost. Please check once.. 1. Case Management system. [login to view URL] you can create activi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 20 jours
(23 Commentaires)
6.5
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 6 jours
(111 Commentaires)
6.2
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : " Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(56 Commentaires)
6.2
anuyadav1

hi, I have good experience in making applications for web and desktop with database which have automation in Python , Java and php . I am interested in this project , please share more details .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(52 Commentaires)
5.8