Timesheet database

[PietKruger]

Hi, i am clueless. I own a small coffeeshop and would like to create an access database that could help me with the timesheets of my staff. They are paid per hour and their hourly rates vary. I would like my employees to click on buttons that captures the following:

Date
Shift Start time
Lunch start time
Lunch End time
Shift End time

please advise me. I have Office 2007 installed on my PC and Access just confuses me.

Pieter

 

[gemma-the-husky]

Seriously ...

isnt excel sufficient for this

using access seems a bit over the top

 

[ezfriend]

1. You can create a table to hold your employee information

tblEmployee
Employee_PK
FirstName
LastName
HourlyRate
UserName
Password
.....

tblTime
Time_PK
Employee_PK
ShiftStart_DT
LunchStart_DT
LunchEnd_DT
ShiftEnd_DT


2. Create a form for employee to log in.

3. Create another form with the four buttons for your

ShiftStart_DT
LunchStart_DT
LunchEnd_DT
ShiftEnd_DT

You will need to code your form so that the approprate button is enabled/disabled.

Yes, if it's a small company, it's best to just have employee fill out a small piece of paper and just log those in EXCEL (gemma-the-husky)