reate a parameter query for the Members table that will allow the user to enter a ifferent state each time the query is run. The user should see all fields in the query esult. 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 ield 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. bave the query using Clubs$-$Members as the query name.

Dpen the SCMembers query and find all members who belong to the club with a ClubID C$01$ and who reside in South Carolina $($SC$).$ Save the query.

Dpen the Members$-$Swimmers query and change the join properties so that all members are included in the query results. Sort the query in ascending order by LevelID. Save the query.

Import the Support$\_$AC$19\_$EOM$2-1\_$SwimStrokes.xIsx file into the SwimStrokes table. Do not save the import steps.

ic Hebert

$3710021$

Randy Collins

$225-846-6380$

Westlake Petro.