Question

10. How many records are shown in this query (Customer Sales before June 30)? 11. 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 field 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 field 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.") a. $1,698.25 b. $2,309.75 c. $1,000.00 d. $68,831.00 e. None of these 12. How many records are shown in this query? 13. 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? 14. Return to Design View. Next, calculate a new field that changes blanks to zeroes for the Amounts Received field. Which function is designed specifically to change nulls (blanks) to zeroes? a. NZ

          10. How many records are shown in this query (Customer Sales before June 30)?
11. 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 field 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 field 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.")
a. $1,698.25
b. $2,309.75
c. $1,000.00
d. $68,831.00
e. None of these
12. How many records are shown in this query?
13. 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?
14. Return to Design View. Next, calculate a new field that changes blanks to zeroes for the Amounts
Received field. Which function is designed specifically to change nulls (blanks) to zeroes?
a. NZ

10. How many records are shown in this query (Customer Sales before June 30)?
11. 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 field 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 field 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.")
a. 1,698.25
b.2,309.75
c. 1,000.00
d.68,831.00
e. None of these
12. How many records are shown in this query?
13. 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?
14. Return to Design View. Next, calculate a new field that changes blanks to zeroes for the Amounts
Received field. Which function is designed specifically to change nulls (blanks) to zeroes?
a. NZ

Added by Jesse S.

Question

Please give Ace some feedback