Home
Home >> Computer>> Softwares>> MS Office>> Microsoft Access

Microsoft Access MCQ Question with Answer

Microsoft Access MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download Microsoft Access MCQ Question Answer PDF

Try Microsoft Access Mock Test

Question No : 43
The database language that allows you to access or maintain data in a database

DCL
DML
DDL
None of above
View Answer   Discuss

Question No : 44
You can set a controls border type to make the border invisible.

Transparent
Invisible
Do not display
No border
View Answer   Discuss

Question No : 45
Referential integrity means

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
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
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
All of above
View Answer   Discuss

Question No : 46
A __ name must be unique within a database

Table
Field
Record
Character
View Answer   Discuss

Question No : 47
It is an association established between common fields of two tables.

line
relationship
primary key
records
View Answer   Discuss

Question No : 48
Which of the following is not a field type in Access

Memo
Hyperlink
OLE Object
Lookup Wizard
View Answer   Discuss

Question No : 49
How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

Query Wizard
Look up Wizard
Form Wizard
Report Wizard
View Answer   Discuss

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
MS Office set 1 30 Start
MS Office set 2 30 Start
MS Office set 3 30 Start
MS Office set 4 30 Start
MS Office set 5 30 Start
MS Office set 6 30 Start
MS Office set 7 30 Start
MS Office set 8 30 Start
MS Office set 9 30 Start
MS Office set 10 30 Start
MS Office set 11 30 Start
MS Office set 12 30 Start