Joined: 04 Jan 2012
Location: New York, USA
|Posted: Mon Apr 02, 2012 6:47 pm Post subject: Write a database that will serve as a time clock
From researching and reading I know that I have to create a table that will contain the User Name, I also need to create a table that will have a "Start Time" and "End Time" Fields.
I am seeking advice on how to go about putting together the database using a form that will display at start up of database that will serve as a time clock so we can Clock In/Out, as follows:
Will Prompt for User Name and password
Will Stamp sometime of Auto Date and Time as the user logs in.
User will select Time In or Out ( button or drop down).
My Challenges are as follows:
How to insert the auto date
How to create the password field (I'll research threats to see if there is a solution).
The final product should prompt for user name and password.
Once log in the user will click on IN or OUT, and the information will be recorded so I can total the amount of hours for the week.
I thank you in advance any and all the help that you can provide.
Be above it! Make the world serve your purpose, but do not serve it.