Microsoft Access MCQs with answers Page - 5

Dear candidates you will find MCQ questions of Microsoft Access here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 Microsoft Access
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
📊 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
📊 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
📊 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
📊 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
📊 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
📊 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
📊 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
📊 Microsoft Access
Q. Database properties do NOT include _________.
  • (A) Size
  • (B) Company
  • (C) Author
  • (D) Title
💬 Discuss
✅ Correct Answer: (A) Size
📊 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

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play