Question

write the steps to creat a query using query design. class 8​

Answer 1

1) Launch Query Design View. Click Query Design from the Create tab in the Ribbon.

2) Select the Tables. Select each table that you need in the query and click 3) Add to add it to the query.

4) Add Fields. We are now in Design View.

5) Enter Criteria.

6) Run the Query.

Answer 2

Answer:

Design view gives you more control over the query you create than the Query Wizard does.

1. Open Query Design view. To get started, select Create > Query Design.
2. Add data sources. ...
3. Add output fields. ...
4. Specify criteria (optional) ...
5. Summarize data (optional) ...
6. Run or save the query.