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

Computer Aptitude

MICROSOFT ACCESS MCQs

Total Questions : 168 | Page 14 of 17 pages

Question 131. What can be the maximum length of a text field ?

Discuss Question

Answer: Option B. -> 255
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 132. Which kind of query that displays its own dialog box prompting you for entering information before executing ?

Select Query
Crosstab Query
Parameter Query
Dialog Query

Discuss Question

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

Question 133. The_____________ button on the tool box display data from a related table

Sub form sub report
Relationships
Select objects
More controls

Discuss Question

Answer: Option A. -> Sub form sub report
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 134. While creating relationship using mouse, how the the mousepointer looks like?

A thick plus sign
A thin plus sign
An outlined rectangle
Arrow with Plus sign

Discuss Question

Answer: Option C. -> An outlined rectangle
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 135. Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ?

RANGE
IN
ALL
AND

Discuss Question

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

Question 136. Thecommandcenter of Access File thatappearswhen wecreateor open the MSAccess databaseFile.

Database Window
Query Window
Design View Window
Switchboard

Discuss Question

Answer: Option A. -> Database Window
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 137. What Cascade Delete option is used for ?

It is used to delete all the records of all tables in a database
It repeats the recent delete operation to all the records of current table
It ensures that all the related records will be deleted automatically when the record from parent table is deleted.
It is used to delete all the records of related tables in a database

Discuss Question

Answer: Option C. -> It ensures that all the related records will be deleted automatically when the record from parent table is deleted.
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Question 138. The columns in a microsoft access table are also called _______