Find Jobs
Hire Freelancers

Access Database for Awards

$25-50 CAD / hour

Closed
Posted about 7 years ago

$25-50 CAD / hour

I have a list of 1300 applicants for 150 awards in an Excel file. Each award has several criteria that must be met. I need a way to sort this list to find the top 10 applicants for each award, based on the criteria. The end user should be able to find the name of the award from a drop down menu, and have the top candidates show up below.
Project ID: 13719672

About the project

39 proposals
Remote project
Active 7 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
39 freelancers are bidding on average $31 CAD/hour for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3). If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$30 CAD in 40 days
5.0 (248 reviews)
7.7
7.7
User Avatar
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$25 CAD in 5 days
4.9 (230 reviews)
7.1
7.1
User Avatar
Hello This should be straight forward - please send me the excel with the criteria details About myself: ----------------------- I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other platform. I am also among the top three MS Access developers on this site. You can verify by going to https://www.freelancer.com/freelancers/skills/Microsoft_Access/ regards Rajiv
$25 CAD in 3 days
4.9 (154 reviews)
6.9
6.9
User Avatar
Hello, I've got extensive expertise with MS-Access and Excel programming. I've recently done two Excel and MS-Access projects: • https://www.freelancer.com/projects/Excel/Build-Historical-Stats-Database-Using/ • https://www.freelancer.com/projects/Software-Architecture/Write-some-software-8244997/ Both them relied on elaborated queries that perform multi-criteria evaluation to build 'top-x' type rankings. I find such features do match your main requirement. Looking forward to your contact, Grunty.
$35 CAD in 20 days
5.0 (8 reviews)
6.3
6.3
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$25 CAD in 20 days
4.9 (24 reviews)
6.1
6.1
User Avatar
Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. I’m a ms Access/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$25 CAD in 40 days
4.7 (73 reviews)
6.5
6.5
User Avatar
Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I'd like more details about the selection criteria so that I can give you my final timeframe and quote. I have done similar assignments previously, so check my profile for details. I'm looking forward to hearing from you. Regards,
$25 CAD in 40 days
4.9 (72 reviews)
5.9
5.9
User Avatar
Dear Client, My name is Dipak Moliya. I’ve read your project description and can see that you need a way to sort a list of 1300 applicants for 150 awards to find the top 10 applicants for each award, based on the criteria so that the end user can find the name of the award from a drop down menu, and have the top candidates show up below. I have 6 year's experience designing and developing Microsoft Access Application (Online/SharePoint/Offline/Desktop) with advance knowledge of Database Designing, Forms and Reports designing, SQL, VBA. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. Additionally, as your requirements, I can do the following…. I can make it so it can be used in Multi-user environment (With different access level for each user.) with log-in dialog. I offer you the access application with very user-friendly forms having functionalities like auto-filling easy data selection through dropdowns, Search and filter data, Validation rules etc... I can make printable reports with the ability to export data to Word, Excel, PDF etc. The user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded from this main Home form through button clicks to access their functionality. Thank you for taking the time to read my proposal. With Best Regards
$25 CAD in 10 days
4.9 (70 reviews)
6.0
6.0
User Avatar
Hi, I have been an independent Access programmer in New Jersey for the last 20 years. Access is all I do, full-time. Hence I work quickly and efficiently and have a lot of great ideas from all the projects I have worked on. I have designed thousands of programs for hundreds of companies in the New York metro area. I have completed over 150 jobs on Upwork/Elance/Freelancer/Guru. I am available by phone or email, business and non business hours. and will be around in the future if you need little tweaks. I can respond quickly to requests. Better known companies I have worked for over the years are Shredit, Shiseido, Multi-Lok , The Alzheimer's Organization , Waterjel and Shop Rite. I would be glad to talk to you on the phone in detail and come up with an estimate.
$38 CAD in 40 days
5.0 (6 reviews)
4.7
4.7
User Avatar
- Can get the top ten candidates listed for each award by the criteria determined. - Will take the critieria required from the user input and bring up the results. - Can show up the final result, like when you select a award, the the list of applicants for that award ordered by the top10 at the top can be shown. - - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$25 CAD in 40 days
4.8 (13 reviews)
4.5
4.5
User Avatar
I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$25 CAD in 15 days
4.9 (30 reviews)
4.5
4.5
User Avatar
Dear sir, Greetings. If i have those applicants data and criteria, able to develop the MS Access db within 1-2 days. I would try to take the less hour possible. Plz let me know if you like to discuss more on this. Thank you.
$27 CAD in 15 days
4.9 (13 reviews)
3.9
3.9
User Avatar
I have 18+ years of software development. I am Microsoft Certified developer and trainer. I work with customers till they are happy with the product.
$27 CAD in 4 days
5.0 (7 reviews)
2.8
2.8
User Avatar
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. Please award me this project and contact me for further details and the price is negotiable based on the project.
$41 CAD in 40 days
4.8 (4 reviews)
2.9
2.9
User Avatar
I have the expertise in Excel and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$27 CAD in 10 days
4.6 (7 reviews)
2.7
2.7
User Avatar
Good day, With 12+ years of experience as a database developer, administrator and trainer I know I am best suited to getting your project done as you require and as quickly and efficiently as possible. Since you already have the details in an excel file, my work would largely only require me to build a structure that sorts the information in a suitable structure for recall later. I would suggest an Access Database for this as it is powerful and easy to use and can be adapted quickly to your changing needs. It is also possible to build a 'system' in excel using complex formulas, however over time this will fall apart as excel is not a database engine. I believe that the entire system can be completed in excel in a week or less. I can commit 30hours in a week to get this project done, however to make it final, let us discuss all your requirements first and I'll give you a 110% accurate estimate after having all the information required to help you. Looking forward to working with you on this project. Regards, Rob
$31 CAD in 30 days
5.0 (1 review)
2.6
2.6
User Avatar
Making an required database from excel sheet might be tricky but it is an easy task. I am possessing skills in the access and can bring down you work in less time than any other.
$27 CAD in 6 days
5.0 (2 reviews)
1.1
1.1
User Avatar
Hi there! This is a very simple application and it all depends on the criteria for the awards, how they are stored and how you want them used to sort the applicants. Provided that the Excel file is straightforward, it should not take more than 2 hours to create a simple Access application to display the top applicants for each award depending on the award selected.
$27 CAD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an accounting clerk with data entry and administrative experience . I am seeking a legal data entry job.
$25 CAD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
My job as a Database manager was to export Excel spreadsheets to Access and then create queies forms,etc. I build the database based on customers needs. Then I also train users of the database.
$28 CAD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Canada
0.0
0
Member since Apr 13, 2017

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.