MS Access Database Mcqs - Set 2

1)   Which kind of query that displays its own dialog box prompting you for entering information before executing ?

a. Select Query
b. Crosstab Query
c. Parameter Query
d. Dialog Query
Answer  Explanation 

ANSWER: Parameter Query

Explanation:
No explanation is available for this question!


2)   What is a form that we can create in MS Access ?

a. It is used to take printout of a form from Access Tables.
b. It is an input screen for viewing and entering data.
c. It is used for storing special data other than text (e.g photo)
d. It is optional. We can use Report instead of Form
Answer  Explanation 

ANSWER: It is an input screen for viewing and entering data.

Explanation:
No explanation is available for this question!


3)   What Cascade Delete option is used for ?

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

ANSWER: It ensures that all the related records will be deleted automatically when the record from parent table is deleted.

Explanation:
No explanation is available for this question!


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

a. RANGE
b. IN
c. ALL
d. AND
Answer  Explanation 

ANSWER: ALL

Explanation:
No explanation is available for this question!


5)   The_____________ button on the tool box display data from a related table

a. Sub form sub report
b. Relationships
c. Select objects
d. More controls
Answer  Explanation 

ANSWER: Sub form sub report

Explanation:
No explanation is available for this question!


6)   Thecommandcenter of Access File thatappearswhen wecreateor open the MSAccess databaseFile.

a. Database Window
b. Query Window
c. Design View Window
d. Switchboard
Answer  Explanation 

ANSWER: Database Window

Explanation:
No explanation is available for this question!


7)   While creating relationship using mouse, how the the mousepointer looks like?

a. A thick plus sign
b. A thin plus sign
c. An outlined rectangle
d. Arrow with Plus sign
Answer  Explanation 

ANSWER: An outlined rectangle

Explanation:
No explanation is available for this question!


8)   The columns in a microsoft access table are also called _______

a. Rows
b. Records
c. Fields
d. Columns
Answer  Explanation 

ANSWER: Fields

Explanation:
No explanation is available for this question!


9)   how can you define a field so that when entering data ##### is displayed?

a. Input Mask
b. Validation Rule
c. Indexed
d. Ime Mode
Answer  Explanation 

ANSWER: Input Mask

Explanation:
No explanation is available for this question!


10)   In the context of Microsoft Access, which of the following statement is true?

a. Reports are used to retrieve andcalculate data from tables
b. Queries can be printed 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  Explanation 

ANSWER: Queries can include calculated fields that do not exist in table

Explanation:
No explanation is available for this question!