Microsoft Access MCQs with answers Page - 8

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. It is a database object to view, change, and analyze data in different ways

  • (A) Report
  • (B) Query
  • (C) Form
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (B) Query

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

Q. You can automatically include all of the field in a table in a query by_________ a strike that appear list box in query design view

  • (A) Right clicking
  • (B) Double clicking
  • (C) Clicking
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (B) Double clicking

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

Q. Which field type can store photos?

  • (A) OLE
  • (B) Hyperlink
  • (C) Both of these can be used
  • (D) Access tables can’t store photos
💬 Discuss
✅ Correct Answer: (A) OLE

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

Q. What is the difference between ‘Open’ and ‘Open Exclusively’?

  • (A) Open statement opens access database files and Open Exclusively opens database files of other program like Oracle
  • (B) Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
  • (C) Both Open and Open Exclusively are same
  • (D) Open Exclusive command does not exist in MS Access
💬 Discuss
✅ Correct Answer: (B) Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed

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

Q. Which of the following statement is true?

  • (A) Foreign key fields don’t allow duplicate values
  • (B) In primary key field you can enter duplicate value
  • (C) In an indexed field you may or may not enter duplicate value depending upon setting
  • (D) All statements are true
💬 Discuss
✅ Correct Answer: (C) In an indexed field you may or may not enter duplicate value depending upon setting

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

Q. Both conditions display on the same row in the design grid when ________operator is in use

  • (A) LIKE
  • (B) AND
  • (C) IN
  • (D) OR
💬 Discuss
✅ Correct Answer: (B) AND

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

Q. A database can be best described as

  • (A) Organized collection of data
  • (B) Useful presentation of data
  • (C) Graphical representation of data
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (A) Organized collection of data

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

Q. Database Management Systems are featured with:

  • (A) The facility to easy editing, spelling check, auto pagination, lay out and printing reports
  • (B) The ability to store large amount of data to facilitate easy update, sort and retrieval
  • (C) The ability to calculate efficiently with the help of built-in functions and analyze
  • (D) All of above
💬 Discuss
✅ Correct Answer: (B) The ability to store large amount of data to facilitate easy update, sort and retrieval

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

Q. A composite key is

  • (A) Is a foreign key that uniquely identifies records
  • (B) Made up of two or more fields to uniquely identify records
  • (C) The primary key with AutoNumber as the field type
  • (D) Required when a table does not have any unique fields in it
💬 Discuss
✅ Correct Answer: (B) Made up of two or more fields to uniquely identify records

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

Q. In databases, Locking level is also called as

  • (A) Dead lock
  • (B) X lock
  • (C) S lock
  • (D) Granularity
💬 Discuss
✅ Correct Answer: (D) Granularity

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