Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Which of the following is use to view or print the data in organized manner?
a. Query
b. Report
c. Table
d. Form
Q. In a table to insert User\'s Voice, Data field should be
a. OLE Object
b. SoundField
c. VoiceField
d. Memo
Q. After creating the table which of the following is correct?
a. Fields cannot be added
b. Fields cannot be deleted
c. Fields can added but only once
d. Fields can added and deleted as needed
Q. Validation Rule in a field will
a. Checks the value entered when user leaves the field
b. Displays the value in specified format when user leaves the field
c. Defines the appearance for the text
d. There is no option of Validation Rule
Q. Query can be use to select data from
a. Single Table
b. Multiple Tables
c. Both A & B
d. None of above
Q. Data can be import into Access Database from
a. Word Files
b. Excel Files
c. PowerPoint Files
d. HTML Files
Q. What is the use of Referential Integrity in MS Access?
a. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
b. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
c. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
d. None of above
Q. Which of the following is the DBMS type
a. Flat File System
b. Hierarchical DBMS
c. Relational DMBS
d. All of the Above
Q. Which of the following relationship is not valid in MS Access ?
a. Many to Many
b. Many to Null
c. One to One
d. One to Many
Q. Which of the following Format supports for Data Type Yes/No?
a. Yes/No
b. True/False
c. On/Off
d. All of Above
Q. Queries can be created in Access by
a. Typing Queries in SQL View
b. Drag and Drop fields on Query Builder
c. Using Query Wizard
d. All of the Above
Q. Relationship can be establish between two tables by
a. Drag Primary key of a table into Foreign key of another table
b. Drag Foreign key of a table into Primary key of another table
c. Drag any key of a table into any key of another table
d. All of the above
Q. What is the use of Cascade Delete Option in MS Access?
a. It makes sure that all the records from the parent table and child table is deleted from selected database
b. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
c. It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
d. None of above