MS Access MCQs

Question 1

In Access press . . . . . . . . to Move the selected control to the right (except controls that are part of a layout)

Accepted Answer

None of these

Answer

CTRL+C

Answer

CTRL+X

Answer

CTRL+V

Question 2

You can display a database object in design view by

Accepted Answer

Selecting the database object and clicking the design button on the database window

Answer

Opening the database object and clicking the view button on the toolbar

Answer

Selecting the database object and press Ctrl + V

Answer

Opening the database object and selecting Tools>Design view

Question 3

Queries in Access can be used as

Accepted Answer

Both A and B

Answer

view, change and analyze data in different ways

Answer

a source of records for forms and reports

Answer

Only A

Question 4

If you need to edit a relationship

Accepted Answer

Both of above

Answer

Right click the relationship line and choose Edit Relationship

Answer

Double click the relationship line

Answer

None of above

Question 5

Which of the following is not an action query?

Accepted Answer

make-table

Answer

add

Answer

delete

Answer

update

Question 6

An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.

Accepted Answer

3-tier

Answer

2-tier

Answer

4-tier

Answer

n-tier

Question 7

What is the use of Referential Integrity in MS Access?

Accepted Answer

It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

Answer

It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

Answer

It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table

Answer

None of above

Question 8

In Access to reduce the height of the selected control

Accepted Answer

None of these

Answer

SHIFT+RIGHT ARROW

Answer

SHIFT+DOWN ARROW

Answer

DOWN ARROW or CTRL+DOWN ARROW

Question 9

The content and application of the Search tool CANNOT be retained when you ______.

Accepted Answer

close an object

Answer

format an object

Answer

resize a column

Answer

use Datasheet View