Microsoft Access MCQ Questions with answers and solutions Page 5

Q. Which is not an option for Filter on a text field?

(A) End With
(B) Contains
(C) Between
(D) Begins With

💬 Discuss

✅ Correct Answer: (C) Between

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

Q. A ________ is a major database object used to display information in an attractive, easy-to-read screen format.

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

💬 Discuss

✅ Correct Answer: (D) Form

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

Q. A ________ is a major database object used to display information in a printable page format.

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

💬 Discuss

✅ Correct Answer: (B) Report

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

Q. All attachment fields display as a(n) ________ in Datasheet View.

(A) Paperclip
(B) Thumb tack
(C) Button
(D) Icon

💬 Discuss

✅ Correct Answer: (A) Paperclip

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

Q. A DBMS that runs on many different operating systems is said to be _________.

(A) Distributed
(B) Platform independent
(C) Robust
(D) Scalable

💬 Discuss

✅ Correct Answer: (B) Platform independent

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

Q. Using the keyword _________ will return records in which the field value equals a defined text.

(A) Not
(B) Like
(C) Is Null
(D) Between

💬 Discuss

✅ Correct Answer: (B) Like

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

Q. Referential integrity can be enforced if both _________ belong to the same Microsoft Access database.

(A) Tables
(B) Records
(C) Fields
(D) Queries

💬 Discuss

✅ Correct Answer: (A) Tables

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

Q. Which of the following field properties enforces the use of parentheses when keying an area code?

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

💬 Discuss

✅ Correct Answer: (B) Input Mask

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

Q. Database properties do NOT include _________.

(A) Size
(B) Company
(C) Author
(D) Title

💬 Discuss

✅ Correct Answer: (A) Size

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

Q. The Search tool is best used when searching for _________ data.

(A) Formatted
(B) Unique
(C) Multiple
(D) Simple

💬 Discuss

✅ Correct Answer: (D) Simple

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

Previous
First
5
6
7
8
9
....
Last
Next

Jump to