Закрыт

I need a Microsoft Access developer

I have little to no experience with access. However, I have managed to create a small recruitment database.

I am trying to get the status of the candidate to update automatically depending on what stage they are at of the recruitment process. (this may have been answered before but hours of searching i have come up with nothing)

Below i have listed the tables within the database and what field would indicate what status they are at. The tables are in bold and the fields are in []. What the status should be is in " ".

I have the following tables:

Candidate info - This is where the [Status] field is located.

Pre-interview

[Screening date] would suggest this candidate is in "Pre-Interview" State and I have another column which says [interview] This is a yes or no field. If yes, Status would change to "interview". If no, status should change to "closed - NFA(Failed Screening)"

Interview - if in the field [interview date] has been entered the status should remain as "interview" but if another field called:

[Result] = Fail. Status should change to "Closed - NFA (failed interview)"

[Result] = Cancelled. Status Should change to "Closed - NFA (Interview Cancelled"

[Result] = Yes & [Interview Priority] = Low - Status should be "Talent Pipeline"

[Result] = Yes & [interview Priority] = Fast Track - Status should be "fast track".

Onboarding

If the field [date financial approval requested] has a date then the status should change to "In Approval"

Another field called [Approved] = Yes then state should be "Offer Extended" otherwise "Closed - NFA (Offer Declined)"

If it is approved and another field [Result of Contract offer] = Accepted then status should be "Start Date Set" if declined then status should be "Closed - NFA (Offer Declined)"

Deployment

If field [Deployment Date] has a date in it then status should be "Deployment Date Set" otherwise it should state "On Bench"

If the date entered in "deployment date set" has passed then the status should change to "Deployed".

I really hope the above has made sense. I have literally no idea how to implement this and any ideas or help will be much, much appreciated.

Please let me know if further information is required.

Квалификация: Microsoft Access, Программирование баз данных, Excel, SQL, Visual Basic

Показать больше need microsoft access, microsoft access developer needed, need microsoft access programmer, need microsoft access assignment done, need microsoft access specialist, microsoft access developer software, need microsoft access school, do i need a web developer, find microsoft access developer, freelance microsoft access developer south africa, i need a computer developer south africa equity, i need a freelance developer nothwest england, i need a freelance developer to create a software, i need a good developer, i need a netsuite developer, i need a software developer to write an algorithm thats been written for horse racing, i need a software developer, i need a squarespace developer, i need a vr developer, i need a web developer delhi

О работодателе:
( 0 отзыв(-а, -ов) ) Swindon, United Kingdom

ID проекта: #22303143

31 фрилансеров(-а) в среднем готовы выполнить эту работу за £178

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 Больше

£240 GBP за 5 дней(-я)
(334 отзывов(-а))
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have an Access database that will use a combination of queries to retrieve useful dat Больше

£130 GBP за 3 дней(-я)
(282 отзывов(-а))
7.6
branislavm

Hello! I've read your description and from what can I see, I think some VBA coding will be required. I think that is where you stuck with. Can you share your DB with me? Regards, Branislav Mihaljev

£135 GBP за 7 дней(-я)
(262 отзывов(-а))
7.6
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access

£150 GBP за 3 дней(-я)
(109 отзывов(-а))
6.8
markpashalis

Hi, my name is Mark. I have 20+ years of expertise with MS Access and VBA and will be happy to help with your recruitment database. I've designed, developed and maintained many Access applications and am well-versed in Больше

£200 GBP за 3 дней(-я)
(15 отзывов(-а))
6.4
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 Больше

£150 GBP за 2 дней(-я)
(175 отзывов(-а))
6.7
wsh2

Summary: Highly skilled and experienced MsACCESS professional here, ready, and able to help. At your earliest convenience, could you please zip and attach a copy of your database(s) to this private chat message threa Больше

£189 GBP за 7 дней(-я)
(54 отзывов(-а))
6.5
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Suites and macro/VBA development, I can writ Больше

£150 GBP за 3 дней(-я)
(96 отзывов(-а))
6.1
royalcalif

Let me review the existing database to calculate the 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 report to Больше

£20 GBP за 1 день
(113 отзывов(-а))
6.2
usmanhassan123

I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects of: • Excel Automation. • Excel Reports system. • Exce Больше

£250 GBP за 1 день
(73 отзывов(-а))
6.2
jawadaman

Hi I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer. If interested in hiring me then please Больше

£250 GBP за 7 дней(-я)
(91 отзывов(-а))
5.8
VBAautomation

Hi, I am a professional MS Access and SQL database developer. I am developing MS Access since 2009 and have excellent command on all versions. I can provide you best support on your project. I appreciate your knowled Больше

£200 GBP за 4 дней(-я)
(32 отзывов(-а))
5.3
KellogITSolution

Hello I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Больше

£135 GBP за 7 дней(-я)
(38 отзывов(-а))
5.0
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 activ Больше

£1000 GBP за 15 дней(-я)
(4 отзывов(-а))
5.2
Altantsetseg

Hi. From your project declaration, its the kind of task that I have been experienced well. I have been experienced in programming including Ms Access since 2000. During 2006-2013, I had been working as a senior develop Больше

£150 GBP за 7 дней(-я)
(12 отзывов(-а))
4.9
dionisiotumbaga

Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

£120 GBP за 7 дней(-я)
(7 отзывов(-а))
4.1
khaldalfalah

Hi,I am ready to work on your project, please send more details to see how I can help you. I have experience in MS SQL server,asp.net, crystal reports and VB.net more than 12 years. CV: I am software engineer, Holder Больше

£220 GBP за 5 дней(-я)
(8 отзывов(-а))
2.8
alokes

HI, I AM A SOFTWARE PROFESSIONAL DEVELOPING SOFTWARE IN MS ACCESS WITH VBA FOR LAST 22 YEARS. I WOULD LIKE TO DEVELOP THE DATABASE IN MS ACCESS AS PER YOUR REQUIREMENT AND INPUT PROVIDED BY [login to view URL] TASK WILL BE COMPLET Больше

£100 GBP за 3 дней(-я)
(6 отзывов(-а))
3.6
Nouyana

✅SPECIAL OFFER✅ Hello! Thanks for the detailed description. I suggest you to recreate your recruitment database as a standalone application (not an Access application) for the same money and in short terms. But of cou Больше

£120 GBP за 4 дней(-я)
(1 отзыв)
2.6
VnNorthStar

Hi I’m ready for the project I’m an expert in Access development I read your specifications and I am sure I can do it perfectly Please give me a chance to work for you

£100 GBP за 7 дней(-я)
(7 отзывов(-а))
2.7