Find Jobs
Hire Freelancers

Access Application that imports csv data and shows a report and a chart with 3Tables

€30-250 EUR

Em Andamento
Publicado há mais de 11 anos

€30-250 EUR

Pago na entrega
This is a quick project with importing csv files, and show the data in table(report) and a chart. The result shall be filtered by different values. What this Access programm shall do: Import weekly sales Data from a csv file by a button click, and ad the data to a table. There is a 2nd csv file ([login to view URL]) to filter the table and the chart to show the required data. This shall work as a deployed standallone version and with source code on my Access 2002 Version. Detailed description The Software shall Import data from the csvfiles: Renner-Penner(3-5).csv and new ones each time I want it. The number in the () stands for the week from the data and should be a value in the resulttable for the time(week). An Product is identified by the Item Id and for each Product the SoldItem Value and the ContributionMarginOne shall be added in a new field in the table with the Week for wich the data is as header: Like ItemID; SoldItemsweek4;SoldItemsweek5;SoldItemsweek6;marginweek4;marginweek5;marginweek6 And this shall be displayed in a table(Report) and a chart. So a chart for each item with SoldItems in dependency of the week, and one for each item with the margin in dependency of the week. The week is included in the imported file as value in (). Import a 2nd csv file ([login to view URL]) on Buttonclick with data from products in a table for basic informations about products. This will be updated once a month, the data is to filter the data shown in the results table. Filters for the data should be: 1)Only items where the solditems are in week b x% less then in week a, where you could fill a,b and x in textfields 2) Duration until stock is out of stock for this there is an import csv with ItemID;Stock . For the Duration you can divide Stock through Sold items from the last week imported 3) Some Values that are defined in the statik_item database: ItemMarking1, ItemMarking2,ItemFree11,ItemPurchasePrice,Price,CategoryLevel1,CategoryLevel2,CategoryLevel3 4) ContributionMarginOne divided through SoldItems from the table Renner-Penner().csv The files are cut of I give you full length files after I accepted you as worker.
ID do Projeto: 4213560

Sobre o projeto

20 propostas
Projeto remoto
Ativo há 11 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
20 freelancers estão ofertando em média €153 EUR for esse trabalho
Avatar do Usuário
I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio
€250 EUR em 15 dias
5,0 (615 avaliações)
7,1
7,1
Avatar do Usuário
Hi, Please check the private message. Thanks djain01
€200 EUR em 5 dias
5,0 (56 avaliações)
5,5
5,5
Avatar do Usuário
I know how daunting it is to try and describe what you are wanting. I have been doing my contracting work with VWorker/Freelancer for the past 3 years, I had completed 70 projects ranging from Excel VBA to SQL Server database constructions. Please feel free to ask any questions I am always willing to share my experience. I would suggest you make sure the code you select is well versed in Visual Basic Application, VBA, so they can take the field name to get the week. I would also suggest you have the code set up a dialog box to appear for you to go to the folder and select the file you would like to import. I have worked 15 years with MS Access and 11 years with MS SQL Server 7.0 and 2005. As you can see from my reviews I strive to make sure my customers are happy with my services. Feel free to ask me any questions or concerns you might have. Best of luck with your search. Michael
€175 EUR em 5 dias
5,0 (33 avaliações)
5,2
5,2
Avatar do Usuário
Hello, I have 12+ years experience developing MS Access applications and feel confident that I could do this project for you. Please view my portfolio for some examples of my work. Thank you.
€200 EUR em 5 dias
4,9 (23 avaliações)
5,5
5,5
Avatar do Usuário
Looking forward to working with you ...
€99 EUR em 3 dias
5,0 (7 avaliações)
4,9
4,9
Avatar do Usuário
Hi, i am interested to work on this project. Details are in pm. Regards, Nebojsa
€150 EUR em 5 dias
5,0 (17 avaliações)
5,1
5,1
Avatar do Usuário
Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.
€190 EUR em 5 dias
4,9 (14 avaliações)
4,5
4,5
Avatar do Usuário
Hi, MS Access expert having 8+ yrs of experience. Interested in your project. Please see your PM for more details.
€100 EUR em 4 dias
5,0 (9 avaliações)
3,9
3,9
Avatar do Usuário
Experienced MS Access and VBA developer. Ready to complete this project to your satisfaction.
€100 EUR em 5 dias
4,9 (10 avaliações)
3,9
3,9
Avatar do Usuário
Hi! I can do this for you. Please see PMB for a sample of my work. Thanks! David
€125 EUR em 5 dias
4,4 (6 avaliações)
3,9
3,9
Avatar do Usuário
Hi, We have expertise in MS Access and very competent is writing VBA code as well. We can import csv file and develop a DB, write any function you want. 8 years professional experience in Sydney. Rely on us without hesitation. Thanks. -AA
€99 EUR em 10 dias
4,8 (5 avaliações)
3,1
3,1
Avatar do Usuário
I am ready to start the job
€150 EUR em 15 dias
5,0 (4 avaliações)
2,5
2,5
Avatar do Usuário
I've gone thru the project details. I can do this in 4 days to your entire satisfaction. Regards, Arshad
€120 EUR em 4 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I understood the requirements, I know what I have to do and I am ready to start working for this project. It will be ready in time. Regards.
€98 EUR em 4 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Consider it done.... I will help you achieve results above and beyond you expectation with a quick turnaround...Hope to achieve next positive feedback from you!!! Please check you inbox for more info.
€179 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I this is a simple project to implement we have a ready solution for the same only minor changes are required to customize it as per your requirement.
€200 EUR em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi sir, Although i am a new freelancer, but i have lots of experience writing application that run on ms access. I have written software for shipyard company,retail pos, military. That run on ms access. Data importing is one of the basic that is required. No matter how complex your .csv is it won't be a problem. For report wise we use crystal report to generate. You can have chart report graph bar report and many other report. Development will be done on Visual studio. Language used is vb.net. Choose us and you will never regret.
€128 EUR em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Have experiences with access and vb over 18 year.
€250 EUR em 10 dias
0,0 (0 avaliações)
2,8
2,8
Avatar do Usuário
Thank you for the opportunity to bid on your project. We have read and fully understand your requirements. We propose to develop a system that is compatible with your Microsoft Access 2002 database. Our bid is qualified by previous business experience developing similar types of applications that import and process csv files into Microsoft Access Databases or export access data to csv. Our proposal is to develop this application using Visual Studio 2010 (Visual Basic). Our experience covers Accounting Software, Point of Sale, ERP, etc. We have attached sample product information for some of the products in our portfolio as proof of our experience. Please contact us if you require any further clarifications on any or all aspects of our bid.
€90 EUR em 5 dias
0,0 (1 avaliação)
2,9
2,9

Sobre o cliente

Bandeira do(a) GERMANY
Durlangen, Germany
5,0
16
Método de pagamento verificado
Membro desde nov. 10, 2003

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.