Create a query based on the agency table- Database Management System
Data File needed for this Case Problem: Rossi.accdb
Rossi Recycling Group Tom Rossi needs to modify some records in the Rossi database and then he wants to find specific information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him update the database and create queries. Complete the following:
1. Open the Rossi database located in the Access1 \Case3 folder, and then click the Enable Content button next to the Security Warning, if necessary.
2. In the Donor table, delete the record with DonorlD 36065. (Hint: Delete the related record first.) Close the table.
3. Create a query based on the Agency table that includes the Agency, FirstName, LastName, and City fields, in that order. Save the query as AgenciesByCity, and then run it.
4. Modify the AgenciesByCity query design so that it sorts records in ascending order first by City and then by Agency. Save and run the query.
5. In the AgenciesByCity query datasheet, change the contact for the Community Development agency to Beth Dayton. Close the query.
