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.
You might also like to view...
Software as a Service (SaaS) hosts web-based applications
Indicate whether the statement is true or false
A prerecorded radio-like show is called a(n) ________
Fill in the blank(s) with correct word
Identify the letter of the choice that best matches the phrase or definition.
A. The colors that make up a gradient B. A set of 12 preset adjustments that affect the brightness and contrast of a layer style to create dramatic lighting effects C. The layer that functions as the clipping mask D. To convert to pixels E. Using artwork on one layer to mask the artwork on a layer above it
The only integer that can be assigned directly to a pointer is _______.
Fill in the blank(s) with the appropriate word(s).