Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. What do you call a collection of records matching parameters of a query?
a. Field
b. Record
c. Query
d. Dynaset
Q. Which query do you use to answer the question "Which employees earn more than $5000 a month"?
a. Search query
b. Cross tab query
c. Select query
d. Update query
Q. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
a. zipcode, firstname, lastname
b. firstname, lastname, zipcode
c. zipcode, lastname, firstname
d. can’t sort by multiple fields
Q. What does the expression [detail] ! [product] * 1.30 do?
a. multiplies the contents of detail and product fields by 1.3
b. First divides detail by product and then multiplies by 1.3
c. multiplies the contents of detail in the product table by 1.3
d. multiplies the contents of product in the detail table by 1.3
Q. Which criteria return only those addresses beginning with the letter "K"?
a. address = "K"
b. address = "K*"
c. address = "K?"
d. address = "K#"
Q. Which criteria do not return the position "Officer" as a match?
a. position = "*ff*"
b. position = "O??icer"
c. position = " ?ff*"
d. position = "O#r"
Q. Which query do you use to answer the question "What is the average salary of the employees"?
a. Search query
b. Cross tab query
c. Select query
d. Update query
Q. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
a. display all customers with CustID from 10 to 100
b. display all customers with CustID above 10
c. display all customers with CustID below 100
d. display all customers with CustID from 11 to 99
Q. How to make a date field DOB store the dates like "2002/10/17" ?
a. By setting the input mask property to "yyyy/mm/dd"
b. By setting the format property to "yyyy/mm/dd"
c. By entering dates in yyyy, mm, dd order
d. none of the above