Convert Excel to Access database - Time Tracking and Reporting

Project Title: Time Management Access Database Conversion

Project Overview:

Convert existing capacity management spreadsheet to an Access database. Current spreadsheet capabilities should be migrated to queries or reports within the database. Currently there are 3 reports: Team, Entire Company, and Individual.

Project deliverables:

A Microsoft Access database will be created with the following reports:

• Capacity by Manager Report

o Provides month by month summary for selected time span (default 13-month rolling)

o Displays Total FTE (Full Time Employee)

o Displays Over/Under FTE

o Displays PM details for time period

• Capacity for Entire Organization Report

o Provides same information as Capacity by Manager Report – but for all employees in database.

• Capacity for Individual Report

o Provides same information as Capacity by Manager Report – but for individual employees in database.

Expanded Scope:

• Summary by Workstream Report

o Provides total hours per month for selected time span (default 13-month rolling) grouped by Category Owner of Project/Program/Task Names. This Category Ownership relationship is stored within the database in a separate table.

• Incomplete data identification Report

o Provides highlighted list of employees who are “past due” for entering data into database

• Out of compliance data identification Report

o Provides highlighted list of employees who are above/below expected total monthly hours guidelines (+- 10% of total hours per month)

• Trending charts for Capacity by Manager Report and Capacity for Individual Reports


o “Work days per month” will be stored in a table and utilized for the capacity reports.

o Database will provide option for selecting time span of given reports. Options should include: by year, by last 6 months, by last 3 months, by 13-month rolling, user specified time span

o Database will store employee / supervisor relationship (team) to allow for mapping PMs (project manager employees) to respective managers.

o Ability to add/edit Program/Projects/Task Names

o Ability to add/edit and categorize the Program/Projects/Task Names into Workstreams

o Supervisors will also have employee data / hours and will belong to their own team

Skills: Excel, Microsoft Access

See more: convert excel access database time tracking reporting, excel convert access, time tracking project management, task and project manager, supervisor title, reporting projects, project manager scope, project management company names, microsoft excel management, who provide the work excel, trending, time-tracking, time table, project management access, fte, excel to, Excel to Access, excel charts, database management project, convert access reports, convert a spreadsheet into a microsoft access database, c# with access database, c with access database, access manager, access database

About the Employer:
( 25 reviews ) Littleton, United States

Project ID: #4866149

35 freelancers are bidding on average $470 for this job


We can develop Microsoft Access database for TimeTracking based on your existing spreadsheet. What version of MS Access you want to use for the database ? We are amongst top 1% global outsourcing providers. We have More

$650 USD in 12 days
(235 Reviews)

[url removed, login to view] I have gone through your project requirements and the excel file.. I will covert excel to access.. Please see PMB for further details Thanks for your time Regards Prashant

$555 USD in 5 days
(458 Reviews)

Dear sir, Nice to meet u! Experts team here After reading the project description, I’m sure that i can do this job very fast accurate. I hope you will consider me for this job and i can start [url removed, login to view]

$263 USD in 5 days
(69 Reviews)

See the sample reporting application already developed by me. I can develop your application like this also. Keenly looking forward your response.

$400 USD in 3 days
(22 Reviews)

Highly experienced [20+ years] MsAccess and MsExcel business programming expert. [10+ years] MsAccess and MsExcel programming Authority / Expert / Guru / Mentor at [url removed, login to view] and STRONG P More

$800 USD in 31 days
(13 Reviews)

Hi, I can do it, I happily if work with you in this project. Best Regards winnet21

$666 USD in 25 days
(11 Reviews)

Hi Ticketstub. Being highly proficient in Excel and Access, I can get the database redesigned for you in Access just as you need but I may have a better solution for you. Regards

$666 USD in 7 days
(8 Reviews)

Dear, I am Access/VBA automation Expert since 11years. I already check your file, and test some queries, I confirm I can build your DB and queries/reports ASAP. Please let me know. I will be available after develop More

$344 USD in 5 days
(6 Reviews)

Would be happy to take this up.

$526 USD in 5 days
(10 Reviews)

Access is my middle name

$348 USD in 7 days
(10 Reviews)

Hello, I have more than 12 years experience in MS SQL and Access. Regards.

$500 USD in 7 days
(1 Review)

Please read the private message.

$277 USD in 7 days
(7 Reviews)

1. We have big experience in MS Access, Visual Basic, VBA, Excel, Word, Visual [url removed, login to view], C# , Crystal Reports and MS SQL, MySQL 2. We have developed lots of applications on MS Access - pure MS Access applications, More

$444 USD in 7 days
(1 Review)

Hi, I have over 8yrs of experience working on Excel and Access applications. Please see my job history. I have done timesheet related projects in the past and understand the concepts and reporting requirements. More

$250 USD in 20 days
(7 Reviews)

I can help you please check your Inbox.

$500 USD in 12 days
(1 Review)

I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, and let expert do it.

$263 USD in 3 days
(1 Review)

Hi. My proposal includes a few hours to analyze the best solution for your requirements. I'm a project manager, business process analyst and a very advanced user of Excel and Access. I can do the migration you are requ More

$490 USD in 8 days
(1 Review)

I would like to offer my services for this job.

$555 USD in 20 days
(1 Review)

I can do this job with these requirements.

$250 USD in 4 days
(2 Reviews)

I’m the best person for the Excel to Access conversion project that you have posted. I realize that there are likely other candidates who also have the ability to do this job. Yet I bring an additional quality that mak More

$468 USD in 5 days
(0 Reviews)