MS Access MCQ Questions and solutions with explanations

1

To insert a graphic of your company's logo on a report

A) Click the image button on the toolbox and drag on the report to draw a place holder for the graphics B) You can't. Microsoft Access won't let you insert graphics files. C) Select Insert > Picture from the menu D) Select Tools > Insert Picture from the menu

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

2

In Access press ENTER to

A) Toggle the Navigation Pane B) Cycle between open windows C) Restore the selected minimized window when all windows are minimized D) Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

3

What happens when a user selects a record in a form and presses [Delete]?

A) The record is deleted in the form and from its source table. B) The record is deleted in the form, but not from its source table. C) The record is neither deleted in the form, nor from its source table. D) The record is not deleted in the form, but is deleted from its source table.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

4

Which of the following statement is true

A) Reports can be used to retrieve data from tables and calculate B) Queries can be printed in well formatted manner and presented as the information C) Queries can include calculated fields that do not exist in table D) Reports and forms are similar but forms are use to print but reports to display on screen only

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

5

DCL provides commands to perform actions like

A) Change the structure of tables B) insert, update or delete records and data values C) authorizing access and other control over database D) None of above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

6

In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)

A) CTRL+F B) CTRL+H C) SHIFT+F4 D) None of these

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

7

What do you mean by one to many relationship between Student and Class table?

A) One student can have many classes B) One class may have many student C) Many classes may have many students D) Many students may have many classes

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

8

Both conditions display on the same row in the design grid when ___operator is in use

A) OR B) IN C) AND D) LIKE

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

9

To duplicate a controls formatting you can use_______

A) Manager B) Wizard C) Painter D) Control

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

10

The checking operation performed on input data is called the

A) Validation of data B) Verification of data C) Cross check D) Control of data

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

MS Access MCQ Questions and solutions with explanations | MS Office