Question

Which of the following steps correctly creates a new select query in Query Design View using the Clients table, includes the ClientName, City, and State fields in that order, runs the query, and saves it with the name "ClientLocations"?

a) Open Query Design View, add Clients table, select ClientName, City, and State fields in any order, run the query, and save as "ClientLocations."

b) Open Query Design View, add Clients table, select State, City, and ClientName fields in that order, run the query, and save as "ClientLocations."

c) Open Query Design View, add Clients table, select ClientName, City, and State fields in that order, run the query, and save as "ClientLocations."

d) Open Query Design View, add Products table, select ProductName, Price, and Quantity fields in that order, run the query, and save as "ClientLocations."

Answer 1

To create the 'ClientLocations' select query in Query Design View, add the Clients table, and select the 'ClientName', 'City', and 'State' fields in that order, then run and save the query under the name 'ClientLocations'.

Step-by-step explanation:

To create a new select query in Query Design View using Microsoft Access, you should follow these steps for the desired result:

1. Open Query Design View.
2. Add the Clients table to the query.
3. Select the fields in this order: ClientName, City, and State.
4. Run the query to ensure it returns the expected results.
5. Save the query with the name "ClientLocations".

Following these steps accurately will result in creating and saving a query that displays client locations by name, city, and state from the Clients table.