Sedang Disiapkan

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: 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

Tentang Majikan:
( 0 ulasan ) Alexandria, Egypt

ID Projek: #4096781

Dianugerahkan kepada:

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 dalam 0 hari
(0 Ulasan)
0.0

25 pekerja bebas membida secara purata $122 untuk pekerjaan ini

fastwork

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

$30 USD dalam 0 hari
(22 Ulasan)
5.5
binaryromel

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

$150 USD dalam 2 hari
(45 Ulasan)
5.2
finecodervw

Please check PMB for more details. Thanks

$250 USD dalam 5 hari
(26 Ulasan)
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 dalam 3 hari
(6 Ulasan)
4.3
SaSTechnologies

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

$200 USD dalam 3 hari
(13 Ulasan)
4.2
nayabsiddiqi

can provide you a utility to import data to access db

$200 USD dalam 3 hari
(7 Ulasan)
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 dalam 2 hari
(19 Ulasan)
3.9
cosconeaionut

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

$50 USD dalam 2 hari
(6 Ulasan)
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 dalam 5 hari
(6 Ulasan)
3.0
vickkey7

I am ready for this project. thanks

$70 USD dalam 2 hari
(7 Ulasan)
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 dalam 3 hari
(1 Ulasan)
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 dalam 2 hari
(1 Ulasan)
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 Lagi

$120 USD dalam 5 hari
(1 Ulasan)
1.0
nas7540

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

$175 USD dalam 3 hari
(0 Ulasan)
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 dalam 16 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
raharjaketut

ready to start sir

$30 USD dalam 7 hari
(0 Ulasan)
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 dalam 5 hari
(0 Ulasan)
0.0
mdesigner123

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

$120 USD dalam 3 hari
(0 Ulasan)
0.0