Microsoft Access MCQs with answers Page - 9

Here, you will find a collection of MCQ questions on Microsoft Access. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833K Points
Coach

Q. What do you call a primary key field included in another table?

  • (A) Index
  • (B) Child key
  • (C) Parent key
  • (D) Foreign key

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

Q. What do you call a collection of records matching parameters of a query?

  • (A) Dynaset
  • (B) Query
  • (C) Record
  • (D) Field

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

Q. Which control type do you use to create a calculated control?

  • (A) List box
  • (B) Text box
  • (C) Combo box
  • (D) Command button

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

Q. Which of the following is not a valid Data Type in MS Access?

  • (A) AutoNumber
  • (B) Currency
  • (C) Picture
  • (D) Memo

A

Admin • 833K Points
Coach

Q. In MS Access, which data type is appropriate to store large text and numbers?

  • (A) Text
  • (B) Memo
  • (C) OLE
  • (D) Large Text

A

Admin • 833K Points
Coach

Q. Which of the following is use to view or print the data in organized manner?

  • (A) Query
  • (B) Table
  • (C) Form
  • (D) Report

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.