Microsoft Access MCQ Questions with answers and solutions Page 10

Q. What determines a table’s sort order?

(A) Primary key
(B) Field order
(C) Field order
(D) AutoNumber field

💬 Discuss

✅ Correct Answer: (C) Field order

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:33 pm in Microsoft Access

Q. Which data type is better to use for storing the price of an item?

(A) Currency
(B) Number
(C) AutoNumber
(D) Text

💬 Discuss

✅ Correct Answer: (A) Currency

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:34 pm in Microsoft Access

Q. Which of the following Format supports for Data Type Yes/No?

(A) Yes/No
(B) True/False
(C) On/Off
(D) All of Above

💬 Discuss

✅ Correct Answer: (D) All of Above

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:34 pm in Microsoft Access

Q. The ________ Builder is an Access tool for selecting colors from a palette or creating custom colors.

(A) Color
(B) Palette
(C) Expression
(D) Property

💬 Discuss

✅ Correct Answer: (A) Color

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:35 pm in Microsoft Access

Q. Which function evaluates a “true/false” expression and then performs one of two actions?

(A) Is True
(B) IIF
(C) IF
(D) Case

💬 Discuss

✅ Correct Answer: (B) IIF

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:36 pm in Microsoft Access

Q. ________ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the

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

💬 Discuss

✅ Correct Answer: (C) Layout View

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:37 pm in Microsoft Access

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

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

💬 Discuss

✅ Correct Answer: (B) Criteria cannot be specified as an expression

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:37 pm in Microsoft Access

Q. The Table _________ Wizard analyzes a database and recommends changes for normalization.

(A) Normalization
(B) Cleanup
(C) Documenter
(D) Analyzer

💬 Discuss

✅ Correct Answer: (D) Analyzer

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:38 pm in Microsoft Access

Q. Which major database object stores all data?

(A) Table
(B) Record
(C) Query
(D) Field

💬 Discuss

✅ Correct Answer: (A) Table

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:38 pm in Microsoft Access

Q. The _________ field is used to hold a yes or no answer

(A) Logical
(B) Text
(C) Number
(D) Object

💬 Discuss

✅ Correct Answer: (A) Logical

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 09:40 pm in Microsoft Access

Previous
First
10
11
12
13
14
....
Last
Next

Jump to