Closed

Build a microsoft access dashboard

Hi i need to create a simple data storing access DB where we will enter daily data which shall store in a table. All such stored data shall be retrieved in a prescribed template if date is entered.

we have been doing it in Excel so far. The first sheet will have data entry where we enter all the data. Next page is the format which gets the data from the first sheet and display in prescribed format which we print and submit to the head office.

But we have been creating one excel file every day hence to retreive any data we are unable to automate and have to manually do.

For example i want to see the consumption of fuel on a particular month, then i have to open 30 different files and manually caluclate all 30 days consumption to get monthly consumption.

hence now i want to go to microsoft access so that we can store, retrieve, run reports etc.

I am quoting as a simple project but payment would not be an issues to deserving candidate

Skills: Excel Macros, Excel VBA, Microsoft Access

See more: ms access dashboard tutorial, how to create a dashboard in access 2013, access dashboard examples, access 2010 dashboard examples, ms access dashboard template, dashboard builder for microsoft access, access 2013 switchboard, how to create a dashboard in access 2010, i need to write some simple databases in microsoft access or file maker pro, need create vendor database microsoft access, create simple invoice database microsoft access, create simple database order management microsoft access, creating excel file vb, creating excel file php, create simple data access layer

About the Employer:
( 4 reviews ) Chennai, India

Project ID: #15045785

31 freelancers are bidding on average ₹7685 for this job

zu02

Hi, I'll code that either directly in Ms Excel or via Ms Access GUI with Excel automation if need. Relevant Skills and Experience vba, Excel, sql, ado, Access Proposed Milestones ₹12500 INR - default

₹12500 INR in 3 days
(41 Reviews)
6.0
royalcalif

Let me review the existing spread sheet. it might give me good idea on your requirements. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to y More

₹1500 INR in 1 day
(37 Reviews)
5.4
alaeddindhahri

Hi, I'm a professional Ms Access and VBA developer. I have read your project description and I'll be glad to help you fulfill your needs. This is a simple project and I have done more complex ones. Relevant Skills and More

₹7777 INR in 3 days
(50 Reviews)
5.3
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex More

₹12500 INR in 3 days
(16 Reviews)
5.1
florinserban

I can provide an app that will track the data and provide the required reports. No direct database editing involved, the data will be safe from bad edits or deletion. Relevant Skills and Experience I've been building More

₹7000 INR in 3 days
(16 Reviews)
4.8
aubrey03

A proposal has not yet been provided

₹5500 INR in 3 days
(14 Reviews)
4.7
jonathanpradas

Good day. I would like to help you building this database. I believe that my bid is sufficient to finish this project on time and within our agreement. Relevant Skills and Experience I have been building databases usi More

₹3000 INR in 3 days
(27 Reviews)
4.4
crypthne

My main expertise is VBA programming using MS Access. I'm confident to finish this project on time and as required Relevant Skills and Experience MS Access and VBA Proposed Milestones ₹7777 INR - Default milestone

₹7777 INR in 10 days
(27 Reviews)
4.4
gumadevi89

Greetings. I am an access and VBA expert who can help to convert your existing excel data into access database for easy storage and retrieval into reports as required to be submitted to management. Relevant Skills and More

₹10000 INR in 15 days
(8 Reviews)
4.1
kimbennett0705

Build a simple access database which will allow for daily data entry and allow user to run a report showing all data for a given period of time Relevant Skills and Experience I have over 10 years experience working More

₹13888 INR in 3 days
(2 Reviews)
4.5
AhmedHassan1122

VBA experience with 2+ years. Relevant Skills and Experience VBA Proposed Milestones ₹7777 INR - Full price

₹7777 INR in 3 days
(12 Reviews)
4.0
dwthompsonvw

So glad to hear you want to use Access for your Excel sheets. Yes, I can create your dashboard. Relevant Skills and Experience Developing Access databases for over a decade now, pulling data from Oracle, IBM, and merg More

₹8888 INR in 4 days
(2 Reviews)
3.1
mpunn2007

In simple words you want a quick and smart way to print your bills or docs rather than doing this in excel daily in annoying n repetitive manner. And for this, you need a query and a form , which must allow you choos More

₹5500 INR in 5 days
(6 Reviews)
3.0
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel and access expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of More

₹8888 INR in 5 days
(4 Reviews)
2.7
jcrbahia

I have developed in access data, I can suggest changes and designs with the link to Php script for display in device, extensive experience in Access Habilidades y experiencia relevante more 15 years developer Access More

₹3933 INR in 10 days
(5 Reviews)
2.4
₹6111 INR in 3 days
(1 Review)
0.7
supergana

Hi, I worked with Infosys for 18 years and recently resigned to start on my own. I can study your situation and can arrive at the best solution. If access is your preference i can get it done too. Relevant Skills and More

₹11111 INR in 10 days
(0 Reviews)
0.0
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients Relevant Skills a More

₹6666 INR in 3 days
(0 Reviews)
0.0
₹7777 INR in 3 days
(0 Reviews)
0.0
₹7777 INR in 3 days
(0 Reviews)
0.0