Planning Sheet
Assignment 11 Planning Sheet
Staff Table
Schedule
Weeks
Field Type Options
Employer ID
First Name
Last Name
Address
City
Postal Code
Phone Number
Email Address
Birthdate
HealthCard
Allergies/Health
Tshirt Size
Field Type Options
Week Number
Employee ID
Field Type Options
Week Number
Start Date
Weekly Pay
Location
Identify the Primary and Foreign Keys and the relationships between the three tables.
Staff
Employer ID
First Name
Last Name
Address
City
Postal Cod
Phone Number
Email Address
Birthdate
HealthCard
Allergies/Health
Tshirt Size
WhichStaffMember
FullName
Schedule
Week Number
Employer ID
Weeks
Week Number
Start Date
Weekly Pay
Location
Completion Checklist
Question 1
Field Definitions completed for
Staff Table
Schedule Table
Week Table
Data Imported
Staff Table
Schedule Table
Week Table
Relationships created
Question 2
Staff Details Layout created
Tabs created with appropriate fields added
Birthdate field modified
End Date field created in Table
Schedule tab modified with a portal showing the beginning and end dates
Total pay calculation completion
Question 3
Global field called WhichStaffMember created in Staff Table
Concatenated Field Created with ID: Last Name, First
Create a second concatenated field
WhichStaffMember is on the Staff Details layout and formatted appropriately
Create a script to find a particular staff member called FindStaffMember
Add a Go Button and attach the script and text.
Question 4
Weekly Schedule layout created
Portal added and sorted.
Script created to go to Staff Details when student clicked in portal
Script created to go to the week of work selected in the Schedule tab
Web Viewer added
Question 5
Layout created in Schedule table called Pay Summary
Summarize the data based on the week
Question 6
New chart layout created called Weekly Pay Summary
Week Number (x-axis) and Start Date (y-axis)
Question 7
New Add to Schedule button on Staff Details.
Custom Dialog Box that will add a Staff Member to a particular week.
Cancel Button goes back to Staff Details and deletes newly created blank record
OK button brings you to Staff details and to the student just added.
Script is attached to button
Question 8
Password protected with CS200Marker
Password protected with CS200Observer
Password protected with CS200Student
Admin is turned on with no passwordd