G
Guest
I am setting up an employee database to track their training and availability
(access 2003). I have 5 tables so far:
tbl_employees
EmployeeId
employeenumber
firstname
lastname
tbl_department
DepartmentID
department
Manager
tbl_job
jobID
job
startingwage
tbl_availability
availabilityID
monday (yes/no)
tuesday (yes/no)
tbl_employeeavailability
employeeavailabilityID
EmployeeID
AvailabilityId
Do I need a seperate table for training? If so how do I track the dates the
employee took the training. we have upward of 5 training programs.
Is it possible to create one tabbed form for all my tables? 1st tab Employee
info, 2nd tab - availability etc.
I have more questions, but lets get the basics work out first. I am fairly
new to Access.
thanks
(access 2003). I have 5 tables so far:
tbl_employees
EmployeeId
employeenumber
firstname
lastname
tbl_department
DepartmentID
department
Manager
tbl_job
jobID
job
startingwage
tbl_availability
availabilityID
monday (yes/no)
tuesday (yes/no)
tbl_employeeavailability
employeeavailabilityID
EmployeeID
AvailabilityId
Do I need a seperate table for training? If so how do I track the dates the
employee took the training. we have upward of 5 training programs.
Is it possible to create one tabbed form for all my tables? 1st tab Employee
info, 2nd tab - availability etc.
I have more questions, but lets get the basics work out first. I am fairly
new to Access.
thanks