MS Access MCQ Questions and solutions with explanations

31

The ability of a database to grow as the data tracking needs grow is its __________.

A) scalability B) expandability C) maintainability D) platform-independence

Discuss

Answer & Solution

Answer: Option A

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

32

Which of the following is not one of the methods available in the new query dialog box to create queries?

A) Design view B) Crosstab query wizard C) Simple query wizard D) Datasheet view

Discuss

Answer & Solution

Answer: Option D

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

33

Which of the following statements about calculated fields is NOT true?

A) A calculated field does not store data in a recordset. B) Calculated fields use an expression or formula as its data source. C) Data contained in a calculated field is created the first time a query is run. D) A calculated field can be created using the Expression Builder dialog box.

Discuss

Answer & Solution

Answer: Option C

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

34

What is the first step in creating a form or report with the form wizard or report wizard?

A) Selecting the fields that you want to appear in the form or report B) Selecting the underlying table or query on which you want to base the form or report C) Reading several screens of mostly useless information and clicking next D) Selecting how the form or report should be formatted

Discuss

Answer & Solution

Answer: Option B

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

35

In Access press PAGE UP

A) Move up one line B) Move up one page C) Exit the combo box or list box D) None of these

Discuss

Answer & Solution

Answer: Option B

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

36

Which of the following is a method to create a new table in MS Access?

A) Create table in Design View B) Create Table using wizard C) Create Table by Entering data D) All of above

Discuss

Answer & Solution

Answer: Option D

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

37

Which Form tool creates a new form that show both a form and datasheet views?

A) Form B) Form Wizard C) Multiple Item Form D) Split Form

Discuss

Answer & Solution

Answer: Option D

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

38

A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.

A) select B) summary C) parameter D) action

Discuss

Answer & Solution

Answer: Option D

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

39

A _______ name must be unique within a database

A) Table B) Field C) Record D) Character

Discuss

Answer & Solution

Answer: Option A

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

40

Queries can be created in Access by

A) Typing Queries in SQL View B) Drag and Drop fields on Query Builder C) Using Query Wizard D) All of the Above

Discuss

Answer & Solution

Answer: Option D

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

MS Access MCQ Questions and solutions with explanations | MS Office