How to Create a Query in Access 2013
Select CREATE > Query Design from the Ribbon toolbar. Choose tables. Choose fields. Adjust criteria. Run.
You can also use the Query Wizard to build a query, but these steps are for creating a query without using the Query Wizard.
You can also select the Queries tab or Both tab to include another query in your query.
Switching to Datasheet view will also run the query.
The "Totals" Option
You can use the Totals option to calculate the sum from a number of records.