Home

Microsoft Access MCQ - Multiple Choice Question and Answer

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

Download Objective type questions of Microsoft Access PDF

Visit our PDF store

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