Find Jobs
Hire Freelancers

Simple Excel Database with GUI

€30-250 EUR

Dokončeno
Zveřejněno přibližně před 5 roky

€30-250 EUR

Zaplaceno při doručení
We are a small team of engineer freelancers that we need a simple database for our projects and client information. Currently we just use an Excel file for some of these but we need something more complete and easier to use. So we thought transform or recreate our Excel file adding some more data tables and having a GUI. Here are the details: • First of all, we need 3 data tables (or more of course): 1. Income/projects, 2. Outcome, 3. Client Info. It would be much better if we could have these tables in one Excel file in different sheets. • I need an import button and an import form. Something simple, like that: [login to view URL] . In the “new record/project” form we need to enter the Income sheet information and the Client information. I want also the ability to “connect” the new project with an existing client. So probably a drop-down list or a search cell so we can find him. • The Project ID and the client ID should be created automatically • In the “dashboard” we need the following information to be shown: o The “add new project” button o Current month income, and outcome and Balance (for all and for every employee/coworker) o A table with the project’s that have not been finished or I haven’t get paid yet (for all and for every employee/coworker) o A table with every month income, outcome and Balance (somewhere in the bottom) (for all and for every employee/coworker). o Any outcomes that we have not paid yet. o A search button for projects, or clients would be useful, if we can have one. The other thing is that we are 3 coworkers and one employee, so each of us has his database but it would be nice if I could get their data into my database, which is the easiest way to do it? Just have a VLOOK to one other file? I don’t want to limit you. If you understand what I need you can form it in the best way to be easy for you and me. I have uploaded the current data file (I have deleted the entries). Of course we can change it. I am a good MS Office Excel user but I luck of development and MySquel skills, so I can help somehow during the process. ***The database GUI has to be in Greek, if you build it in Greek, I can translate it by myself but I will need your help in case something doesn't work because of the language change.***
IČ projektu: 18649431

O projektu

