Question

Write the stepa to create and run A query to fetch desired results?

Answer 1

Answer:

$\huge \fbox \colorbox{orange}{Answer }$

Explanation:

To create a simple one-table query: Select the Create tab on the Ribbon, and locate the Queries group.

...

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.

Answer 2

Answer:

Answer in attachment. ( 3 attachment)

Hope it will help you .