Em Andamento

1 Report for attendance database

1 Report module to be created for attendance database

General requirements:

1. User does not own MS Access, reports needs to be generated as a pdf automatically every business day

2. If additional library is needed, those library needs to be included as deliverable

3. Version of MS Access is 2000

4. All Source code will be delivered and tested before payment is paid

5. If code is delivered in 2 days upon approval, an additional $50 bonus will be granted

Report requirements:

1. Attendance and entry exception report (for previous and current month)

1a. The report needs to sort out repetitive records within X minutes (ie, 5 min)

For example,

20070806 09:04am | login

20070806 09:05am | login

20070806 09:06am | login

In this case, 20070806 09:04am | login should be used as the login record

1b. The report needs to alert the employee administrator on un-matching records

For example,

20070806 09:04am | login

20070806 12:23pm | logout

20070806 18:33pm | logout

In this case, 20070806 18:33pm | logout should be alerted as an orphan record in the report

1c. The report needs to sort out errorous records within X minutes (ie, 5 min)

For example,

20070806 09:04am | login

20070806 09:05am | logout

20070806 12:23pm | logout

In this case, 20070806 logout should be ignored

1d. Report

Sample data:

20070806 09:04am | login

20070806 09:05am | login

20070806 09:06am | login

20070806 09:04am | login

20070806 12:23pm | logout

20070806 18:33pm | logout

Summary:

Month | User | Worktime

200708 | Jane Doe | 180:30 (hr:mm)

200708 | John Doe | 158:23 (hr:mm)

Detail

Jane Doe

Date | worktime

20070801(Wed) | 8:15 (hr:mm)

20070802(Thu) | 8:02 (hr:mm)

20070803(Fri) | 8:10 (hr:mm)

20070806(Mon) | 3:19 (hr:mm) with Exception (Orphan records)

John Doe

Date | Worktime

20070801(Wed) | 8:15 (hr:mm)

20070802(Thu) | 8:02 (hr:mm)

20070803(Fri) | 8:10 (hr:mm)

...

1e. There may be other exception that needs to be handled.

Habilidades: .NET, Processamento de dados, Visual Basic

Ver mais: access sample attendance, attendance database, access attendance database, attendance database access, attendance report access, un code, employee needs, code 1, library sort, access database module, attendance exception reports, attendance sample access, access database attendance, attendance records database, loginlogout attendance free, sample record attendance report, sample database attendance access, attendance login logout report, access attendance report, sample project access sort, attendance database requirements, access database attendance report, free attendance access codes, access attendance logging, report example

Acerca do Empregador:
( 1 comentário ) el monte, United States

ID do Projeto: #165290