Find Jobs
Hire Freelancers

Simple contacts directory using VBA

€8-130 EUR

Suljettu
Julkaistu lähes 5 vuotta sitten

€8-130 EUR

Maksettu toimituksen yhteydessä
There are 2 excel files: [login to view URL]: - contains information about the contacts that belong to some company - contains information on what kind of present was sent to this contact for the Christmas throughout multiple years (types of presents: card, eCard, calendar, other (+comment field)) - contains also deactivated contact – i.e. was a contact but not anymore in the company (these contacts are marked with strikethrough) - contact can be of different category (contact, alumni an etc.). A single contact can be of multiple categories - contact is assigned to specific responsible person [login to view URL]: - contains information about the companies and the contracts that are made with this company. So, one company can be entered multiple times due to the different contract number. - company is assigned to specific responsible person I need an access, excel or standalone tool that will be used as a contact directory tool. Prior to the functionality – several challenges that need to be resolved: - the db structure and itself should be created – preferably with MS Access, as there is no possibility to install additional app on the pc - the existing data should be imported - the user should predefine the column names, where the information about the Christmas presents is, because these should probably be inserted in separate table - some of the companies in the contacts file do not exist in the companies file or have different name, therefore a manual mapping ui is needed Further, the following functionality with UI should be done: - Add Users / Companies - Search through contacts via name, last name, company name, responsible person name - Filter contacts by responsible person name - Search companies by names, contract numbers, and responsible person name - Filter companies by name and responsible person name - See what a responsible person has sent to his/her contacts in the last years, so that he/she can decide what to send in the current. - Prepare a letter (word files) for multiple contacts at once (vba code is prepared, so a placeholder is sufficient, the rest can be integrated on our own) - Deactivate column for the contacts, which is a checkbox for just making the font color red, so that it is clear that this contact is no longer important / left the company. - Export data for the selected contacts - Events. Need a functionality to add events (event name, date, country, city, address, comment) and add participants to these events. Also see the list of participants for the selected event and export list of participants. There might be minor points that I’ve forgot, but mainly this is the functionality. If you decide to do the tool in Excel (both UI and DB) – I have a partial structure fully ready, so one needs only to implement the code, if in Access – there is more done, but should be checked and optimized anyways.
Projektin tunnus (ID): 19753394

Tietoa projektista

