The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ Jobs...
This data model was designed to handle tracking of who's doing what for whom for jobs, connoisseur services and task management.  (Note, there only tables included in this database the balance is up to you!)
Business Rules...

Associates can have more then one Clients Schedule

Every Client will have a Schedule

Invoices can have more then one Time Card

Jobs will be done at different times (Frequency)

Schedules can have more then one Job assigned to them

Main Entities...


Time Cards


Time Cards can have more then one Schedule

Download Sample (Access 2003 and Unzipping program needed)

Client Profile

Associate Profile

Associates can have different Shifts