Find Jobs
Hire Freelancers

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

€30-250 EUR

W trakcie realizacji
Opublikowano około 11 lat temu

€30-250 EUR

Płatne przy odbiorze
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.
Identyfikator projektu: 4213560

Informację o projekcie

20 ofert
Zdalny projekt
Aktywny 11 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
20 freelancerzy składają oferty o średniej wysokości €153 EUR dla tej pracy
Awatar Użytkownika
I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio
€250 EUR w 15 dni
5,0 (615 opinii)
7,1
7,1
Awatar Użytkownika
Hi, Please check the private message. Thanks djain01
€200 EUR w 5 dni
5,0 (56 opinii)
5,5
5,5
Awatar Użytkownika
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 w 5 dni
5,0 (33 opinii)
5,2
5,2
Awatar Użytkownika
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 w 5 dni
4,9 (23 opinii)
5,5
5,5
Awatar Użytkownika
Looking forward to working with you ...
€99 EUR w 3 dni
5,0 (7 opinii)
4,9
4,9
Awatar Użytkownika
Hi, i am interested to work on this project. Details are in pm. Regards, Nebojsa
€150 EUR w 5 dni
5,0 (17 opinii)
5,1
5,1
Awatar Użytkownika
Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.
€190 EUR w 5 dni
4,9 (14 opinii)
4,5
4,5
Awatar Użytkownika
Hi, MS Access expert having 8+ yrs of experience. Interested in your project. Please see your PM for more details.
€100 EUR w 4 dni
5,0 (9 opinii)
3,9
3,9
Awatar Użytkownika
Experienced MS Access and VBA developer. Ready to complete this project to your satisfaction.
€100 EUR w 5 dni
4,9 (10 opinii)
3,9
3,9
Awatar Użytkownika
Hi! I can do this for you. Please see PMB for a sample of my work. Thanks! David
€125 EUR w 5 dni
4,4 (6 opinii)
3,9
3,9
Awatar Użytkownika
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 w 10 dni
4,8 (5 opinii)
3,1
3,1
Awatar Użytkownika
I am ready to start the job
€150 EUR w 15 dni
5,0 (4 opinii)
2,5
2,5
Awatar Użytkownika
I've gone thru the project details. I can do this in 4 days to your entire satisfaction. Regards, Arshad
€120 EUR w 4 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 4 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Have experiences with access and vb over 18 year.
€250 EUR w 10 dni
0,0 (0 opinii)
2,8
2,8
Awatar Użytkownika
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 w 5 dni
0,0 (1 opinia)
2,9
2,9

O kliencie

Flaga GERMANY
Durlangen, Germany
5,0
16
Zweryfikowana metoda płatności
Członek od lis 10, 2003

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.