I am starting a database and wanted to feel assured that I am starting correctly. So here we go. I plan to have an employee table to consist of PersonnelID (Primary Key), First Name, Last Name, Address, City State, Zip, HPhone, CPhone, Years worked, HireDate, Dept, Term Date, Hrly Rate, Work Status (Full or Part time), Manager ID (Foreign Key. Next Table - Paid Time Off Table - TimeOffID (Auto/Primary), PID (Foreign Key for PersonnelID), PTO Available, PTO taken, Date Taken Occurrence Table - OccurrenceID (Auto/Primary), PID(foreign key for PersonnelID), Occurence Type, Occurrence Date Last Table is for Wellness, WellnessID (Primary/Auto), Wellness Earned, Month Earned, Wellness Taken, Date Taken, PID(Foreign key for Personnel) Later I plan to set up queries run and/or create reports from this. I think I am on the right track, but this part is important as i will want to create sub-forms later. Please help. Thanks.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.