Add worker working time

[Japi67]

Hello,

My first post

But anyway, I have table where is lot of information and i need add every worker working time every day. Is there easy way to make form to make this?
Or can i put those hours direct to table form?

Main Table is like this about (date i just make here e.g. , i don't know is that possible to add table)

id name address avtive contract_start contract_end 1.1.2015 2.1.2015 3.1.2015 ........ 31.12.2015
1 john house1 x 1.1.2015 8 7 vacation 8
2 jack house2 1.1.2015 30.7.2015 6 sick leave 8
and so on

Can anyone help me?

Thanks.

[June7]

Can use code to pre-establish a set of employee records then apply filter to form so those records are displayed and edit their time.

You show columns with dates as headers. This is not a normalized db structure and will cause you lots of problems in the future. For one thing there are 365(366) days in a year but a table can have only 255 fields.

Also, appears to be dd/mm/yyyy dates which is not Access standard of mm/dd/yyyy and that can also cause issues. Review: http://allenbrowne.com/ser-36.html

[Japi67]

Is There any better way to do "worker working time system"?

Maybe on Excel Pivot table is better to mark those hour/day/worker and use Access to manage rest on table (name, address, and so on)?
Use link between Access and Excel.
I mean is more easy to put new data with Access (Use forms)

[June7]

Doesn't matter. If you have more than 255 columns, Access can't see any over the 255.

IMO, Time & Attendance is one of the more difficult dbs to build. Fairly common topic in forum. Did you search?

There is a MS template Desktop Time Card you can download, in 2010 can be found by: File > New > Business > about 4th row down.

[Japi67]

Thanks.

Maybe i use access only to handle worker data ( add, remove, address, age, .....). There will be on about 60 columns and every year is 200-300 worker.

I separate timecard and use Excel in that.

[June7]

Excel timecard is an option (my office does that) but don't you still need to get data into normalized relational database?

[Japi67]

Here is great video how i manage worker database with Access and Time Card is in Excel.
Sorry video bad quality, i just use phone

Watch and laugh

https://youtu.be/9pKrgdPSqRk