Microsoft Access MCQs with answers Page - 13

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

Q. To create a table in Access

  • (A) Database should be created before create table
  • (B) Table can be created using Table Templates
  • (C) There must be at least one Primary key in a table
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (D) All of the above

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

Q. In MS Access, Field Value may contain

  • (A) Text
  • (B) Date & Time
  • (C) Picture
  • (D) All of the Above
💬 Discuss
✅ Correct Answer: (D) All of the Above

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

Q. What is the use of Cascade Delete Option in MS Access?

  • (A) It makes sure that all the records from the parent table and child table is deleted from selected database
  • (B) It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
  • (C) It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
  • (D) None of above
💬 Discuss
✅ Correct Answer: (B) It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted

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

Q. By default, what is the name of a new module in the Modules folder of the Project pane called?

  • (A) Module1
  • (B) New Module
  • (C) Module
  • (D) Bas1
💬 Discuss
✅ Correct Answer: (A) Module1

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

Q. Which of the following statements about a tab control in a form is incorrect?

  • (A) It defines a layered space
  • (B) It can contain only one object
  • (C) It is created in multipage forms
  • (D) It is a control object
💬 Discuss
✅ Correct Answer: (B) It can contain only one object

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

Q. Which of the following statements regarding charts is incorrect?

  • (A) It can be linked to the object in which it is placed
  • (B) It is a control linked to a data source
  • (C) It can be inserted into a form only
  • (D) It can be designed as a standalone-object
💬 Discuss
✅ Correct Answer: (C) It can be inserted into a form only

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

Q. Which of the following is the file extension for an Extensible Markup Language?

  • (A) XSD
  • (B) XML
  • (C) HTML
  • (D) EML
💬 Discuss
✅ Correct Answer: (B) XML

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

Q. Which part of the IIF expression is the action performed if the true condition exists?

  • (A) Third
  • (B) Second
  • (C) First
  • (D) Inner
💬 Discuss
✅ Correct Answer: (B) Second

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

Q. The three parts of an IIF function are separated by ________.

  • (A) Commas
  • (B) Semicolons
  • (C) Asterisks
  • (D) Dashes
💬 Discuss
✅ Correct Answer: (A) Commas

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

Q. The Allow ________ property controls whether new records can be added through the form.

  • (A) Data Entry
  • (B) Deletions
  • (C) Edits
  • (D) Additions
💬 Discuss
✅ Correct Answer: (D) Additions

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

Programming Categories

📱 Download Our App

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

Get it on Google Play