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

Computer Aptitude

MICROSOFT ACCESS MCQs

Total Questions : 168 | Page 15 of 17 pages

Question 141. In the context of Microsoft Access, which of the following statement is true?

Reports are used to retrieve andcalculate data from tables
Queries can be printed and presented as the information
Queries can include calculated fields that do not exist in table
Reports and forms are similar but forms are use to print but reports to display on screen only

Discuss Question

Answer: Option C. -> Queries can include calculated fields that do not exist in table
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 142. Which of the following is not a field type in Microsoft Access ?

Memo
Hyperlink
Ole Object
Lookup Wizard

Discuss Question

Answer: Option D. -> Lookup Wizard
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 143. The upper part of the query design window in MS Access has two parts shows ____________

Fields name with field size
Fields name with relationships
Fields and Criteria
Sorting Options

Discuss Question

Answer: Option B. -> Fields name with relationships
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 144. To define AND condition while entering criteria in a query design window we write _______

Criteria values vertically one in a row
Criteria values horizontally
Write criteria values separated by AND
Write criteria values using & ( anchor and ) sign

Discuss Question

Answer: Option B. -> Criteria values horizontally
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 145. Which feature is used to duplicate a control's formatting ?

Manager
Wizard
Painter
Control

Discuss Question

Answer: Option C. -> Painter
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 146. While creating relationship, what happens when you releasemousepointer after you drop the primary key of a table into foreign key of another table?

A relationship is created
Edit relationship dialog boxappears
A connector symbol is created
A connecting Line is visible

Discuss Question

Answer: Option B. -> Edit relationship dialog boxappears
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 147. Which of the following is not a type of relationship that can be applied inAccess database?

One to One
One to Many
Many to Many
All of above

Discuss Question

Answer: Option D. -> All of above
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 148. Which of the following is a method tocreatea new table inMS Access?

Using Design View
CreateTable Wizard
Directly Entering Data
All of Above

Discuss Question

Answer: Option D. -> All of Above
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 149. What is the role of Cascade Update option ?

It says do not change the value in the primary key field if that record has related records in another table
It means change all the related records in child tables if the record in parent table is changed
Both A and B
None of these

Discuss Question

Answer: Option C. -> Both A and B
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 150. If you write criteria values one in a row in query design window, that means you are specifying _____