In Progress

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

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 ([url removed, login to view]) 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 ([url removed, login to view]) 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.

Skills: Microsoft Access, Visual Basic

See more: access application, microsoft project import, microsoft project price, a detailed description of the product, a b, penner, import csv, csv data, application microsoft access, database import filter, csv product import, report chart, access chart, project 2013 access, sales report access, stock report, result application, table csv, code import csv access, access sales week, csv table, product margin, sales database microsoft access, stock project access, import csv code access

About the Employer:
( 15 reviews ) Durlangen, Germany

Project ID: #4213560

21 freelancers are bidding on average €157 for this job

fastudiovw

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
(621 Reviews)
7.1
Prashantskin

[url removed, login to view] I have gone through your project requirements and the csv files. I will complete the project within 3 days only.. Please see the PMB for details Thanks Prashant

€150 EUR in 3 days
(471 Reviews)
6.9
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

€250 EUR in 5 days
(28 Reviews)
5.6
djain01

Hi, Please check the private message. Thanks djain01

€200 EUR in 5 days
(55 Reviews)
5.5
amcsummers

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 More

€175 EUR in 5 days
(43 Reviews)
5.3
MarlinSoftware

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
(14 Reviews)
5.0
expertcoder1vw

Hi, I'm an expert Access programmer and can develop the CSV import functionality for you. Can complete in 2 days. High quality work - satisfaction guaranteed! Thanks for considering my bid. Bests, Larry

€220 EUR in 2 days
(13 Reviews)
4.5
nlukovic

Hi, i am interested to work on this project. Details are in pm. Regards, Nebojsa

€150 EUR in 5 days
(8 Reviews)
4.3
adim

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

€190 EUR in 5 days
(11 Reviews)
4.2
www1980

Experienced MS Access and VBA developer. Ready to complete this project to your satisfaction.

€100 EUR in 5 days
(10 Reviews)
3.9
davidt999

Hi! I can do this for you. Please see PMB for a sample of my work. Thanks! David

€125 EUR in 5 days
(5 Reviews)
3.9
johnred332

Dear Sir, I am ready to work with you, I will promise that you won't disappoint my work, 100% satisfaction, please see PM

€100 EUR in 3 days
(6 Reviews)
4.2
salih0vicx

Looking forward to working with you ...

€99 EUR in 3 days
(1 Review)
3.5
AccessAuthority

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 h More

€99 EUR in 10 days
(5 Reviews)
3.1
theenggprojects

I am ready to start the job

€150 EUR in 15 days
(4 Reviews)
2.6
bubu77

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
(1 Review)
2.0
doinab

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
(1 Review)
0.9
Samtiger2

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 Reviews)
0.0
arshamid

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 Reviews)
0.0
visionsoftwareco

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 Reviews)
0.0