Microsoft Access MCQs with answers Page - 9

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. What do you call a primary key field included in another table?
  • (A) Index
  • (B) Child key
  • (C) Parent key
  • (D) Foreign key
💬 Discuss
✅ Correct Answer: (D) Foreign key
📊 Microsoft Access
Q. What is the purpose of indexing?
  • (A) To reduce table size
  • (B) To speedup data search
  • (C) Both A and B
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (B) To speedup data search
📊 Microsoft Access
Q. What do you call a collection of records matching parameters of a query?
  • (A) Dynaset
  • (B) Query
  • (C) Record
  • (D) Field
💬 Discuss
✅ Correct Answer: (A) Dynaset
📊 Microsoft Access
Q. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
  • (A) Display all customers with CustID from 10 to 100
  • (B) Display all customers with CustID above 10
  • (C) Display all customers with CustID below 100
  • (D) Display all customers with CustID from 11 to 99
💬 Discuss
✅ Correct Answer: (D) Display all customers with CustID from 11 to 99
📊 Microsoft Access
Q. After right click the field selector button, which do you choose to delete a field in design view?
  • (A) Remove rows
  • (B) Remove field
  • (C) Delete rows
  • (D) Delete field
💬 Discuss
✅ Correct Answer: (C) Delete rows
📊 Microsoft Access
Q. Which control type do you use to create a calculated control?
  • (A) List box
  • (B) Text box
  • (C) Combo box
  • (D) Command button
💬 Discuss
✅ Correct Answer: (B) Text box
📊 Microsoft Access
Q. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
  • (A) Datasheet border
  • (B) Vertical gridline
  • (C) Datasheet underline
  • (D) Column Header underline
💬 Discuss
✅ Correct Answer: (D) Column Header underline
📊 Microsoft Access
Q. Which of the following is not a valid Data Type in MS Access?
  • (A) AutoNumber
  • (B) Currency
  • (C) Picture
  • (D) Memo
💬 Discuss
✅ Correct Answer: (C) Picture
📊 Microsoft Access
Q. In MS Access, which data type is appropriate to store large text and numbers?
  • (A) Text
  • (B) Memo
  • (C) OLE
  • (D) Large Text
💬 Discuss
✅ Correct Answer: (B) Memo
📊 Microsoft Access
Q. Which of the following is use to view or print the data in organized manner?
  • (A) Query
  • (B) Table
  • (C) Form
  • (D) Report
💬 Discuss
✅ Correct Answer: (D) Report

Programming Categories

📱 Download Our App

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

Get it on Google Play