程序代写代做代考 Planning Sheet

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