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.

Right-click the field name in the query design grid, and select Properties. On the General tab, enter a name in the Caption text box. The name in the Caption text box now appears as the field's ...

On the bottom window, you will see the Design Grid. A Design Grid is a tool that creates Query by placing fields from the selected table in the window’s upper parts to the lower parts of the window.

Open the query in Design mode. Right-click the query design grid and select Properties (Figure A). Figure A. Click in the Unique Values property box and select Yes (Figure B).