Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. To delete records or perform calculations on a table, the best tool to use is a __________.
a. query
b. filter
c. form
d. report
Q. To print information from a table, the __________ tool is the best choice.
a. form
b. report
c. query
d. macro
Q. To store your picture in a database requires a(n) __________ field.
a. BLOB
b. text
c. image
d. logical
Q. SQL stands for __________.
a. Standard Query Language
b. Structured Query Language
c. Simplified Query Language
d. Static Query Language
Q. What are the different views to display a table
a. Datasheet view
b. Design view
c. Pivote table & pivot chart view
d. All of above
Q. Which of the following creates a drop down list of values to choose from?
a. Ole object
b. Hyperlink
c. Memo
d. Lookup wizard
Q. The command center of access file that appears when you create or open the MS Access database file.
a. Database window
b. Query window
c. Design view window
d. Switchboard
Q. In a database table, the category of information is called __________
a. Tuple
b. Field
c. Record
d. All of above
Q. It is an association established between common
a. Line
b. Relationship
c. Primary key
d. Records
Q. This is the stage in database design where one gathers and list all the necessary fields for the database project.
a. Data definition
b. Data refinement
c. Establishing relationship
d. None of the above
Q. Which of the following statement is true?
a. Foreign key fields don\'t allow duplicate values
b. In primary key field you can enter duplicate value
c. In an indexed field you may or may not enter duplicate value depending upon setting
d. All statements are true
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