Question

1. Give the steps involved in creating a query using design view. Assume a table of your choice.
2. What are some operators you can use in an SQL query to search something? Explain.

​

Answer 1

Answer:

Q 1

ANS

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

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

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

Enter Criteria. ...

Run the Query. ...

The Result.

Explanation:

Q2

ANS

An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to perform operation(s), such as comparisons and arithmetic operations.