Microsoft Access MCQ Question with Answer

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

Question No : 71
If you write criteria values vertically (one in a row) it will mean

OR conditions

AND conditions

NOT condition

None of above

Question No : 72
Both conditions display on the same row in the design grid when ___operator is in use

AND

Question No : 73
Which of the following store command to retrieve data from database?

Forms

Reports

Queries

Tables

Question No : 74
DCL provides commands to perform actions like

Change the structure of tables

insert, update or delete records and data values

authorizing access and other control over database

None of above

Question No : 75
Microsoft Access is a

RDBMS

OODBMS

ORDBMS

Network database model

Question No : 76
If you need to edit a relationship

Right click the relationship line and choose Edit Relationship

Double click the relationship line

Both of above

None of above

Question No : 77
Which of the following statement is true?

Foreign key fields dont allow duplicate values

In primary key field you can enter duplicate value

In an indexed field you may or may not enter duplicate value depending upon setting

All statements are true

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.