Question

write the steps to create and run a query to fetch desired
​

Answer 1

To create a simple one-table query:

• Select the Create tab on the Ribbon, and locate the Queries group.

• Click the Query Design command.

• Access will switch to Query Design view. ...

• Click Add, then click Close.

• The selected table will appear as a small window in the Object Relationship pane.
• Set the search criteria by clicking the cell in the Criteria: row of each field you want to filter. Typing criteria into more than one field in the Criteria: row will set your query to include only results that meet all criteria. If you want to set multiple criteria but don't need the records shown in your results to meet all of them, type the first criteria in the Criteria: row and additional criteria in the or: row and the rows beneath it. Because we want to find customers who either live in Raleigh or in the 27513 zip code, we'll type "Raleigh" in the City field and "27513" into the or: row of the Zip Code field. The quotation marks will search these fields for an exact match.
• Setting the search criteria so that the query will find records with either "Raleigh" in the City field or "27513" in the Zip Code field.
• After you have set your criteria, run the query by clicking the Run command on the Design tab.
• Clicking Run
• The query results will be displayed in the query's Datasheet view, which looks like a table. If you want, save your query by clicking the Save command in the Quick Access Toolbar. When prompted to name it, type the desired name, then click OK.

Answer 2

Answer:

Answer in attachment.

Hope it will help you.