Microsoft Access MCQs with answers Page - 12

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. Which of the following best describes the grouped report?

  • (A) A part of report that can be generated by the report wizard
  • (B) A report that displays data that has been sorted in ascending or descending order
  • (C) A report that displays data grouped by fields you specify
  • (D) None of a the above
💬 Discuss
✅ Correct Answer: (C) A report that displays data grouped by fields you specify

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

Q. Which of the following is a database management system?

  • (A) Ms-word
  • (B) Lotus 123
  • (C) Oracle
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Oracle

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

Q. A file containing relatively permanent data is

  • (A) Sequential file
  • (B) Master file
  • (C) Transaction file
  • (D) Random file
💬 Discuss
✅ Correct Answer: (B) Master file

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

Q. In a relational schema, each tuple is divided into fields called

  • (A) Relations
  • (B) Domains
  • (C) Queries
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (B) Domains

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

Q. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file?

  • (A) Tables
  • (B) Relations
  • (C) Tuple
  • (D) Both A and B
💬 Discuss
✅ Correct Answer: (D) Both A and B

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

Q. Which of the following database objects asks a question of information in a database and then displays the result?

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

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

Q. Which Form tool creates a new form that show both a form and datasheet views?

  • (A) Split Form
  • (B) Multiple Item Form
  • (C) Form Wizard
  • (D) Form
💬 Discuss
✅ Correct Answer: (A) Split Form

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

Q. In the second sub-form wizard dialog box you specify the table to use as the data source and the

  • (A) Content from the selected form
  • (B) Fields from the selected table
  • (C) Form from the selected table
  • (D) Records from the selected form
💬 Discuss
✅ Correct Answer: (B) Fields from the selected table

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

Q. Which of the following is not an action query?

  • (A) Update
  • (B) Make-table
  • (C) Delete
  • (D) Add
💬 Discuss
✅ Correct Answer: (D) Add

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

Q. Which of the following Data Type is used to store picture in MS Access?

  • (A) Picture cannot be stored
  • (B) Memo
  • (C) OLE Object
  • (D) Picture
💬 Discuss
✅ Correct Answer: (C) OLE Object

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