Scheduling Tables and Relationships question

[CoachBarker]

I am in the process of creating a scheduling application in vb.net, I am using MS Access as the backend.

Simple scenario:

1. the boss puts a blank schedule on the desk
2. staff select the days they want to work
3. she then uses my app to assign staff to the days
4. previews and verifies schedule
5. prints out in an excel format

Application layout: a Month Calendar is used to select the start date of a 28 date range. Saves the Start Date and the End Date to textboxes. The 28 day date range (just the day, Oct 1, 2010), 1 is saved as the text property of a checkbox control. She then selects the checkboxes of the days the staff wants to work.

Data that needs to be saved:

1. Start Date
2. End Date
3. Date Range
4. Employee ID
5. Days Selected

Current Tables and Relationships



Am I going about this the right way or does this need to be changed?