Creating an attendance tracker database in Access

Question

Creating an attendance tracker database in Access

Anonymous

I am really struggling to create a database to track agent call offs and PTO within Access.

I created a table with each employees name, role, supervisor, department

I then created an attendance table to have the following information display

Date, Agent Name, Role, Dept, Supervisor, Event Type (Call off or PTO), Reason (personal, sick, etc), Hours

I want to be able to enter the date then choose an agents name from a drop down in that table and have the role, dept, supervisor AUTO populate with the corresponding information from the table that houses that information already.. i then want to be able to choose items from a drop down for event type and reason, and then manually enter in the hours

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

then created an attendance table to have the following information display

Date, Agent Name, Role, Dept, Supervisor, Event Type (Call off or PTO), Reason (personal, sick, etc), HoursI want to be able to enter the date then choose an agents name from a drop down in that table and have the role, dept, supervisor AUTO populate with the corresponding information from the table that houses that information already..

No you do NOT want to do that. That is not the way Relational databases work. One of the main principles of a relational database is data exists in one place only. So your attendance table should look like this:

tblAbsence

AbsemceID (PK Autonumber

AbsenceDate

EmployeeID (FK)

EventTypeID (FK)

ReasonID (FK)

HoursOff

You can always pull the Role, Supv and other info from the Agents table as needed.

Share via

Creating an attendance tracker database in Access

1 answer