Microsoft Access MCQs with answers Page - 17

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. Cascade update option
  • (A) Means change all the related records in child tables if the record in parent table is changed
  • (B) Means do not change the value in the primary key field if that record has related records in another table
  • (C) Both of above
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Both of above
📊 Microsoft Access
Q. A search value can be an exact value or it can be
  • (A) Comparison operation
  • (B) Wild card character
  • (C) Relationship
  • (D) Logical Operator
💬 Discuss
✅ Correct Answer: (B) Wild card character
📊 Microsoft Access
Q. The_______ operator will cause a record to be selected only if two or more conditions are satisfied
  • (A) And
  • (B) Range
  • (C) If or
  • (D) Or
💬 Discuss
✅ Correct Answer: (A) And
📊 Microsoft Access
Q. It is a query that when run displays its own dialog box prompting you for information, such as
  • (A) Append
  • (B) Parameter
  • (C) Crosstab
  • (D) Select
💬 Discuss
✅ Correct Answer: (B) Parameter
📊 Microsoft Access
Q. A part of database that stores only one type of data is
  • (A) Record
  • (B) Query
  • (C) Field
  • (D) Report
💬 Discuss
✅ Correct Answer: (C) Field
📊 Microsoft Access
Q. Which of the following can be an example of a database?
  • (A) Address book of all the suppliers of a company
  • (B) Salary sheet of all the employees of a company
  • (C) Records of daily sales transactions of a company
  • (D) All of above
💬 Discuss
✅ Correct Answer: (D) All of above
📊 Microsoft Access
Q. Which of the following is not a database application?
  • (A) Access
  • (B) FoxPro
  • (C) Flash
  • (D) dBase
💬 Discuss
✅ Correct Answer: (C) Flash
📊 Microsoft Access
Q. Which is the valid data type in Access?
  • (A) Currency
  • (B) Text
  • (C) Number
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (D) All of the above
📊 Microsoft Access
Q. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
  • (A) By using format
  • (B) By defining validation rule
  • (C) By using default value
  • (D) By setting required to ‘Yes’
💬 Discuss
✅ Correct Answer: (B) By defining validation rule
📊 Microsoft Access
Q. Which function cannot be used for calculated controls in a report?
  • (A) COUNT
  • (B) MPT
  • (C) AVG
  • (D) SUM
💬 Discuss
✅ Correct Answer: (B) MPT

Programming Categories

📱 Download Our App

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

Get it on Google Play