Multiple Choice
If you misspell a field name in a calculated field of a query and then run the query,Access will:
A) display a dialog box asking for a value for the field.
B) substitute a zero value for the field and proceed with the calculation.
C) substitute a value of NULL for the field and proceed with the calculation.
D) stop running the query and produce no results.
Correct Answer:

Verified
Correct Answer:
Verified
Q3: When the results of using the COUNT
Q4: When using date data,the date is surrounded
Q5: When creating a calculated field using field
Q6: The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in
Q7: Pmt is an example of a(n)_.<br>A) parameter<br>B)
Q9: The order of operations specifies that any
Q10: A(n)_ function performs a calculation on an
Q11: Which of the following is NOT an
Q12: You can use Pmt to find the
Q13: What is the value of =4+3*2^2?<br>A) 16<br>B)