Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. A ________ is a unit of information in a ________
a. record, field
b. field, record
c. data source, field
d. record, data source
Q. What do you call a primary key field included in another table?
a. Foreign key
b. Parent key
c. Child key
d. Index
Q. Which type of field is incremented automatically?
a. Auto Elevate
b. AutoNumber
c. Auto Increment
d. Auto Value
Q. Which object is used to create a form?
a. Tables and Queries
b. Tables only
c. Tables and reports
d. Queries and reports
Q. What determines a table’s sort order?
a. AutoNumber field
b. Index field
c. Field order
d. Primary key
Q. Which tool do you use to create a query object?
a. Database wizard
b. Simple filter wizard
c. Simple query wizard
d. Table query wizard
Q. Which of the following is not a view for interacting with a form object?
a. Datasheet view
b. Design view
c. Form view
d. Layout view
Q. What is the purpose of indexing?
a. To reduce table size
b. To speedup data search
c. both A and B
d. none of the above
Q. What is the full form of SQL?
a. Sophisticated Question List
b. Structured Question List
c. Structured Query Language
d. Small Query Length
Q. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
a. Text
b. AutoNumber
c. Number
d. Currency