Question

Create a copy of cap one fitness query named Cat one hiking or biking shoes query. Redesign the query design to answer the question what is the sport Adam name category and cost for the category of shoes were the sport is hiking or biking? Arrange the fields in order in which there mentioned in the question. Sort the records first in ascending order by sport and then in descending order by cost hide the category field so that it does not display the in the results. Run and then close the query. Six records match the criteria.

Answer 1

To create a copy of the cap one fitness query named Cat one hiking or biking shoes query, open the cap one fitness query and redesign it by arranging the fields in the order mentioned in the question. Sort the records by sport in ascending order and by cost in descending order.

Step-by-step explanation:

To create a copy of the cap one fitness query named Cat one hiking or biking shoes query, you will need to first open the cap one fitness query. Then go to the create tab and select 'Query Design' to open the query design view. In the query design view, you can rename the copy as Cat one hiking or biking shoes query.

To redesign the query design to answer the question, you will need to add the necessary fields from the table to the query design view. The fields mentioned in the question are sport, Adam name, category, and cost. Arrange these fields in the order they are mentioned in the question.

Next, hide the 'category' field from displaying in the results by right-clicking on the 'category' field in the query design view and selecting 'Hide Field'. Finally, to sort the records, go to the 'View' tab and click on the 'SQL View' button. In the SQL view, enter the following code to sort the records:

SELECT * FROM [Cat one hiking or biking shoes query] WHERE sport='hiking' OR sport='biking' ORDER BY sport ASC, cost DESC;

Running the query will display the records that match the criteria. Once you have reviewed the results, you can close the query.