Question: Please help with populating the events and task table. 3.6. Select Staff_ID as the field value for storage in the EVENTS table and click Next.

Please help with populating the events and task table. 3.6. Select Staff_ID

Please help with populating the events and task table.

3.6. Select Staff_ID as the field value for storage in the EVENTS table and click Next. 3.7. Confirm the name of the new field is "Staff_ID" and click Finish. Following the prior sequence of steps should produce a new field in the TASKS table such that every time a new record is being added, a drop-down menu appears with information being fetched from the STAFF table. Once a staff member is selected, their Staff_ID will appear as the field value. 3.8. Repeat the steps above to create the Event field in the TASKS table. This field should be based on a lookup from the EVENTS table. Event_ID, and Event_Title should appear in the drop-down menu of the field, and only the Event_ID value should be stored in the field once a selection is made. 4. After creating all your fields, you can change the order in which the fields appear in the table. You can do so by opening the table in Design View and dragging the fields up or down. Re-arrange the table fields according to the order they appear in the EVENTS table description. By using the Lookup Wizard in the TASKS table, we have already started to create relationships among the EVENTS, STAFF, and TASKS tables. Next, we will verify and refine these relationships. Step 1.5 - Populate the TASKS Table 1. Add 10 different tasks to your newly created TASKS table, making up the dates. Create multiple tasks where you are the staff member. 3.6. Select Staff_ID as the field value for storage in the EVENTS table and click Next. 3.7. Confirm the name of the new field is "Staff_ID" and click Finish. Following the prior sequence of steps should produce a new field in the TASKS table such that every time a new record is being added, a drop-down menu appears with information being fetched from the STAFF table. Once a staff member is selected, their Staff_ID will appear as the field value. 3.8. Repeat the steps above to create the Event field in the TASKS table. This field should be based on a lookup from the EVENTS table. Event_ID, and Event_Title should appear in the drop-down menu of the field, and only the Event_ID value should be stored in the field once a selection is made. 4. After creating all your fields, you can change the order in which the fields appear in the table. You can do so by opening the table in Design View and dragging the fields up or down. Re-arrange the table fields according to the order they appear in the EVENTS table description. By using the Lookup Wizard in the TASKS table, we have already started to create relationships among the EVENTS, STAFF, and TASKS tables. Next, we will verify and refine these relationships. Step 1.5 - Populate the TASKS Table 1. Add 10 different tasks to your newly created TASKS table, making up the dates. Create multiple tasks where you are the staff member

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!