MS Access MCQ Questions and solutions with explanations

31

Which criteria return only those addresses beginning with the letter "K"?

A) address = "K" B) address = "K*" C) address = "K?" D) address = "K#"

Discuss

Answer & Solution

Answer: Option B

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

32

Which of the following database object is created first before any other created?

A) Table B) Form C) Report D) Query

Discuss

Answer & Solution

Answer: Option A

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

33

Which function evaluates a "true/false" expression and then performs one of two actions?

A) Case B) IF C) IIF D) IsTrue

Discuss

Answer & Solution

Answer: Option C

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

34

A part of database that stores complete information about an entity such as employee, sales, orders etc.

A) File B) Record C) Field D) Query

Discuss

Answer & Solution

Answer: Option B

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

35

The procedure for selecting multiple controls on a report?

A) Hold down the Shift key as you click each object that you want to select B) If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls C) Hold down the Ctrl key as you click each object that you want to select D) All of these above are true

Discuss

Answer & Solution

Answer: Option A

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

36

After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

A) You need to delete the whole tablThere is no method to remove a particular field only. B) Delete all the fields from third downwards and reenter the required fields again. C) Select the third column in datasheet view then Delete D) Select the third row in table design view then Delete

Discuss

Answer & Solution

Answer: Option D

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

37

What is an index?

A) A wizard that creates a functional database structure based on the user's selections B) A widely recognized naming convention for database objects C) A sort order for records, which is identified in the table design D) A set of relationship rules that enforce defined database relationships

Discuss

Answer & Solution

Answer: Option C

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

38

Which of the following is NOT a report section?

A) Report Header section B) Summary section C) Page header section D) Details section

Discuss

Answer & Solution

Answer: Option B

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

39

What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

A) A relationship is created B) Edit relationship dialog box appears C) Error occurs D) Nothing happens

Discuss

Answer & Solution

Answer: Option B

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

40

In table design view what are the first column of buttons used for

A) Indicate Primary Key B) Indicate Current Row C) Both of above D) None of above

Discuss

Answer & Solution

Answer: Option C

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

MS Access MCQ Questions and solutions with explanations | MS Office