Build MS Access 2016 KPI dashboard

There are two parts


I have an excel KPI dashboard, and 6 excel files in which different people input their numbers. The graphs are then populated based on those numbers in the main excel dashboard called "Virtual Improvement Board 1.0".

I want to make this process user friendly and more eloquent, and I need the following:

For Entering values:

Simple data entry form where a person can input numbers for any date for their required KPIs e.g. 5 KPIs for Production Supervisor, 4 KPIs for process engineers, 4 KPIs for maintenance supervisors as mentioned in the excel spreadsheet that I am attaching.

Also a table for entering improvement actions as mentioned in that tab.

For seeing results/dashboard/report:

1) Visual, graphical one page summary all KPIs for any particular day of the month.

2) Summary of KPIs by position name and date with one click, drag and drop system

3) The graphs should turn red or green automatically as I have done in my excel spreadsheet.

4) Ability to add or remove KPIs, name of person etc, this dashboard should be editedable my an administrator

5) A page where I can add list of users and assign them password, so access to this dashboard can be limited.

6) Simple way to view the improvement actions entered above.

7) If they can be made accessible through mobile, that would be an added advantage but not required.

8) Any other ideas to make this dashboard awesome are welcome, and I am looking forward to your creativity.


I need a system which is part of this dashboard, and similar in functionality i.e. different users with usernames and passwords, can add information using 3 forms. These forms are basically problem investigation forms. Then different reports should be accessible easily with a couple of clicks where we can see:

1) Results of different problem investigations should be easily accessible, by person, by month, day, by process step, by other columns present in the example.

2) We should be able to rate different parts of this investigation form using 1 to 5 stars, just like we do online on facebook, etc, by page 1, 2 & 3 and overall.

PLEASE don't experiment with this if you are not an expert who has done this multiple times before, not not waste my time if you don't know what you're doing.

Skills: Microsoft Access

See more: dashboard builder for microsoft access free download, ms access dashboard template, ms access dashboard tutorial, microsoft access 2016 dashboard, access dashboard examples, access 2010 dashboard examples, ms access dashboard examples, dashboard builder for microsoft access, build database access companies, vbnet build data access layer, can build calendar access, build executable access database, kpi dashboard getafreelancer, build counter access vba, build reports access look powerpoint, build calendar access, build inventory access, accesse data ms access search vb, access ms access database manually, accounting projects ms access samples

About the Employer:
( 0 reviews ) Canada

Project ID: #17710075

6 freelancers are bidding on average $364 for this job


Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As More

$24 USD in 1 day
(81 Reviews)

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel More

$555 USD in 10 days
(69 Reviews)

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Access More

$888 USD in 15 days
(44 Reviews)
$600 USD in 7 days
(10 Reviews)

Hi I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. i am sure i can handle your request

$100 USD in 1 day
(4 Reviews)

Dear Next Employer We will give you the best result by using my skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar projects I've completed. Thanks

$15 USD in 2 days
(0 Reviews)