Home

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 : 1
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens

Question No : 2
When creating a new table which method can be used to choose fields from standard databases and tables

Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above

Question No : 3
A database language concerned with the definition of the whole database structure and schema is ________

DCL
DML
DDL
All of above

Question No : 4
The command center of access file that appears when you create or open the MS Access database file.

Database Window
Query Window
Design View Window
Switchboard

Question No : 5
The size of Yes No field is always

1 bit
1 byte
1 character
1 GB

Question No : 6
This key uniquely identifies each record

primary key
key record
unique key
field name

Question No : 7
A small button with three dots usually displayed at the right of field properties box

Make button
Expression button
Build button
None of above

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