Spreadhsheet record manager with search and retrive form

Ukończone Opublikowano 7 lat temu Płatność przy odbiorze
Ukończone Płatność przy odbiorze

Windows Otra o no estoy seguro I have promoted to be in charge of all the users credentials, accounts and profiles for all the systems in the company where I work at. I need an Excel book (or maybe a MS access DB) where each system contains the users that have been granted access to the system (for example, one sheet for SAP, other for VPN and other for intranet). When the helpdesk assignes a ticket to me with a "grant access to a system" once I do the job I want to record the "new user" record in the proper sheet. Therefore all movements (creation, modifiying and removal) will be recorded in the spreadsheet. So, for example if a user has SAP and VPN, he should exist on the bith sheets. Then (the real reason why i need a coder) I neet to have a form where i can input the user ID and it retrive the data from the different sheets and show me "the user exists in..." so I can know with only one query all the systems that the user has been granted acces.

I know there is many identity/access management software but i need a simple Excel/access tool because my company doednt want to buy a big solution and we are not allowed to used unknown software. Thats why i need this to be done in excel or ms access.

Architektura oprogramowania Pulpit systemu Windows

Numer ID Projektu: #12524251

O projekcie

11 ofert Zdalny projekt Aktywny 7 lat temu

Przyznany użytkownikowi:

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Więcej

$100 USD w ciągu 7 dni
(6 ocen)
3.4

11 freelancerów złożyło ofertę za $162 w tym projekcie

cgullapalli

Hi, I am good at Excel and vba. Plz provide me the details further to get the scope of work. Looking forward to discuss in the chat.

$100 USD w ciągu 1 dnia
(23 Oceny)
4.8
schoudhary1553

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 ex Więcej

$250 USD w ciągu 2 dni
(10 Oceny)
4.5
cracken

Hi, I am competitive to this kind of task, can take good care of this project. We can use google api that update the spreadsheet for free of license. In fact, I already done related to this job before. Let me know th Więcej

$249 USD w ciągu 3 dni
(12 Oceny)
4.6
indiasofttel

Dear Sir, Greetings from IndiaSofttel, We reviewed your requirement for the development of Spreadsheet manager as Windows application and it's looking good for me. I had does several this kind of project and like to Więcej

$161 USD w ciągu 3 dni
(17 Oceny)
5.2
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD w ciągu 7 dni
(3 Oceny)
3.1
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. This should be made in Access and that is also something I can help you with. Please contact me for more information.

$155 USD w ciągu 3 dni
(6 Oceny)
3.1
chugoleng

Good Day, I am writing with reference to your posted job for want of a VBA Developer. I consider that my credentials and interests match with your requirement and want to propose for the same. Looking forward h Więcej

$111 USD w ciągu 3 dni
(0 Oceny)
0.0