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.

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.

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.