2] How to Create a Query in Query Design. To use Query Design. Click Query Design. In the Query Design window, there is a Show Table dialog box, with categories such as Tables, Links, Queries, or All.

Create a Query. To create a Query, go to the Create tab and click Query Design in the Queries group. Over on the right, you will see an Add Table window; choose the table you want to calculate.

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.

(In Access 2007, click the Create tab and then click Query Design in the Other group.) Add all the fields you want to your query. Right-click the Criteria cell under the State field and select Build.

Once you have made a Web query file, you can link it to Microsoft Access to perform database functions on it or produce Access reports. Click "External Data" in the Access ribbon. Click "Excel ...