Find Jobs
Hire Freelancers

Convert Excel to a Database with Reports

$250-750 USD

Cerrado
Publicado hace más de 5 años

$250-750 USD

Pagado a la entrega
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.
ID del proyecto: 17993502

Información sobre el proyecto

56 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
56 freelancers están ofertando un promedio de $473 USD por este trabajo
Avatar del usuario
Dear Employer, Below are the advantage of working with me: - Expert of Excel. - Expert of SQL. - 10 years of experience of all these stuffs. - Know how to do tough or simple calculations. - Above all, well versed with Engish. Please do message me. I can do any job that you may need on SQL,Excel etc. You may like to check my reviews once!! :) Thanks and Regards, Ash
$555 USD en 10 días
5,0 (301 comentarios)
8,4
8,4
Avatar del usuario
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 with regularly and know exactly how to handle them. You mention that you need somebody to convert your Excel spreadsheet into an Access database with emphasis on queries and reports that will substitute your pivot tables. I'm going to spend less than a week to complete your project including required revisions for a total payment of $700. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$700 USD en 7 días
5,0 (625 comentarios)
8,6
8,6
Avatar del usuario
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 forward to discuss and work on the project. -Chandra
$500 USD en 10 días
5,0 (1248 comentarios)
8,5
8,5
Avatar del usuario
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 Entry, Data Processing, Excel, Microsoft Access, Visual Basic. Please ping me for more discussion.
$300 USD en 10 días
4,9 (589 comentarios)
8,5
8,5
Avatar del usuario
Hello, I've done several projects here involving Excel and MS-Access design, programming and conversion. Please browse my history for some examples: • https://www.freelancer.com/projects/Excel/Stats-Database-Project • https://www.freelancer.com/projects/Excel/Build-Historical-Stats-Database-Using • https://www.freelancer.com/projects/database-programming-Database-Development/DJP-database Especially the first two (2nd was an appendix to 1st) are flagship projects -- high quality and robustness, taking full advantage of features MS-Access offers (but seldom used) to ensure data integrity accross the data tables. A well-thought suite of queries provided a set of statistical and historical results and rankings, from granular to total levels. Are all your 20 worksheets the same data format? This may affect the amount of work needed to build the modules that will populate the database. I will propose splitting the work into 2 or 3 milestones, which I will be pleased to explain if we get to discuss further details of your project. Looking forward to your contact, Grunty.
$700 USD en 15 días
5,0 (66 comentarios)
7,9
7,9
Avatar del usuario
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 with Reports =>Ok 2)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. =>OK, can you provide sample Excel file. The format of the Excel is going to be fixed ? or going to change over period or regularly ? how do you want to input data to the database ? Do you want forms to input one record by one ? or bulk copy paste from Excel data ? or you want to directly import this excel files let me know? how many types of formats you want to import ? Is there any unique field in the excel so that we can understand duplicate values. Does your excel has images embedded ? or it has path of the image file ? I will prefer if its image path in excel and images in a folder on disk etc. If the images are embedded on the excel sheet, it becomes difficult to bring them in MS Access report.   3)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 ab
$555 USD en 10 días
5,0 (260 comentarios)
7,5
7,5
Avatar del usuario
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$750 USD en 10 días
4,9 (136 comentarios)
7,2
7,2
Avatar del usuario
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 Access, of course, familiar. Give me a chance to show what I can do!
$500 USD en 6 días
4,9 (265 comentarios)
7,2
7,2
Avatar del usuario
Hello sir/madam I have developed several Access databases based on Excel files and I am ready to work on your project. I have over 10 years of experience in various database systems like Access, MS SQL Server, Oracle, MySql, Sqlite. Please contact me to start discussion about the project. Best regards, Tolib
$600 USD en 10 días
5,0 (123 comentarios)
7,2
7,2
Avatar del usuario
Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.
$500 USD en 3 días
4,8 (109 comentarios)
6,8
6,8
Avatar del usuario
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 vb or macros. You may refer my profile to see my reliability, and if you are happy with all, lets discuss the project. I look forward to hearing from you. Best regards Priyal
$250 USD en 2 días
5,0 (200 comentarios)
6,7
6,7
Avatar del usuario
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
$500 USD en 2 días
5,0 (72 comentarios)
6,5
6,5
Avatar del usuario
Hi, there I hope all's well with you. I'll do your current project via Ms Access - very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$555 USD en 10 días
4,7 (83 comentarios)
6,5
6,5
Avatar del usuario
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 work on your project as I have worked on similar projects before. I have 3+ Years of Experience as a Professional Data Entry Specialist. Let’s have a quick chat to discuss this project. What I have done before:- Data Entry of Printed and Hand Written Material Medical Billing Data Entry Data Entry of E-books Insurance Claims Processing OCR Conversion Accounts Payables and Receivables Entry Accounting Book Keeping Records Please feel free to ask if you have any questions . I am looking forward to discuss with you regarding the project. Thanks & Regards, Rahul Anand
$250 USD en 2 días
5,0 (112 comentarios)
5,9
5,9
Avatar del usuario
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 develop convert those sheets into an Access app. I have done many projects of the same kind that you can see on my profile. However, I'd like more details about the project. Check my profile for previous clients' reviews and projects. PS: please note that you added Excel and Data Entry in your project skills, this will flood your project with unreliable bidders who come from Excel Data Entry background and not Access developers. I speak fluent English. We can have a call to explain everything if that's better. Looking forwards to hearing from you. Best, Alaeddin
$750 USD en 15 días
4,9 (72 comentarios)
5,9
5,9
Avatar del usuario
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
$555 USD en 10 días
4,7 (115 comentarios)
5,5
5,5
Avatar del usuario
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, could you please share me your excel files so that I can have a look and give you better solutions. Project specifications: 1) Professional and neat user forms to add/edit records 2) Import data from various source especially from excel 3) Attractive reports 4) Queries and functionalities like to search through the database and pull the matching result. This is what I can think of as your requirements. Please let me know if I missed anything. Thanks, Rayyan
$600 USD en 15 días
4,7 (24 comentarios)
5,1
5,1
Avatar del usuario
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.
$470 USD en 5 días
4,9 (11 comentarios)
4,9
4,9
Avatar del usuario
I can perfectly do your project work and able to complete full work in the shortest possible of time with 100% accuracy, perfection and according to your given instruction. I am ready to show you cost-free sample work for the project right now. I can say undoubtedly that I am the right person for whom you are looking for the project. Let’s discuss in PM so that we can start working on your project right away. I am waiting to have your quick positive reply. Thanks.
$277 USD en 0 día
4,8 (41 comentarios)
5,1
5,1
Avatar del usuario
I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access certified. I'm confidence I can help you to finish this project for you as requested.
$250 USD en 7 días
4,9 (36 comentarios)
4,7
4,7

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde ago 3, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.