MS Access MCQ with Answers

position = “*ff*”

position = “O??icer”

position = ” ?ff*”

position = “O#r”

Search query

Cross tab query

Select query

Update query

display all customers with CustID from 10 to 100

display all customers with CustID above 10

display all customers with CustID below 100

display all customers with CustID from 11 to 99

By setting the input mask property to “yyyy/mm/dd”

By setting the format property to “yyyy/mm/dd”

By entering dates in yyyy, mm, dd order

none of the above

By setting required to ′Yes′

By using default value

By defining validation rule

By using format