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, microsoft access open locked, create simple access database using, microsoft access build search functionality form, create booking calendar microsoft access website, create simple access, microsoft access open report automation, microsoft access simple design project, need programmer create simple shopping cart, microsoft access build schedule, creating excel file using visual basic, build processing calendar microsoft access, can create simple data input macro excel 2007

About the Employer:
( 5 reviews ) Chennai, India

Project ID: #15045785

30 freelancers are bidding on average ₹7479 for this job

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
(61 Reviews)
5.7
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
(47 Reviews)
6.1
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
(62 Reviews)
5.6
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
(44 Reviews)
5.1
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
(20 Reviews)
5.2
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
(18 Reviews)
4.9
AhmedHassan1122

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

₹7777 INR in 3 days
(16 Reviews)
4.5
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
(28 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.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
(8 Reviews)
3.6
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
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
ShyamalTandel

A proposal has not yet been provided

₹2750 INR in 4 days
(1 Review)
0.0
nelson1812002

I have over 28 years' as a developer and CIO. I have created complex, menu-driven MS Access apps for large clients like AT&T, Cox Communications, shipping companies, and others. Relevant Skills and Experience I have More

₹11111 INR in 5 days
(0 Reviews)
0.0
settstyle007

A proposal has not yet been provided

₹11000 INR in 5 days
(0 Reviews)
0.0
joicejohn75

This project can be done using Ms Access as mentioned here. It does not require many forms Relevant Skills and Experience I have done one project for school library and other projects for small companies using Ms acce More

₹7555 INR in 4 days
(0 Reviews)
0.0
edwardcdsilva

I have been developing with MS Access for almost 20 years, from pure MS Access systems to MS Access & MS SQL Server systems. Most of the development custom built from scratch each time. Relevant Skills and Experience More

₹9444 INR in 3 days
(0 Reviews)
0.0