$7$ Open the CentralSierra$-03.$accob database start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor

Enable the contents in the security warning.

Run the NewSalaryCostSummary query. The results display in Datasheet view $($Figure $3-124).$ The query is supposed to summarize results by department and, within the department by title, the total salary cost and the total cost of potentially giving a $3\%$ raise to all employees. Several errors need to be repaired.

Figure $3-124$ NewSal$$nCostSummary quely retults

$4.$ Edit the query in Design view to delete the FirstName and LastName columns that cause the summary query to display too many records.

$5.$ Save and run the query to test the results. The datasheet should now show only $15$ records.

$6.$ Edit the query in Design view to repair the calculated field name and formatting.

a$.$ ~~ Change the default Expr$1$ name to SumOfPotentialNewSalary. Do not change the existing formula.

b$.$ Change the Format property to Currency

c$.$ Close the Property Sheet.

d$.$ Save and run the query to test the results. The datasheet should show the improved calculated field $($Figure $3-125).$

$\backslash$table$[[$Ttie$,$Depariment $*,$Sumpibas,SumDifera$],[,$Adirinistration.,$$300000,33,08000],[$Administrative Assislant,Heath and Benafis,$5800909,],[$Adminetralive Assistant,Whatrance Syes,$$5\mathrm{.}400\mathrm{.}00,$$$5,56200],[$Administrative Ascistant,Property end Casualyy,$$2.900\mathrm{.}09,32947$ co$],[$Chiet Executve Olticer,Admuistration,$51500000,$$$15\mathrm{.}449000]]$

Figure $3-125$ Query results with improvements to calculated field and removal of name fields