Microsoft Access MCQs with answers Page - 15

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. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?

  • (A) tex
  • (B) tbc
  • (C) txb
  • (D) txt
💬 Discuss
✅ Correct Answer: (D) txt

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

Q. The ________ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.

  • (A) Stock
  • (B) Financial
  • (C) Portfolio
  • (D) MSN Money
💬 Discuss
✅ Correct Answer: (B) Financial

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

Q. Which of the following queries prompts users for input data by displaying dialog boxes?

  • (A) Update
  • (B) Parameter
  • (C) Delete
  • (D) Append
💬 Discuss
✅ Correct Answer: (B) Parameter

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

Q. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records the second has 8. With using a right outer join, how many records will the resulting recordset have?

  • (A) 4
  • (B) 8
  • (C) 24
  • (D) Can not say
💬 Discuss
✅ Correct Answer: (C) 24

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

Q. In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?

  • (A) The join line but not the relationship between the two tables
  • (B) The relationship between the two tables globally
  • (C) The primary key of the first table
  • (D) The relationship between the two tables locally
💬 Discuss
✅ Correct Answer: (D) The relationship between the two tables locally

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

Q. The page count of a report can be determined by clicking the ________ button.

  • (A) Last Page
  • (B) Next
  • (C) Previous
  • (D) First Page
💬 Discuss
✅ Correct Answer: (A) Last Page

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

Q. Which of the following database objects can have more than one Group Header/Footer section?

  • (A) Tables
  • (B) Reports
  • (C) Queries
  • (D) Forms
💬 Discuss
✅ Correct Answer: (B) Reports

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

Q. Which of the following is NOT possible when printing Forms?

  • (A) Print page 1, 3, and 5
  • (B) Print pages 1 through 5
  • (C) Print selected records
  • (D) Print only the third record
💬 Discuss
✅ Correct Answer: (A) Print page 1, 3, and 5

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

Q. _________ are documents that when filled in create records.

  • (A) Queries
  • (B) Tables
  • (C) Reports
  • (D) Forms
💬 Discuss
✅ Correct Answer: (D) Forms

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

Q. To print information from a table, the _________ tool is the best choice.

  • (A) Macro
  • (B) Query
  • (C) Report
  • (D) Form
💬 Discuss
✅ Correct Answer: (C) Report

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:25 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