MS Access MCQ Questions and solutions with explanations

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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.

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

9.
To duplicate a controls formatting you can use_______

A. Manager

B. Wizard

C. Painter

D. Control

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MS Access MCQ Questions and solutions with explanations | MS Office

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

Answer & Solution

2. In Access press ENTER to

Answer & Solution

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

Answer & Solution

4. Which of the following statement is true

Answer & Solution

5. DCL provides commands to perform actions like

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

9. To duplicate a controls formatting you can use_______

Answer & Solution

10. The checking operation performed on input data is called the

Answer & Solution

Read More Section(MS Access)

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

2.
In Access press ENTER to

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

4.
Which of the following statement is true

5.
DCL provides commands to perform actions like

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

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

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

9.
To duplicate a controls formatting you can use_______

10.
The checking operation performed on input data is called the