I gang

Create Microsoft Access database using multiple Excel files (monthly reports) - repost

I need to create a database from a monthly excel file.

Input Information - I have a monthly report that has fixed columns of data. This rows in the report are accounts. The columns represent information about each account. Some columns do not contain information I care about, and could be ignored. There are approximately 5 years of data I would need to import when the DB is set up. The files are text files, but come into MSFT Excel easily (comma delimited).

Output or Visualization - I need to be able to look at the data in two ways. First is to look at each account, and track changes in the values. The values will have single event changes (i.e. they do not change month to month). Changes themselves are the events I want to be able to find. Also, I need to be able to look at a column (i.e. a specific data point) to search for changes over time to those fields. I do not own MSFT Access, but could purchase for this project.

This is a personal project, so I have a budget. The "added value" of a freelancer is knowing what I am trying to do with the data, and creating easy ways to search and visualize the data (changes in data really) that help me with my larger project.

Færdigheder: Dataindførsel, Databehandling, Excel

Se mere: creating database monthly reports, project using access excel, create multiple access files, excel create access database, create access database monthly, access database data month, monthly database excel, ways represent data, ways freelancer, want create database, set freelancer account, search microsoft freelancer, reports freelancer, point care data entry, microsoft project import, microsoft project freelancer, microsoft excel help 2013, want create freelancer account, want freelancer database, freelancer microsoft access, freelancer data visualization, find freelancer access database, event freelancer database, db freelancer, data visualization freelancer

Om arbejdsgiveren:
( 0 bedømmelser ) Indonesia

Projekt-ID: #4094634

Tildelt til:

zahidrose

Please check PMB

$15 USD / time
(0 bedømmelser)
0.0

3 freelancere byder i gennemsnit $15/time for dette job

cosconeaionut

Need more details

$15 USD / time
(6 bedømmelser)
3.6
eugene2006

Hi. Can you give me an example of monthly report?

$15 USD / time
(8 bedømmelser)
3.3