Microsoft Access MCQs with answers Page - 2

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. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
  • (A) Update query
  • (B) Select query
  • (C) Cross tab query
  • (D) Search query
💬 Discuss
✅ Correct Answer: (B) Select query
📊 Microsoft Access
Q. How to make a date field DOB store the dates like “2020/12/31”?
  • (A) By setting the input mask property to “yyyy/mm/dd”
  • (B) By setting the format property to “yyyy/mm/dd”
  • (C) By entering dates in yyyy, mm, dd order
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (B) By setting the format property to “yyyy/mm/dd”
📊 Microsoft Access
Q. Which leads you through the process of creating a table?
  • (A) Coach
  • (B) Relation
  • (C) Assistant
  • (D) Wizard
💬 Discuss
✅ Correct Answer: (D) Wizard
📊 Microsoft Access
Q. Which control types is most often associated with a bound control?
  • (A) List box
  • (B) Text box
  • (C) Label
  • (D) Command button
💬 Discuss
✅ Correct Answer: (B) Text box
📊 Microsoft Access
Q. Which is not an option for customizing a datasheet window?
  • (A) Freeze one column
  • (B) Change one column\’s width
  • (C) Hide one column
  • (D) Change one row\’s height
💬 Discuss
✅ Correct Answer: (D) Change one row\’s height
📊 Microsoft Access
Q. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
  • (A) Data definition
  • (B) Data refinement
  • (C) Establishing relationship
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (A) Data definition
📊 Microsoft Access
Q. When creating a new table which method can be used to choose fields from standard databases and tables?
  • (A) Create Table by Entering data
  • (B) Create table in Design View
  • (C) Create Table using wizard
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Create Table using wizard
📊 Microsoft Access
Q. What does the show check box in query design window indicate?
  • (A) It indicates whether the field is to be displayed in query result or not
  • (B) It indicates whether the field names to be displayed in query result or not
  • (C) It indicates whether the field is to be used or not
  • (D) None of above
💬 Discuss
✅ Correct Answer: (A) It indicates whether the field is to be displayed in query result or not
📊 Microsoft Access
Q. Which of the following database object hold data?
  • (A) Tables
  • (B) Queries
  • (C) Reports
  • (D) Forms
💬 Discuss
✅ Correct Answer: (A) Tables
📊 Microsoft Access
Q. You can set a controls border type to make the border invisible.
  • (A) No border
  • (B) Do not display
  • (C) Invisible
  • (D) Transparent
💬 Discuss
✅ Correct Answer: (B) Do not display

Programming Categories

📱 Download Our App

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

Get it on Google Play