MS Access Timesheet system

In Progress

Overview

Timesheet package for services based IT consultancy

Some work has already been done on this by me – however I am struggling with basic access skills to finish this off. My impression is that a skilled access person may be able to finish this off fairly quickly.

Platform

MS Access 2010/2013 Desktop database

Requirements

Review existing database structure (which I believe is ok – or at least close)

Create/Modify forms for user data entry as required

Create reports as required

Implement very basic security model based on Windows username

Provide assistance and suggestions with the “finishing touches”

Functionality Description

Administration

• Add/Remove/Modify Customers (Believe this form is “done”)

• Add/Remove/Modify Projects (need filters and cascading combo boxes implemented, need to be able to create new record on same form, while locking the customer field under ”normal” use)

• Add/Remove/Modify Employees (Believe this form is “done”)

• Approval mechanism of submitted timesheets (not started)

• Add/Remove/Modify support agreements (Support agreements is where customers by a pre-paid block of hours, the gradually use up those hours)

• Reports

1. View time data with the following filters

1. Date Range

2. Employee

3. Customer

4. Project

5. All filters need to be optional (i.e. don’t hav to select values for them all) but do chain when multiple selected (e.g. date range and employee)

2. View Support agreement status

3. Option to automatically email a client contact a support agreement summary report on last Friday of every month.

4. Employee utilisation, sick days etc

5. Project report – show projects (optional filter by customer) - active, remaining time etc

Employee

• Add timesheet data for current week (detect user, detect current week, cascade combo box of project when selecting customer)

o Option to email manager once timesheet is completed by employee

o Manager can approve each entry or “approve all” button

• Review previous weeks (allow employees to review previous data, but not change it)

• View status of annual leave/sick leave, utilisation etc.

• Reports

o Customer support agreement status

o Customer project history

o employee work history

Other

• Number of fields need to be calculated, such as remaining time on a project (total project time – time logged against project), employee sick leave remaining, employee annual leave remaining etc.

• Set customer customers email address to be “clickable” so it will open with a mailto:

• Split the database (when ready)

• Force TDHours field to only accept time entry in .25 increments (i.e. 1, 4.5, 7,75 etc.)

• Assistance with creating a method to mass import data from Excel

Quoting

I am looking for the following in any quote:

• Review the attached database to have a look at the idea and how much work will be required

• An hourly rate

• An estimated number of hours to complete the above

• An estimated number of hours when you will have a "first version" ready - this will me to ensure that the project is heading in the right direction. If it is not, the project may be ceased.

• A willingness to continue working one the solution once the above tasks have been completed, for further improvements or troubleshooting

• If you are responding this – use the phrase “Calvin is cool” at the top of your response, to show you have actually read this and it’s not just a spam response.

Skills: Microsoft Access

See more: create timesheet access, access timesheet, timesheet access, access employee timesheet, create timesheet access 2010, access database timesheet, access 2010 timesheet, timesheet access database, access timesheet reports, access timesheet database, access report timesheet, creating timesheet access 2013, timesheet system, timesheet access 2013, access creating timesheet, create timesheet database access, project 2013 timesheet history filter working, access project timesheet, create access timesheet, access timesheet report, create timesheet access database, timesheet access excel, project timesheet access excel, import timesheet data project 2013, access timesheet timesheet

Project ID: #4673422

34 freelancers are bidding on average $20/hour for this job

illuminesoft

Calvin is cool I will like to continue development in Access 2010 format, we can use MAPI object or CDO for email, let me know your preference We are amongst top 1% global outsourcing providers. We have successfully More

$10 USD / hour
(238 Reviews)
7.4
kulhanekd

I have 15 years exp in access. I can build your database. Donna

$22 USD / hour
(34 Reviews)
5.8
MarlinSoftware

---Calvin is cool, if he awards Marlin Software this project --- Hi, I am a developer with over 22 years experience building complex database systems, specializing in the development of applications in MS Access using More

$45 USD / hour
(23 Reviews)
5.6
expertcoder1vw

Calvin is cool I'm an Access expert with over 15 years of experience in MS-Access and SQL database development. Regards, Larry

$23 USD / hour
(22 Reviews)
5.4
winghei

Calvin is cool :) I see your needs and i want to help. Please check your pmb.

$22 USD / hour
(30 Reviews)
5.4
davidgraf

Calvin is cool! I literally have several decades of experience working with, developing and supporting relational database applications including products like Microsoft's Access and SQL Server. In fact, I helped deve More

$20 USD / hour
(7 Reviews)
4.8
NourElDeen

Calvin is cool,Dear Sir i'd like to help on doing that project. Kind Regards, NourElDeen

$20 USD / hour
(40 Reviews)
4.7
fabest

Dear, I am Access/VBA automation Expert since 10years. I confirm It can be done in Access with nor problem, just need time. I already develop tools to manage stocks/ time etc... with complex queries. I will be avai More

$18 USD / hour
(11 Reviews)
4.5
DenisSmolentsev

Hello! Let me help you with this project.

$23 USD / hour
(23 Reviews)
4.1
eperfections

Please see private message

$15 USD / hour
(14 Reviews)
4.1
Aronvitki

Calvin is cool!!! I have over 10 years Access experience and I guarantee my work. I've done payroll databases before and can help you out in a relatively short amount of time. I'm known to go over and above client More

$15 USD / hour
(8 Reviews)
3.7
makhan786

check your pm

$22 USD / hour
(3 Reviews)
3.7
individu

Calvin is cool, but only if he award this project to me :) Please check PM, thanks!

$26 USD / hour
(1 Review)
3.4
hegemon88

Calvin is cool? 15 years of corporate and freelance experience with Access and Excel - now, that is cool!

$27 USD / hour
(7 Reviews)
3.2
vickkey7

I am ready to start this project...

$22 USD / hour
(1 Review)
3.0
nayabsiddiqi

can provide you the quality database with forms to maintain specifications

$21 USD / hour
(3 Reviews)
2.6
codetod

Software professional with 12+ years experience in programming and database management

$16 USD / hour
(3 Reviews)
2.5
anomanpk

I would like to offer my services for this job.

$11 USD / hour
(2 Reviews)
2.4
sudewa

Hi, Calvin is cool!!!! I have good skills in MsAccess and sql and delivered quality results in my previous projects. I cannot give a time estimate this time but I would provide one if you are interested in working wi More

$38 USD / hour
(1 Review)
2.0
bgriffin001

“Calvin is cool”..but I am cooler.I have already written a complete ACCESS T & M timesheet billing system for Cotton Construction in Houston. 400 employees. Been using it for years. Let other tell you what experience t More

$26 USD / hour
(1 Review)
1.0