Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Closed Thread
 
Thread Tools Rate Thread Display Modes
Old 05-16-2015, 05:27 PM   #1
burrina
Newly Registered User
 
Join Date: May 2014
Posts: 974
Thanks: 67
Thanked 151 Times in 133 Posts
burrina will become famous soon enough
Payroll Strategy

If you were designing a Payroll database and wanted to add absence and vacation time into it, Would you:

A. Add the Required fields to the Payroll and simply link to the others tables
B. Create subforms linked by PK and FK
C. How would you then track the absence and vacation time apart from Payroll

D. ?

1. Create Absence Reports
2. Create Vacation Reports

__________________
Up Late? It's the What If Safeguards.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
burrina is offline  
Old 05-17-2015, 02:42 AM   #2
ButtonMoon
Newly Registered User
 
Join Date: Jun 2012
Posts: 304
Thanks: 11
Thanked 56 Times in 55 Posts
ButtonMoon will become famous soon enough
Re: Payroll Strategy

The best answer is not to do any of those things. Get yourself an off-the-shelf payroll package. Unless you are a software vendor there is almost certainly no sensible reason to write your own payroll application. If you did have a reason to do such a thing then Access would not be the platform of choice for a payroll.

Working time and absences can be tracked through a timesheet, which in principle could be a single table with start and end dates for different types of activities. Some aggregation of the timesheet table would then become an input to the payroll system.
ButtonMoon is offline  
Old 05-17-2015, 06:02 AM   #3
burrina
Newly Registered User
 
Join Date: May 2014
Posts: 974
Thanks: 67
Thanked 151 Times in 133 Posts
burrina will become famous soon enough
Re: Payroll Strategy

Read Question Again! It is already written, was asking for some thoughts, direction.

__________________
Up Late? It's the What If Safeguards.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
burrina is offline  
Old 05-17-2015, 06:09 AM   #4
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,791
Thanks: 55
Thanked 1,027 Times in 993 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Payroll Strategy

I was going to say exactly the same thing as button moon with regard to payroll in general

however, if you just want to track absence and vacation time, then have a table

employeeid, absencereason, datefrom, dateto, [maybe workingdays]

storing [workingdays] is clearly reduncant, but it may be easier to store the evaluated figure, rather than keep recalculating.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline  
Old 05-17-2015, 06:53 AM   #5
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,238
Thanks: 93
Thanked 2,026 Times in 1,973 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Payroll Strategy

I agree with Button and Dave re Payroll. However, if you're going to monitor/track absence and vacation, I recommend you identify what exactly you want to track. Many orgs have codes for sick, bereavement, training, vacation, stat holiday, compensatory time off....... I don't think absence alone is the subject, but we do not know your set up nor requirement.
Is there a breakdown of absence type in your spec/scope?

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline  
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts Strategy philb316 Reports 0 11-30-2012 07:50 AM
Code strategy vassa Modules & VBA 29 01-29-2010 06:41 AM
Help strategy VBAhole22 Modules & VBA 5 11-19-2002 12:48 PM
Vba strategy required arage Modules & VBA 1 04-10-2001 01:30 AM




All times are GMT -8. The time now is 01:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World