Create a parameter query for the Members table that will allow the user to enter a different state each time the query is run. The user should see all fields in the query result. Use Enter desired state as the input prompt. Save the query using Memberstates as the query name.

Create a query that joins the Members table and the Clubs table. Include the ClubName field from the Clubs table and the FirstName, LastName, and State fields from the Members table in the query results. Sort the records in ascending order by ClubName. Save the query using Clubs$-$Members as the query name.