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

This project was awarded to bubu77 for €100 EUR.

Get free quotes for a project like this
Project Budget
€30 - €250 EUR
Total Bids
Project Description

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:


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.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online