Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. The database language that allows you to access or maintain data in a database
a. DCL
b. DML
c. DDL
d. None of above
Q. Referential integrity means
a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
b. Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
c. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
d. All of above
Q. It is an association established between common fields of two tables.
a. line
b. relationship
c. primary key
d. records
Q. Which of the following is not a field type in Access
a. Memo
b. Hyperlink
c. OLE Object
d. Lookup Wizard
Q. When entering field name, how many characters you can type in maximum?
a. 60
b. 64
c. 68
d. Any number of character
Q. It is a database object to view, change, and analyze data in different ways
a. query
b. form
c. report
d. None of the above
Q. Which of the following creates a drop down list of values to choose from a list?
a. OLE Object
b. Hyperlink
c. Memo
d. Lookup Wizard
Q. To achieve AND effect when you are entering criteria in a query design window
a. write criteria values vertically one in a row
b. write criteria values horizontally
c. Write criteria values in same field separated with AND
d. Write criteria values in same field separated with &
Q. A search value can be an exact value or it can be
a. Logical Operator
b. Relationship
c. Wild card character
d. Comparison operation
Q. What is a form in MS Access
a. It is a printed page where users will write their data to fill it up
b. It is an input screen designed to make the viewing and entering data easier
c. This is an important part of database used by analysts to draw conclusions
d. All of above
Q. You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
a. Clicking
b. Right clicking
c. Double clicking
d. None of the above
Q. It is a sign or symbol that specifies, operator, and values that produce a result
a. operator
b. query
c. expression
d. None of the above
Q. We can remove a relationship defined between two tables by
a. From Edit menu choose Delete Relationship
b. Select the relationship line and press Delete
c. Choose Delete option from Relationship menu
d. All of above
Q. Unlike text data type, this can store up to maximum of 65, 535 characters.
a. memo
b. data/time
c. number
d. All of above