Lukket

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.

Evner: Microsoft Access, Programmering af database, Excel, SQL, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Swindon, United Kingdom

Projekt ID: #22303143

31 freelancere byder i gennemsnit £178 på dette job

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 Flere

£240 GBP in 5 dage
(334 bedømmelser)
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 Flere

£130 GBP in 3 dage
(282 bedømmelser)
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 in 7 dage
(262 bedømmelser)
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 in 3 dage
(109 bedømmelser)
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 Flere

£200 GBP in 3 dage
(15 bedømmelser)
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 Flere

£150 GBP in 2 dage
(175 bedømmelser)
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 Flere

£189 GBP in 7 dage
(54 bedømmelser)
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 Flere

£150 GBP in 3 dage
(96 bedømmelser)
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 Flere

£20 GBP på 1 dag
(113 bedømmelser)
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 Flere

£250 GBP på 1 dag
(73 bedømmelser)
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 Flere

£250 GBP in 7 dage
(91 bedømmelser)
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 Flere

£200 GBP in 4 dage
(32 bedømmelser)
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 Flere

£135 GBP in 7 dage
(38 bedømmelser)
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 Flere

£1000 GBP in 15 dage
(4 bedømmelser)
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 Flere

£150 GBP in 7 dage
(12 bedømmelser)
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 in 7 dage
(7 bedømmelser)
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 Flere

£220 GBP in 5 dage
(8 bedømmelser)
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 Flere

£100 GBP in 3 dage
(6 bedømmelser)
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 Flere

£120 GBP in 4 dage
(1 bedømmelse)
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 in 7 dage
(7 bedømmelser)
2.7