Convert Excel to Access database - Time Tracking and Reporting
$250-750 USD
キャンセル
投稿日: 10年以上前
$250-750 USD
完了時にお支払い
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
Assumptions:
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
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 successfully finished over 430 projects in last 13 years.
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
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 development, as support.
Regards,
Fabrice
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 requesting and the reporting with top quality but I can propose other solutions using the design of dashboards.
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.
I have seen the attached excel and understand your requirements. Please accept my bid so we can start the work.
thanks & regards
Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.
Hi, I would definitely help you in this job. I am working with MS Access VBA from last 12 years. I have designed lots of database software using MS Access, Excel with custom Forms, Queries, Reports and MS SQL linked databases etc. For you project we can either us Excel or MS Access SQL Project(.adp) or MS Access db linked with SQL. Would discussion we can do on Skype/G-talk. Regards, Pramod