Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a query in Design view, using your Cap1 Inventory table to answer the question. What is the item name (in alphabetical order), retail price,

Create a query in Design view, using your Cap1 Inventory table to answer the question.

What is the item name (in alphabetical order), retail price, and category for the sport of hiking? Add the fields in that order. Do not display the Sports field in the query results. Run the query, save it as Cap1 Hiking Query, then close the query. Seven records match the criteria.

Step by Step Solution

3.44 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Solution 1 Firstly we have to click on query design option in create menu 2 we can write query using ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
635dbeac746b9_178506.pdf

180 KBs PDF File

Word file Icon
635dbeac746b9_178506.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual C# An Introduction to Object-Oriented Programming

Authors: Joyce Farrell

7th edition

978-1337102100

More Books

Students also viewed these Databases questions

Question

Determine the mass of each substance. a. IBr3 b. N2O5 c. CCl4

Answered: 1 week ago

Question

Describe the key steps in writing papers for college.

Answered: 1 week ago

Question

Identify four methods of studying.

Answered: 1 week ago