You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson." Describe how to accomplish this.

What will be an ideal response?

Click the Create tab on the Ribbon, then click the Query Design button in the Queries group. On the Tables tab of the Show Table dialog box, click Employees, click Add, click Pay, click Add, then click Close. In the Employees field list, double-click the Last Name field, and then double-click the field Salary from the Pay field list. In the criteria cell for Salary, enter > 25000. In the criteria cell for Last Name, enter "Wilson." Click the View button in the Results group. Save the query.