14. Most of the attendees are members of the Economic Development Professional Organization. Use an Update query to update the values in the Status field of the Attendees table to Member for all records. Run the query and save it using UpdateStatus as the name of the query. a. C. 15. Create a split form for the Registration table. Save the form using Registration Split Form as the form name. Close the form. 16. The PotentialDonors table contains records that should be appended to the Sponsors table. Create an Append query with the following options: Select all the fields from the PotentialDonors table in the same order that they are listed in the field list. b. Select Sponsors as the destination table in the Append dialog box. Save the query using AppendPotentialDonors as the name, run it, and then close it. The query should append 10 records. 17. Open the Relationships window and add the Attendees table and the Registration table to the Relationships window. Create a relationship between the Attendeeld field in the Attendees table and the Attendeeld field in the Registration table. Make the relationship enforce referential integrity. Save the relationship and close the window. 18. Use the Find Unmatched Query Wizard to find attendees who do not have a matching registration I Select the Attendees table as the table to display in the query results. b. Select the Registration table as the related table. Accessibility: Investigate Focus a. Text Predictions: On ie a. C. 18. Use the Find Unmatched Query Wizard to find attendees who do not have a matching registration Select the Attendees table as the table to display in the query results. b. Select the Registration table as the related table. Select the Attendeels as the common field in both tables. d. Display all fields in the query result. Save the query using Unmatched Registration as the query name. View the query results, confirm there is one record, and then close it. 19. Members who registered early paid a reduced registration fee. Create a Make Table query that selects all fields from the Registration table in the same order that they are e. 14. Most of the attendees are members of the Economic Development Professional Organization. Use an Update query to update the values in the Status field of the Attendees table to Member for all records. Run the query and save it using UpdateStatus as the name of the query. a. C. 15. Create a split form for the Registration table. Save the form using Registration Split Form as the form name. Close the form. 16. The PotentialDonors table contains records that should be appended to the Sponsors table. Create an Append query with the following options: Select all the fields from the PotentialDonors table in the same order that they are listed in the field list. b. Select Sponsors as the destination table in the Append dialog box. Save the query using AppendPotentialDonors as the name, run it, and then close it. The query should append 10 records. 17. Open the Relationships window and add the Attendees table and the Registration table to the Relationships window. Create a relationship between the Attendeeld field in the Attendees table and the Attendeeld field in the Registration table. Make the relationship enforce referential integrity. Save the relationship and close the window. 18. Use the Find Unmatched Query Wizard to find attendees who do not have a matching registration I Select the Attendees table as the table to display in the query results. b. Select the Registration table as the related table. Accessibility: Investigate Focus a. Text Predictions: On ie a. C. 18. Use the Find Unmatched Query Wizard to find attendees who do not have a matching registration Select the Attendees table as the table to display in the query results. b. Select the Registration table as the related table. Select the Attendeels as the common field in both tables. d. Display all fields in the query result. Save the query using Unmatched Registration as the query name. View the query results, confirm there is one record, and then close it. 19. Members who registered early paid a reduced registration fee. Create a Make Table query that selects all fields from the Registration table in the same order that they are e
