Customer Service Access Database
€30-250 EUR
Оплачується при отриманні
We need a database for our business as freelancers, recording our projects, our incomes, calculating our taxes, profits and outgoings. For now, we use excel files as databases, but we would like something more dynamic, professional and with the option of having a better view of our business. I've already created something in MS Access but I'm not experienced enough to make it work.
Note: The basic database tables cells we need can be found in [login to view URL]
All the calculations we need can be found in [login to view URL]
What we need more detailed for our database:
-Ability to importing Data from 3 Excel files: Project_Details/Income_Details/List, Outgoing_Details/List, Customer_Details/List (The first Tables can be found in [login to view URL]
-Ability to Import Projects, Outgoings, Customers through Database
-Not too complicated database so we can add queries or something else after
-Auto-calculation of monthly, yearly Income, outcome, balance, Taxes
-Connection of One-customer->many-projects and one-project->many(not more that 5)customers
-Ability to Import Projects, Outgoings, Customers by more that one emploees (3 for now)
-Some Performance Graphs would be nice, otherwise I will import them by myself
-Ability to Connect every Project to a Folder in our PC or Cloud (Just the ability to save the folder path is fine)
-Ability to check if the project has been paid off or not by the customer
More info:
-We have about 1000 projects per year
-We have already 980 projects in our excel database
-I'm at your disposal for any explanation
We will prefer someone that can write the database in Greek, if not, English is ok, I will translate it.
ID Проекту: #18550539
Про проект
Доручено:
Hi, Review my profile 5 Years of experience as BI/ETL Developer and Oracle Business Intelligence Certified professional. Working in Teradata Adept in preparing data for analysis, Creating dashboards depl Більше
15 фрілансерів(-и) готові виконати цю роботу у середньому за €177
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. Більше
Hi Friend! I am Branislav from Serbia. Please check my profile first! Here is my offer for a fully customized database built by all the rules. This is not a simple task - I expect at least one week of work on thi Більше
I am a professional Data Analyst, Financial Analyst and Excel expert holding years of experience in utilizing advance level tools of Excel, Access, Power BI and Tableau to perform financial analysis, project tracking, Більше
Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel Більше
Hi. From your project declaration, I strongly believe that its the kind of job that I have been experienced well. I have been experienced in programming including Ms Access since 2000. During 2006-2013, I had been work Більше
Dear Client, I can develop the projects and customer details database on access. It will be done in English using MS Access 2016. I can tailor the database to your requirements and provide changes until you are satis Більше
