Time Cards - Excel Vs Access as option
Given some of the comments offeredin other threads, could someone please advise me as to whether I'm better off developing something in either Excel or Access, or a combination of both, if I want to enter and record time card information.
Currently the company records both the time worked per employee and then breaks down the hours worked into hours worked per unit function in an effort to determine where the labour costs are being incurred.
With the example atached, am I better off to try and build the "time card" as a User form or simply attach command buttons at the bottom of the card layout on sheet 1?
If you recommend just Excel, how does the information become stored and will I retrieve the information under Pivot tables/ Pivot Charts?
If you recommend just Access, can Access allow a "time card' layout like this for data entry?
If you recommend a combination of Excel and Access, well I might as well take up drinking full time!! (Did I mention, that Access and I have a dislike for each other?)