I gang

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

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

Input Information - I have a daily report that has fixed columns of data. This rows in the report are truck nos., volume, weight , density.... etc . The columns represent information about each truck . Some columns do not contain information I care about, and could be ignored

Output or Visualization - I need to be able to look at the data in two ways. First is to look at each truck , and track changes in the volume, density & weight also I've a real volume & an induced volume ( real volume is fixed while induced one is changing)

so what i need briefly a program so that i can import data from excel sheets automatically as i introduce them in the data base & trace the changes of each truck in weight, [url removed, login to view] transfers, induced & real volumes separately & density & also the total no of trucks weights, no. of transfers , induced & real volumes separately

as i want to have a stored data of real truck volumes in the data base ( as it is a fixed one) so it has to be imported once a time & automatically imported in the report each time & be able to add new trucks & new real volumes as data is updated in front of me

also i need the project to be password protected & the output report for each truck along the week or month or the total daily count of trucks , volumes & no. of transfers to have either the option to be a PDF or an excel; sheet

this is a sample of daily imported excel sheets

. 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.

Færdigheder: Dataindførsel, Databehandling, Excel

Se mere: microsoft access monthly weight, ways to represent data, real truck, password protected excel, microsoft project import, i need an access database, find a event time program, data for data visualization, daily access, monthly report excel using access data, what is microsoft project, Excel data visualization, data visualization excel, visualization processing, report from excel, excel password, excel data input, data-visualization, data base excel, access reports data entry, multiple excel, excel create input output, excel base data, project 2013 access, excel monthly daily

Om arbejdsgiveren:
( 0 bedømmelser ) Alexandria, Egypt

Projekt-ID: #4096781

Tildelt til:

nphelps88

I have created numerous Access Databases for very similar functions. I could complete this today, please respond back and I can get to work! Please see PM for more info on me.

$30 USD in 0 dage
(0 bedømmelser)
0.0

25 freelancere byder i gennemsnit $122 for dette job

fastwork

Hi, Able to do it immediately. Please refer PM for further details.. Thanks..

$30 USD in 0 dage
(22 bedømmelser)
5.5
binaryromel

===== Excel & Access expert here! Please check PM. =====

$150 USD in 2 dage
(45 bedømmelser)
5.2
finecodervw

Please check PMB for more details. Thanks

$250 USD in 5 dage
(26 bedømmelser)
4.7
NiceDeveloper

Hi, I'll give you a windows desktop app which will upload trucks data in its database and you can see reports from them. check your inbox. Thanks

$180 USD in 3 dage
(6 bedømmelser)
4.3
SaSTechnologies

Please check the attachment, I have done similar kind of work already. Thanks Sumit SaS Technologies

$200 USD in 3 dage
(13 bedømmelser)
4.2
nayabsiddiqi

can provide you a utility to import data to access db

$200 USD in 3 dage
(7 bedømmelser)
4.1
uumairkhalid

Hi.. Expert database developer here. Assure you accurate database according to your requirements. My bid is for exact database. Ready to start. Have a look at PM. Regards

$100 USD in 2 dage
(19 bedømmelser)
3.9
cosconeaionut

If you need me , I can help you on time.

$50 USD in 2 dage
(6 bedømmelser)
3.6
NourElDeen

Dear Ma'am, I Would like to help you, with that project,i'm expert with access. Best Regards, NourElDeen

$100 USD in 5 dage
(6 bedømmelser)
3.0
vickkey7

I am ready for this project. thanks

$70 USD in 2 dage
(7 bedømmelser)
3.1
lokeshk9936

I am a db expert and would be happy to do this for you. Have done various such automation tasks in the past.

$225 USD in 3 dage
(1 bedømmelse)
2.2
webexpertkunal

Hi, I am sincerely read your requirements and ready to endow with the solution as per your requirement. please check your pmb. Thanks.

$70 USD in 2 dage
(1 bedømmelse)
1.5
mukulsinha25

Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output. I have over 7 years of experience in Excel,Access VBA. I have developed and Mere

$120 USD in 5 dage
(1 bedømmelse)
1.0
nas7540

expert in Excel and Access DB, pls. let me know

$175 USD in 3 dage
(0 bedømmelser)
0.0
freedevs

Hey There! I am willing to do this project with you. Please pm me to understand further about my skills and expertise.

$250 USD in 16 dage
(0 bedømmelser)
0.0
arlanv

I can help. I have good excel knowledge about excel. I live in the midwest and have knowledge about trucking. Would love to help you short term or long term. Give me a try. Ask if you have any questions.

$150 USD in 3 dage
(0 bedømmelser)
0.0
ikram159

Dear sir/madam , I have complete MBA , now I'm servicing industrial engineering & planning section largest group of Bangladesh, you trust me will better support .

$30 USD på 1 dag
(0 bedømmelser)
0.0
raharjaketut

ready to start sir

$30 USD in 7 dage
(0 bedømmelser)
0.0
NithuSarin

Madam, I have got 2 years of excel Access experience with a bank..I will be able to complete your project successfully

$100 USD in 5 dage
(0 bedømmelser)
0.0
mdesigner123

Interesting starting this job. Previous work experience available in similar type work. 100% guarantee accuracy and dead line cover.

$120 USD in 3 dage
(0 bedømmelser)
0.0