Table design to match employee availability to client's need

**jdkeese** · 07-31-2014, 08:33 PM

Hello,

I am relatively new to Access, and I am designing my first practical database. I need to be able to input each employee's available hours for each day, and then match it to the times that clients need service. I think that I will need to use junction tables, but I am unsure on how to set up my tables to specify times or blocks of times on particular days.

**burrina** · 07-31-2014, 10:13 PM

tblEmployees
tblClients
tblHours

This would be your base tables. Not sure of your end game Schema. Also her is a link that may help. http://www.databaseanswers.org/data_models/

HTH If more help is needed, provide more details.

Table design to match employee availability to client's need

Thread Tools

Table design to match employee availability to client's need

Similar Threads

Database Design - A table for each client, or one table for them all?

how do i place an employee picture from employee table into the asset table's form

Help with Table Design for Employee Task Database

Query to match job and client skills?

Table design to Track Multiple Client Types

Posting Permissions