Once you get a little experience in creating and working with queries, you’re ready to move on to Query Design view. Each of the Access objects (Tables, Queries, Forms & Reports) has at least two views – the view you see the results in and Design View.
When you work in Design view, you’re essentially working with the structure of the object. In this lesson, we’re going to focus strictly on using Query Design view.
Creating a Query Using Design View
1. Click the Query Wizard command In the Other group on the Create tab
2. Choose the table(s) for your query
3. Click Close
4. Drag fields from the upper query pane to the lower query pane that you want to display in your query
5. Choose the Run command in the Results group on the Query Tools Design Contextual tab