In microsoft Access:

$10.$ Create a query in Design View for the Attendees table with the following options:

a$.$ Include the LastName, FirstName, City, and State fields in the query design grid.

b$.$ Sort the records in ascending order by LastName.

c$.$ Add criteria to select only those records where Philadelphia is the City.

d$.$ Save the query using PhiladelphiaAttendees as the query name.

Open the query in Datasheet View and then close it$.$