Find Jobs
Hire Freelancers

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

€30-250 EUR

In Progress
Posted over 11 years ago

€30-250 EUR

Paid on delivery
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.
Project ID: 4213560

About the project

20 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average €153 EUR for this job
User Avatar
I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio
€250 EUR in 15 days
5.0 (615 reviews)
7.1
7.1
User Avatar
Hi, Please check the private message. Thanks djain01
€200 EUR in 5 days
5.0 (56 reviews)
5.5
5.5
User Avatar
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 in 5 days
5.0 (33 reviews)
5.2
5.2
User Avatar
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 in 5 days
4.9 (23 reviews)
5.5
5.5
User Avatar
Looking forward to working with you ...
€99 EUR in 3 days
5.0 (7 reviews)
4.9
4.9
User Avatar
Hi, i am interested to work on this project. Details are in pm. Regards, Nebojsa
€150 EUR in 5 days
5.0 (17 reviews)
5.1
5.1
User Avatar
Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.
€190 EUR in 5 days
4.9 (14 reviews)
4.5
4.5
User Avatar
Hi, MS Access expert having 8+ yrs of experience. Interested in your project. Please see your PM for more details.
€100 EUR in 4 days
5.0 (9 reviews)
3.9
3.9
User Avatar
Experienced MS Access and VBA developer. Ready to complete this project to your satisfaction.
€100 EUR in 5 days
4.9 (10 reviews)
3.9
3.9
User Avatar
Hi! I can do this for you. Please see PMB for a sample of my work. Thanks! David
€125 EUR in 5 days
4.4 (6 reviews)
3.9
3.9
User Avatar
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 in 10 days
4.8 (5 reviews)
3.1
3.1
User Avatar
I am ready to start the job
€150 EUR in 15 days
5.0 (4 reviews)
2.5
2.5
User Avatar
I've gone thru the project details. I can do this in 4 days to your entire satisfaction. Regards, Arshad
€120 EUR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have experiences with access and vb over 18 year.
€250 EUR in 10 days
0.0 (0 reviews)
2.8
2.8
User Avatar
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 in 5 days
0.0 (1 review)
2.9
2.9

About the client

Flag of GERMANY
Durlangen, Germany
5.0
16
Payment method verified
Member since Nov 10, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.