MS Access MCQ Questions and solutions with explanations

81

The quickest way to add a field to the selected fields list is to double-click its field name in this list.

A) Find fields B) Search fields C) Search record D) Available fields

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

82

What is the difference between 'Open' and 'Open Exclusively'?

A) Open statement opens access database files and Open Exclusively opens database files of other program like Oracle B) Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed C) Both Open and Open Exclusively are same D) Open Exclusive command does not exist in MS Access

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

83

in MS Access, OLE Object Data type can store

A) Microsoft Word documents B) Microsoft Excel spreadsheets C) Sounds D) All of the Above

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

84

A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?

A) 1 B) ? C) r D) None

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

85

A relationship is created between how many tables?

A) One B) Two C) Three D) Any number

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

86

A form defines

A) Where data is placed on the screen B) The width of each field C) Both (A) and (B) D) All of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

87

Which of the following statements about criteria in a query is NOT true?

A) Criteria can contain wildcard characters. B) Criteria in a query selects or excludes certain records. C) Criteria cannot be specified as an expression. D) Multiple criteria can be specified using AND, OR, and relational operators.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

88

Which of the following field properties is an expression that specifies criteria or requirements for entering data?

A) Field Size B) Format C) Input Mask D) Validation Rule

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

89

Referential integrity cannot be set for _______________ relationships.

A) One-To-One B) Indeterminate C) One-To-Many D) Many-To-Many

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

90

When you add fields in ________, a Field List pane displays.

A) Design View B) Layout View C) Print Preview D) Report View

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

MS Access MCQ Questions and solutions with explanations | MS Office