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.

Click on Queries in the left pane and then click Create Query in Design View. A new window will open, prompting you to Add Tables or Query ( Figure B ). Figure B ...

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.