In the Queries Group, there two tools that can create your Query these are: The Query Wizard: Helps you to create a simple Query Simple Query Wizard: This creates Query from the fields you pick.

Create Calculated Fields in Access Open Microsoft Access. Create a table or an existing table. Create a Query. To create a Query, go to the Create tab and click Query Design in the Queries group.

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.