10. 11. 12. 13. 14. How many records are shown in this query (Customer Sales before June 30)? Use the Retailer Customers table and the Cash Receipts before June 30 query to create a new query in Design View. Include customer # and customer name from the Retailer Customers table and the Receipt Amount eld from the Cash Receipts before June 30 query. Select Design > Show/Hide > Totals to add the total row and change Group By under Receipt Amount to Sum. Change the name of the summed eld to \"Amounts Received." Go to Datasheet View and find the record for customer C900430, Cooper Fitness Center: What is the amount received from this customer? (Save this query as "Customer Cash Receipts before June 30.") 3. $1,698.25 b $2,309.75 c. $1,000.00 d. $68,831.00 e None of these How many records are shown in this query? Return to Design View. Change the JOIN properties between Retailer Customers and the Cash Receipts before June 30 query to show all records from Retailer Customers. (Click on the line linking the two, and select the appropriate radio button.) Return to Datasheet view. How many records are now shown in the query? Return to Design View. Next, calculate a new field that changes blanks to zeroes for the Amounts Received eld. Which function is designed specically to change nulls (blanks) to zeroes? a. NZ