PC Review

Thread Tools Rate Thread

Normalizing Tables and Enter Data in Fields Based on Employee Numb

Posts: n/a
      22nd May 2008
We had information that was being entered into a spreadsheet that we imported
into Access through the Import command and let it create the table
automatically. This table is used to capture weekly work detail information
for employees (Payroll Table).

We have another table that has all of the pertinent HR detail regarding
employees (name, employee #, rate, etc.). This table was also imported from
Excel. Only updated if new employees are hired.

After reading some of the discussions concerning normalizations I realize
that both tables have the same information in them (but with different field
names) and that the Payroll table should be changed so that the duplicate
fields are not there but only a reference to their information in the
Employee Table. Is this correct?

Employee Table fields:

Last Name (Text)
First Name (Text)
Home Dept (Text)
Emp (Text) - this is the employee number
Hire Date (Date/Time)
Rate (Currency)

Payroll Table Fields:
Payroll (Date/Time)
Employee Last (Text)
Employee First (Text)
Emp # (Text)
Pay Rate (Number) - no calculations are done on this field

The Payroll Table has other fields but they do not relate to the Employee
table. How would I normalize my database to make it better?

I have set up a relation between both tables using the Employee Number.

I have been trying to figure out a way to have some fields automatically
fill in based on information that is selected in the employee # field, i.e.,
first and last names and rate. What is the best way to do this?

Your help is greatly appreciated.

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
normalizing and creating fields or related tables Rob S Microsoft Access Database Table Design 0 4th Aug 2011 11:51 PM
Tables and Normalizing Data PS Microsoft Access Getting Started 4 19th Dec 2009 12:34 AM
Getting another employee's data from the Employee table, and text innumber fields Lostguy Microsoft Access 3 27th Nov 2008 05:40 AM
How to extract and then make an after event based in extrated numb =?Utf-8?B?bGRpYXo=?= Microsoft Access 1 2nd Jul 2007 07:26 PM
in a column of numb's and names, put the numb's in other colum =?Utf-8?B?T3N3aW4=?= Microsoft Excel New Users 6 30th Aug 2006 03:43 AM




All times are GMT +1. The time now is 09:24 PM.