Question: what are the steps involved in creating a query using query design method?
Answer: Launch Query Design View. Click Query Design from the Create tab in the Ribbon.
Select the Tables. Select each table that you need in the query and click Add to add it to the query. ... 
Add Fields. We are now in Design View. ... 
Enter Criteria. ... 
Run the Query. ... 
The Result.