Customer Service Access Database

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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.

Database Programming Excel Microsoft Access SQL Visual Basic

Project ID: #18550539

About the project

15 proposals Remote project Active 5 years ago

Awarded to:

hammadabbasi01

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 More

€88 EUR in 3 days
(1 Review)
1.0

15 freelancers are bidding on average €177 for this job

schoudhary1553

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. More

€200 EUR in 3 days
(442 Reviews)
8.3
branislavm

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 More

€222 EUR in 3 days
(318 Reviews)
7.9
paris2785

Καλημέρα. Με λένε Πάρη και είμαι προγραμαμτιστής σε όλα τα προϊόντα του MS Office και ιδιαίτερα σε Access και Excel. Όλα είναι ξεκάθαρα όσον αφορά τις απαιτήσεις της Βάσης Δεδομένων (ΒΔ). Η δημιουργία γραφικών δεν είν More

€160 EUR in 7 days
(424 Reviews)
8.2
periyannas

I can make the database with all your requirements in Excel itself. Can discuss further.

€222 EUR in 7 days
(172 Reviews)
6.9
daniyal3214

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, More

€100 EUR in 1 day
(123 Reviews)
6.7
alaeddindhahri

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 More

€250 EUR in 5 days
(73 Reviews)
5.9
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/Excel /VB. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms More

€250 EUR in 5 days
(65 Reviews)
6.4
Altantsetseg

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 More

€166 EUR in 5 days
(12 Reviews)
4.9
mikenru1

Hello! I am an experienced software developer with 10 years experience in software development. I have successfully implemented several systems which automates business processes for small companies. We can imple More

€155 EUR in 14 days
(11 Reviews)
3.8
nitinvarsani

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 More

€133 EUR in 5 days
(1 Review)
3.1