QUESTION 18 5 points Save Answer Which of the following can NOT be done with the Expression Builder? Extract just the left most character of a first name and save it as Firstinitial Extract just the year from a short date field and add 30 to it to find out the year that a 30 year mortgage will be paid in full Calculate loan payments on a mortgage All of the above can be done with the expression builder QUESTION 19 5 pointsSave Answer What is the difference between a totals row and a totals query? A totals row is added to a datasheet view while a totals query uses an aggregate function in the design vievw. A totals row allows all types of summary statistics while the totals query can only summarize data in a few common ways (such as sum, average, min, and max). You can insert as many totals rows as you need but can only add one level of aggregation to a totals query. You can add criteria to a totals row, but can't add criteria to a totals query QUESTION 20 5 points Save Ansver Which of the following can be added to a totals query? Conditions Grouping fields Aggregate functions All of the above can be added to a totals query