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.

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