22 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
χαιρετώ, It would be my pleasure the rebuild the Excel file for you with extra functionality. I will build an user form with a professional look with the required specifications. Please find below a short list of my skills: - Attention to details - Focus of quality - Patience - Advanced Excel \ VBA I do not request any payment before the project is completed and you are totally happy with the result After the project is completed I provide free support for one year for all bug fixes and small improvements. As we are on the same time zone GMT +2 it will be easy to communicate. Regarding the translation to Greek, as you said, I will request it from you. Please open a chat with me if you like to discuss more details. Kind regards, Sorin
€80 EUR v 3 dnech
5,0 (78 recenze)
5,8
5,8
22 freelanceři nabízejí v průměru €145 EUR za tuto práci
Avatar uživatele
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 changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Processing, Excel, Microsoft Access, Visual Basic. Please ping me for more discussion.
€250 EUR v 3 dnech
4,9 (608 recenze)
8,6
8,6
Avatar uživatele
Hi! Would you accept it if it is in MS Access instead in Excel? Excel is not the best tool to create a database, actually, it is a spreadsheet program. We can make it in two languages or I can give you instructions on how to translate everything into Greek. Regards from Serbia, Branislav Mihaljev
€155 EUR v 3 dnech
5,0 (299 recenze)
7,9
7,9
Avatar uživatele
I develop modules in Microsoft Excel by VBA which enable you to enter & manage transactions in a spreadsheet and to get immediate reports and info. The modules can upload external databases. During the process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently (English & Greek) . And more, the files are secured by username login and password. About Me: I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I develop financial modules including business valuation methodology & ratios. During my time serving as CFO, Controller, and Chief Accountant at different global parent companies, I gained knowledge and expertise in Financial Reports, accounting, consolidating, forecasting, and budgeting. I have experience in implementing information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP, ERP, etc.). Within a multi-currency environment and the global marketplace.
€250 EUR v 7 dnech
4,9 (96 recenze)
7,5
7,5
Avatar uživatele
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Microsoft Access, of course, familiar. Give me a chance to show what I can do! I suggest you Microsoft Access DB with linked Excel file
€100 EUR v 1 dni
4,9 (273 recenze)
7,2
7,2
Avatar uživatele
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. I can work with you, can propose ideas and we together can come up with a nice solution. I can show you examples too to help you out understand the ideas. Willing to take up your project. Thank you, Regards.
€155 EUR v 3 dnech
5,0 (194 recenze)
7,1
7,1
Avatar uživatele
I have excellent command on MS Excel and can build the necessary database client and project database. I have completed complex projects in Excel before . For instance - Built a POS and inventory management system - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
€150 EUR v 3 dnech
4,9 (95 recenze)
6,1
6,1
Avatar uživatele
Hi, dear. I'm very interested in your project very well. I've got an experience of VBA development with dialogs for MS Excel. Please ping me to discuss about this project.
€155 EUR v 3 dnech
5,0 (14 recenze)
5,3
5,3
Avatar uživatele
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
€133 EUR v 4 dnech
4,7 (55 recenze)
5,8
5,8
Avatar uživatele
Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some automation and scraping, scientific scripts. I have live example of csv automation script. Just let me know if you want start job. Regards. Lian
€150 EUR v 3 dnech
4,6 (12 recenze)
5,1
5,1
Avatar uživatele
Hi, I am interested. May I propose to create a user friendly MS Access database for the purpose. Tables will be created in the database wherein it will be linked with the MS Excel files (any changes in the excel data will be reflected in the database). I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.
€140 EUR v 4 dnech
4,9 (12 recenze)
4,8
4,8
Avatar uživatele
Hi, I am an Excel Expert with very good knowledge of VBA and formula. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
€100 EUR v 3 dnech
4,4 (48 recenze)
4,8
4,8
Avatar uživatele
Dear employer, Hi I have done my M.Sc. thesis using Python and MS Excel VBA. It was about developing a numerical model for simulating fluids flow through porous media. I developed the main code in Python and developed my analyzer tools in MS Excel VBA. I learned lots of tricks in programming with these two great languages. I also had 2 big contracts. One of them was a contract with an educational institute and was about developing an Excel program for managing their workshops participants. I developed this program with Exel VBA. The other contract was about developing a numerical model for the search and rescue operation in the sea which I developed with C++. I have about 5 years of work experience in computer programming using different languages. It would be a great chance for me if we could collaborate with each other as I am an engineer who loves computer programming. My rating is a little low because one of my employers was a dealer and he did not want me to improve my business on this website. But honestly, I have some rules for my working life and their most important are: Be ON TIME, RESPONSIBLE, and RESPECTFUL. You can read the reviews of other employers on my profile. I am always here to answer your questions even after the project completion. It would be highly appreciated if you could send me more details about your project so we can discuss more. Regards, Amir
€100 EUR v 3 dnech
4,7 (15 recenze)
4,4
4,4
Avatar uživatele
Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss
€155 EUR v 3 dnech
5,0 (5 recenze)
3,3
3,3
Avatar uživatele
yes buddy,,,an easy task,,me here to accomplish it,,,U will feel brotherhood,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
€60 EUR v 3 dnech
5,0 (6 recenze)
1,3
1,3
Avatar uživatele
Hi, I have more than 15 years of professional of senior business management expertise, with a core area on leading social media, setting and leading performance of Facebook, LinkedIn, Twitter, Instagram, in few cases managing eBay and Amazon accounts, besides managing the company's web site. I have led many projects for campaigns using segmentation and content techniques. I have implemented Google AdWords and analytics initiatives and managed to build high traffic with outstanding conversion rates. Besides my digital marketing expertise, I have designed and developed a few e-commerce sites, that I led the communication with clients and managed the logistics and all supply chain tasks to ensure that the products are delivered to clients’ at the most cost-efficient shipping process joint with the highest lead time for delivery. I am a guru at excel, smart sheets and all kinds of spreadsheets, including data migration, designing formulas and pivot tables. Expert in setting QuickBooks and sale force superuser In addition to my professional years of expertise, I would like to highlight a few certifications that I have hands-on expertise as below: -Certified Six Sigma Black Belt, CSSBB -Certified Manager of Quality and Organizational Excellence, CMQ -Certified Quality Auditor, CQA -Certified Project Manager Professional, PMP Certified Train of Trainers, ToT I look forward to hearing back from you with full trust that I will deliver the required work scope with high commitment.
€155 EUR v 3 dnech
5,0 (1 recenze)
1,0
1,0
Avatar uživatele
My Greetings, and cut down to the chase: 1. I will be lying you if I Bid for less than a 30 days long project; I have more than 25 years working in these kind of projects and the velocity of developments depends on greats questions and answers (feedback), and reviews or revisiting of the reports. All around the VBA coding, actually, this is a piece of cake. 2. I have a lot of material in my own portfolio which I could just copy and paste into your code, It could be a great advantage but I do prefer to do something new and customized to you. Keep in Touch :)
€222 EUR v 30 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi, I am a mechanical engineer , professional at Excel and data entry. I can do all you need perfectly with 100% accuracy and at less time . I can strongly do that project , trust that I will make you so satisfied. So, contact me for more details on chat. THANKS
€100 EUR v 3 dnech
0,0 (1 recenze)
0,0
0,0

O klientovi

Pochází z GREECE
Thessaloniki, Greece
5,0
1
Ověřená platební metoda
Členem od led 18, 2019

Ověření klienta

Další zakázky od tohoto klienta

Customer Service Access Database
€30-250 EUR
Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.