Convert Excel to a Database with Reports
$250-750 USD
Betalt ved levering
I currently have 20 excel worksheets that record 5 data points on 18 different items for the last 10 years. From there I have 125 different columns of information per day. Some are calculations and some are simply true and false. Then I use pivot tables to create reports.
It has become too burdensome doing this with spreadsheets. I would like to convert the whole thing to a database with heavy emphasis on queries and reports. that is the key. I must be able to get reports easily and in combinations that are preset. Another key part will be being able to automatically update the database.
You must be strong in reports and setting up the queries I want in the way I need them, just like I do with my excel worksheets and pivot tables. I currently have Microsoft Access, but I am not opposed to using SQL light if need be.
There are so many calculations per record or row. Some reference a date. Some reference the previous record or row. Some reference future dates or rows. all of the math is simple math, addition, subtraction, dividing and such.
Speaking English will be a plus since its the only language I know.
Projekt ID: #17993502
Om projektet
56 freelancere byder i gennemsnit $473 timen for dette job
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Access because this is my favorite field and MS Access projects are among the tasks I work wi Flere
HI, I am good at SQL database. Please share the requirements of excel files. I will see the possibilities of automation and getting reports from excel files. It helps me in getting the scope of work. Looking forw Flere
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 Flere
We have successfully finished over 520 projects in last 18 years. ID : 17993502 Greetings, We are interested to work on this project, please find my comments inline with yours, 1)Convert Excel to a Database wit Flere
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
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 possibl Flere
Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.
Hi There, As an expert in advanced excel features I am happy to help you on this task. I just bred your project description, and happy to say that we can do this task perfectly using pivots and formulas without any v Flere
Hello, I am a programmer and I have years of experience in that kind of projects and I would like to help you. Please contact me via chat to discuss details. Greetings, Natalie
Dear Client, I can complete this project in short time with quality and your budget. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I would love to w Flere
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 Flere
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start
Hi there, Microsoft Access can handle all your tasks very easily. SQL as backend and MS Access as frontend will be a right combination if you have a vast dataset otherwise MS Access can handle a mid-level. However, Flere
Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.