Build a Database that will track 16 employees

I am looking to build a database that will track a project. Here is the rundown of what I would like. Please forgive me, while I can paint a picture with my words, I might refer to something incorrectly or I might even be asking for more than Access can do. Here we go:

I have a team of 16 people that I need to track a few things and see a “dashboard”.

The Dashboard will show –

• Their Name

• Their Start Date

• Their Schedule

• Their Phone Number

• Their MTD Quality Score

• Their MTD Hold time

• Any Corrective actions

All of these would be pulled from an excel sheet that I currently track, but I would need to be able to add scores and pdf’s right from the Dashboard. So, it would look like this (not visually, just a verbal picture, sorry.):

John Doe

His address, phone number and start date

He works Monday – Friday from 9:00am – 5:00pm

His MTD QA score is 92.5

His AHT (average hold time) is 1:45

He is currently on 3 corrective actions

If I click on his Qa score (92.5), it would show me the actual PDF’s for each of his scores for the month. I then have the option to add a new score. I would be able to add a PDF of the score, but plug in the date of the new score, the score itself and the person who scored him. That in turn would update the dashboard.

If I click on the AHT (1:45) it would show all of the hold times by each day. It would also allow me to add a new AHT which would update the dashboard.

For corrective actions, when I click on corrective actions it will pull up any and all corrective actions per each category (lets say the categories are “corrective action”, “coaching”,” 30 day” and “Conversation Letter”.) if I need to add a new one, it would allow me to upload a new PDF and have a category for what type of corrective action it is. It would then update the dashboard.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Microsoft Access, PHP

Veja mais: steps to create database in ms access, how to create a database in access 2010 step by step, how to create a database in access 2016 step by step, employee database sample, how to build a database from scratch, how to create a database in access 2016, how to create a database in access 2007, how to create a database in access 2013, build database track customers bikes rentals, access database track payments due, php excel type number, build database website, build database csv, database track customer payments, build database, build database scraper, build flash track game, build database access companies, build race track flash game, sharepoint build database

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #16983222

26 freelancers estão ofertando em média $201 para esse trabalho


Hi there, Can I see the Excel and PDF examples? I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1100 projects over 11 years. Thanks. I look forward to hearing from yo Mais

$244 USD in 4 dias
(988 Comentários)

Hello, I can help with you in your project Build a Database that will track 16 employees . I have more than 5 years of experience in Data Entry, Data Processing, Excel, Microsoft Access, PHP. We have worked on sever Mais

$200 USD in 3 dias
(331 Comentários)

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Mais

$166 USD in 3 dias
(99 Comentários)
$200 USD in 7 dias
(95 Comentários)

Hi, there. My name's Paris Pallas and I'm an Access database expert. Having completed almost 230 projects during the last 5 years successfully I feel really confident in assisting with yours as well. Feel free to vi Mais

$200 USD in 7 dias
(209 Comentários)

Hello Sir, I'm interested in your project. Please send me a message so that we can discuss more. so we can discus more about your project positively. Thanks & Regards, gaurav sharma

$250 USD in 7 dias
(77 Comentários)

Hello Sir, I am an expert with windows application development and I can help you here with this project. Thanks Aanvik

$155 USD in 3 dias
(54 Comentários)

My passion is building Custom Access Databases. I have built well over 300 custom databases in the past 19 years. I have taken all classes from beginner to expert 97 to 2013.  I can send working samples on request. So Mais

$277 USD in 7 dias
(40 Comentários)

Hey there, Hi, I'm a Web developer with a combined experience of more than a decade in Web Designing, Web Application Development & E-commerce Development. I read and understood your project. I’ll keep this short Mais

$700 USD in 15 dias
(52 Comentários)

PM me to discuss little more about the project for appropriate duration and cost as well. 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 Mais

$30 USD em 1 dia
(107 Comentários)

Dear Hiring Manager, I am a PHP developer My FIrst goal will always be to meet your needs and deadline. When working on a new project, I like to speak with the client, so that I can have a clear understanding of his Mais

$250 USD in 3 dias
(114 Comentários)

Hi, there I think better if we solve this your current project via Ms Access(sure- with Excel, PDF etc automation) I'll build very friendly interface . I can more detail. Thanks for your time. Regards, Zura

$250 USD in 5 dias
(52 Comentários)
$166 USD in 3 dias
(30 Comentários)

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 appreciate your effort i Mais

$250 USD in 7 dias
(70 Comentários)

I have a large and successful practical experience in the field of data visualization and creation of dashboards. I also have practical experience in the development of databases and custom forms. Here are screenshots Mais

$150 USD in 3 dias
(68 Comentários)
$200 USD in 4 dias
(13 Comentários)

A proposal has not yet been provided

$222 USD in 5 dias
(56 Comentários)

Hello There! I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have done 100+ projects with full satisfaction of my clients in web design and developmen Mais

$188 USD in 3 dias
(57 Comentários)

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Mais

$150 USD in 3 dias
(27 Comentários)

Hi, would you like this as a php page ? Also, do you need the database to be in access ? Most php uses mysql which can run on any platform, and its free. There are easy ways to import data from access

$155 USD in 3 dias
(17 Comentários)