37) Consider the table pictured above.GrossPay is a calculated field. Which of thefollowing expressions was used to calculate the data for the field?A) [HoursWorked]*[HourlyWage]B) [HoursWorked] x [HourlyWage]C) [HoursWorked]([HourlyWage])D) [HoursWorked]+ [HourlyWage]Answer:ADiff: 1Reference:Calculations, Expressions, and FunctionsObjective:2AppChap:Access 3: Customize, Analyze, and Summarize Query Data38) Consider the table pictured above.The value 4 in the totals row represents thenumber of employees listed in this table.How was this value calculated in the totalsrow?A) This value is a result of the Count function being applied to the LastName FieldB) This value is a result of the Average function being applied to the LastName FieldC) This value is a result of the Sum function being applied to the LastName FieldD) This value is a result of the Maximum function being applied to the LastName FieldAnswer:ADiff: 1Reference:Aggregate FunctionsObjective:6AppChap:Access 3: Customize, Analyze, and Summarize Query Data39) Consider the table pictured above.The value of 150 in the totals row represents thetotal hours worked.How was this value calculated in the totals row?A) This value is a result of the Count function being applied to the HoursWorked FieldB)This value is a result of the Average function being applied to the HoursWorked FieldC) This value is a result of the Sum function being applied to the HoursWorked FieldD) This value is a result of the Maximum function being applied to the HoursWorkedFieldAnswer:CDiff: 1Reference:Aggregate FunctionsObjective:6AppChap:Access 3: Customize, Analyze, and Summarize Query Data40) Consider the table pictured above.The value of $17.50 in the totals row representsthe mean hourly wage.How was this value calculated in the totals row?A) This value is a result of the Count function being applied to the HourlyWage FieldDownloaded by yumna noor ([email protected])lOMoARcPSD|20086558
B) This value is a result of the Average function being applied to the HourlyWage FieldC) This value is a result of the Sum function being applied to the HourlyWage FieldD) This value is a result of the Maximum function being applied to the HourlyWage FieldAnswer:DDiff: 1Reference:Aggregate FunctionsObjective:6AppChap:Access 3: Customize, Analyze, and Summarize Query Data41) What function in a Totals Row would calculate the least valued data item in agroup?A) MaximumB) CountC) AverageD) MinimumAnswer:DDiff: 1Reference:Aggregate FunctionsObjective:6AppChap:Access 3: Customize, Analyze, and Summarize Query Data42) An expression or integer value specifying total number of payments in a loan is the________ argument in the PMT function.A) rateB) num_periodsC) present valueD) future valueAnswer:BDiff: 1Reference:Expression Builder, Functions, and Date ArithmeticObjective:5AppChap:Access 3: Customize, Analyze, and Summarize Query Data43) You can use the ________ function in an expression requiring the current date.
Upload your study docs or become a
Course Hero member to access this document
Upload your study docs or become a
Course Hero member to access this document
End of preview. Want to read all 103 pages?
Upload your study docs or become a
Course Hero member to access this document
Term
Summer
Professor
n.
Tags
Computer program, Section Ref, yumna noor