31 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
31 freelancers are bidding on average €152 EUR for this job
Käyttäjän avatar
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 some tables in Excel imported in a new Access database. Functionality regarding searching and filtering records will be integrated as well as exporting a group of records into a Word template with placeholders. I will charge you 130€ and can deliver within five days (a single milestone to release once you're satisfied with the final result). I'm among the most experienced and skilled MS Office, and VBA developers on this platform. I am in the top 3% of the freelancers having completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
€130 EUR 5 päivässä
4,9 (464 arvostelua)
8,3
8,3
Käyttäjän avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€200 EUR 7 päivässä
5,0 (456 arvostelua)
8,3
8,3
Käyttäjän avatar
hI, I am certified for Microsoft Office, Microsoft Excel, Word and Access. I am good command over data management in Excel Dashboard, Spreadsheet as well as in Microsoft Access Database. I have 15 years’ experience to handle Databases as well as I have completed many projects and my profile feedback section is showing my abilities and client recommendations. So, you can Trust me for a Best output with complete satisfaction. Your work will be delivered on time and after checking when you completely satisfied then you can release money. You can see a great level of communication level and customer support. Looking forward for great business deal and good start for future relations. "
€76 EUR 1 päivässä
4,9 (510 arvostelua)
8,1
8,1
Käyttäjän avatar
Hi there, My name is Andres, I'm a Industrial Engineer VBA and MS Excel expert and leader from Trascender Global Team. My team and I are highly skilled on VBA code creation and modification with 4 years of experience on this matter. If you agree we can talk deeply about the details and the requirements needed for this report, so we can start working on it right away.
€300 EUR 7 päivässä
4,9 (165 arvostelua)
7,6
7,6
Käyttäjän avatar
Hi, Would you like to see a quick demo of your project on creating a simple directory for contacts using VBA completed before you award the project? You can consider it professionally done in less than 24 hrs. Rather than just show you past similar projects, I want to exceed your expectation by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks.
€130 EUR 7 päivässä
4,9 (68 arvostelua)
7,0
7,0
Käyttäjän avatar
Hello dear sir! l can do your project in shortest possible time. Look in my page and read reviews about my work.
€77 EUR 3 päivässä
4,9 (246 arvostelua)
7,1
7,1
Käyttäjän avatar
Hi, There I hope all's well with you. I see you'r looking for a developer proficient in Ms /Excel/Access /VBA. I learned your task. I can code it in both Ms /Excel/Access, but the best way here will be Ms Access. So via ms Access and €750 will be the proper price for it-believe me! I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects I've developed for Ms Access/VB/SQL/Excel projects. Please visit :https://www.freelancer.com/u/zu02?w=f Thank you for your consideration. Zura p.s. it's very unreal to make it for example for €100 in 2 days- a miracle...
€750 EUR 15 päivässä
4,7 (68 arvostelua)
6,5
6,5
Käyttäjän avatar
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 let me know so that we can discuss the timelines, budget and scope accordingly. Thanks Regards Jawad
€100 EUR 7 päivässä
5,0 (87 arvostelua)
5,8
5,8
Käyttäjän avatar
Hi Good Day! A serious freelancer here. I've done a lot of report template using Ms Excel as a Project Management Officer. I can help you with this project. Please consider my bid. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
€60 EUR 3 päivässä
4,7 (77 arvostelua)
5,6
5,6
Käyttäjän avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
€122 EUR 3 päivässä
4,6 (45 arvostelua)
5,6
5,6
Käyttäjän avatar
Hi. I've read carefully your job description I'm have a lot of experiences in JAVA, C++, VB, DATABASE ,SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will try my best level for your project to run successfully. Looking forward to hearing from you. Thanks.
€80 EUR 7 päivässä
4,8 (12 arvostelua)
4,3
4,3
Käyttäjän avatar
I have 20 years in Database Developing, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, and MS SQL server
€69 EUR 7 päivässä
5,0 (2 arvostelua)
1,5
1,5
Käyttäjän avatar
Hi, As per reading your description and your requirements, I am offering you that I can provide excel management in accordance with all the requirements which you need. The creation and management part comes with all the calculation and writing techniques. So, if you would like to work with us or want to know how we will provide you with the work, let’s have a quick chat over this. Message us in the box. Meanwhile, you can check our work portfolios below. You can contact us for no. of financial services as listed below: • Accounting • Financial Management • Contracts Preparation We have all the expertise and practical knowledge over the sector of finance, accounting, contracts creation (development & designing), management solutions, accounting solutions and much more delivering only gratifying results. And also if you would like to discuss over this, you can message us in the inbox and have a quick chat.
€80 EUR 7 päivässä
5,0 (1 arvostelu)
0,0
0,0
Käyttäjän avatar
Many years of experience in MS Excel VBA and integration with MS Access. Earlier certified as MCP in MS Excel. Done multiple projects with Excel as both UI and DB. From your project description, this should be familiar territory for me.
€76 EUR 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I will be able to deliver the project in 10 working days subject to clear understanding between you and me. You can try me although I am a new freelancer because I need to score up. I assure you of a 100% satisfaction as far as the right delivery is concerned. Looking forward to your kind acknowledgement. Thanks.
€76 EUR 10 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I am an expert (total of 7 years of experience) in integrated Excel-Access applications. Your project is perfect for my domain of expertise; you need a front-end UI in Excel and a back-end DB in Access. I have done over 50 projects that involved developing such an integrated model. In addition to that, I have developed many crisp formatted reports in PDF and word document. I also have expertise in integrating Excel with Outlook for sending emails with attached files and reminders.
€90 EUR 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Thank you for the opportunity to apply for this project. I have experience coding vba for the past 10 years and implement plenty of projects (excel & access). I believe that given the opportunity, I can completely provide deliverables meeting your requirements best regards kobi
€100 EUR 2 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hi,   I can handle this project. I am Microsoft technology specialist and have 10 years of strong hands on experience in desktop,  web and mobile application development.   I can work for you as time and cost model.   please ping me on skyp - segmentsonline Core skills - ASP.NET webforms, MVC,  WPF MVVM,  XAMARIN,  C#,VB. NET, JQUERY,SignalR, ANGULAR4, BOOTSTRAP, SQL SERVER,MONGODB, NOSQL. Outlook add-in,  SSRS reports,  excel/pdf reports...etc Experienced in LEGO robotes, mindwave,  reply interact keypad integration Recently I have successfully completed multiple WPF applications for german and uk customers through another portal.. Two are quite complex projects with hardware integration.  Thanks,  kris.
€233 EUR 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I am a VBA expert I am a VBA expert I am a VBA expert I am a VBA expert I am a VBA expert I am a VBA expert I am a VBA expertI am a VBA expertI am a VBA expert
€50 EUR 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Quality assured and to be delivered in time. Relevant Skills and Experience Recently I have finished a project 'Order & Delivery Management' for our household utilities manufacturing unit.
€116 EUR 10 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan GERMANY lippu
Freiburg, Germany
4,9
70
Maksutapa vahvistettu
Liittynyt lokak. 25, 2014

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.