Completed

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.

Skills: Excel, Database Programming, PHP, Microsoft Access, Software Architecture

See more: 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

About the Employer:
( 1 review ) Kenmore, Australia

Project ID: #21809348

Awarded to:

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 More

$270 AUD in 5 days
(1 Review)
2.6

42 freelancers are bidding on average $430 for this job

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 More

$500 AUD in 7 days
(893 Reviews)
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 More

$500 AUD in 7 days
(357 Reviews)
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 More

$450 AUD in 7 days
(308 Reviews)
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. More

$440 AUD in 7 days
(165 Reviews)
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 More

$375 AUD in 2 days
(345 Reviews)
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 More

$500 AUD in 21 days
(182 Reviews)
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 More

$375 AUD in 2 days
(184 Reviews)
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 More

$375 AUD in 7 days
(154 Reviews)
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 More

$250 AUD in 10 days
(99 Reviews)
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 More

$400 AUD in 7 days
(226 Reviews)
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 More

$375 AUD in 7 days
(28 Reviews)
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 More

$388 AUD in 5 days
(44 Reviews)
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 More

$300 AUD in 6 days
(167 Reviews)
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 More

$500 AUD in 2 days
(31 Reviews)
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.

$375 AUD in 7 days
(131 Reviews)
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 More

$500 AUD in 7 days
(60 Reviews)
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 More

$555 AUD in 20 days
(23 Reviews)
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 More

$250 AUD in 6 days
(111 Reviews)
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 : " More

$500 AUD in 7 days
(56 Reviews)
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 .

$277 AUD in 4 days
(52 Reviews)
5.8