Microsoft Access(Computer Aptitude ) Questions and answers for exam Preparation

Question 1. In Access, to Exit Office Access 2007Access

CTRL+N
CTRL+O
ALT+F4
None of these

Explanation:-

Answer: Option C. -> ALT+F4

Question 2. In Access press ALT+F4 to

Open a new database
Open an existing database
Exit Office Access 2007Access
None of these

Explanation:-

Answer: Option C. -> Exit Office Access 2007Access

Question 3. Press the following keys in Access to Open the Print dialog box from Print Preview

CTRL+P
P or CTRL+P
S
C or ESC

Explanation:-

Answer: Option B. -> P or CTRL+P

Question 4. In Access to Move down one page

F4 or ALT+DOWN ARROW
DOWN ARROW
PAGE DOWN
F9

Explanation:-

Answer: Option C. -> PAGE DOWN

Question 5. Press the following keys in Access to Cancel Print Preview or Layout Preview

CTRL+P
P or CTRL+P
S
C or ESC

Explanation:-

Answer: Option D. -> C or ESC

Question 6. The checking operation performed on input data is called the

Validation of data
Verification of data
Cross check
Control of data

Explanation:-

Answer: Option A. -> Validation of data

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

CTRL+F
CTRL+H
SHIFT+F4
None of these

Explanation:-

Answer: Option A. -> CTRL+F

Question 8. Which of the following is NOT a report section?

Report Header section
Summary section
Page header section
Details section

Explanation:-

Answer: Option B. -> Summary section

Question 9. When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.

Report
Table
Query
Tools

Explanation:-

Answer: Option C. -> Query

Question 10. How can you display the relationship in a database?

Select View > Relationship form the menu
Click the Relationship button on the toolbar
Select Edit >Relationship from the menu
All the above are true

Explanation:-

Answer: Option B. -> Click the Relationship button on the toolbar