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 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
Get step-by-step solutions from verified subject matter experts
