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.

When you have to scroll to the right to view all of the data on a wide Access query or report, ... click "Create" and double-click "Query Design." ... How to Set Up a Form With Two Tabs in Access.

When you need quick answers to everyday business questions, let Access' Crosstab Query Wizard help. For example, say you need to know the average number of hours each employee works per week. To ...

Select a query or table to create a form from it and click "Form" on the Create tab. Create a blank form by clicking "Blank Form" on the Create tab. Add tabs to the form. Select the "Design" tab ...

(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.