Question

In Access query design view, how should one calculate the average pay rate for all employees, using an Employee table that has EmplID as its primary key and SocialSecurityNo, LastName, FirstName, StreetAddress, PayRate, Telephone and DeptID as additional attributes?

1) Drag PayRate to the query grid and type Avg on the Criteria line under PayRate
2) Click the summation sign to add the Total line to the query grid. Drag EmplID and PayRate to the query grid, click Group By on the Total line under EmplID and click Avg on the Total line under PayRate
3) Click the summation sign to add the Total line to the query grid. Drag PayRate to the query grid. Click Avg on the Total line under PayRate
4) Drag EmplID and PayRate to the query grid. Type Group By on the Criteria line under EmplID and click Avg on the Criteria line under PayRate

Answer 1

To calculate the average pay rate in Access, use the Total line in the query grid to select Avg for the PayRate field.

Step-by-step explanation:

To calculate the average pay rate for all employees in Access query design view, using an Employee table that includes PayRate among other attributes, you should follow these steps: First, click the summation sign to add the Total line to the query grid. Then, drag PayRate to the query grid. After that, select Avg on the Total line under PayRate. This will compute the average PayRate across all the records present in the Employee table.