Fermé

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.

Compétences : Saisie de Données, Traitement de Données, Excel, Microsoft Access, PHP

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #16983222

27 freelance font une offre moyenne de $199 pour ce travail

rajeshsonisl

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(942 Commentaires)
8.5
schoudhary1553

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(259 Commentaires)
7.6
fabest

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(97 Commentaires)
7.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(56 Commentaires)
6.7
advanceweb7

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(70 Commentaires)
6.6
paris2785

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(169 Commentaires)
6.8
aanvikm

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(51 Commentaires)
6.5
quinconx

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(46 Commentaires)
6.2
workerbee1974

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(33 Commentaires)
6.2
pratikshapkl

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(88 Commentaires)
6.2
zu02

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(51 Commentaires)
6.1
royalcalif

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(88 Commentaires)
5.9
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(28 Commentaires)
5.9
alaeddindhahri

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(62 Commentaires)
5.6
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(11 Commentaires)
5.3
SShtv

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(54 Commentaires)
5.5
NourElDeen

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(50 Commentaires)
5.2
XD12jalandhar

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(23 Commentaires)
4.7
khudammunir

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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(18 Commentaires)
4.3
texdevelopers

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(10 Commentaires)
4.1