If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I design a Employee labor data base?
I want to design a data base that records a employees hours by the week and
computes his pay. How many tables do I need ? |
#2
|
|||
|
|||
How do I design a Employee labor data base?
12 Tables. :-)
Seriously, how many Tables you need will depend on what kinds of information you want to collect and store. You might check out the "Time and Billing" sample database. To create that, use File -- New, choose the Databases tab, and choose "Time and Billing". You might not need some of the objects that the Database Wizard will create for you, but I think that playing around with the database will be instructive. As an alternative, you might consider looking for a commercial program to do this accounting. There are legal requirements attached to computing people's pay, so making a mistake in your database could become pretty expensive (= possibly more expensive than the accounting package). -- Vincent Johns Please feel free to quote anything I say here. AccessCharlie wrote: I want to design a data base that records a employees hours by the week and computes his pay. How many tables do I need ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query missing data | LHEMA | Running & Setting Up Queries | 8 | December 9th, 2005 02:15 PM |
need help for employee skills database design | sgopus | Database Design | 1 | October 28th, 2005 03:50 AM |
Referencing a newly created worksheet | Charyn | Worksheet Functions | 2 | May 2nd, 2005 04:13 AM |
Matching data and returning header | matman17 | General Discussion | 2 | July 2nd, 2004 07:57 PM |
Design questions for tracking employee hrs & client billing | JPearson | Database Design | 3 | May 24th, 2004 06:06 AM |