MS Access MCQ with Answers

Field

Record

Query

Dynaset

Search query

Cross tab query

Select query

Update query

zipcode, firstname, lastname

firstname, lastname, zipcode

zipcode, lastname, firstname

can ′t sort by multiple fields

multiplies the contents of detail and product fields by 1.3

First divides detail by product and then multiplies by 1.3

multiplies the contents of detail in the product table by 1.3

multiplies the contents of product in the detail table by 1.3

address = “K”

address = “K*”

address = “K?”

address = “K#”