Microsoft Access MCQs with answers Page - 2

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. 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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

Q. Which leads you through the process of creating a table?

  • (A) Coach
  • (B) Relation
  • (C) Assistant
  • (D) Wizard

A

Admin • 833K Points
Coach

Q. Which control types is most often associated with a bound control?

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

Q. Which of the following database object hold data?

  • (A) Tables
  • (B) Queries
  • (C) Reports
  • (D) Forms

A

Admin • 833K Points
Coach

Q. You can set a controls border type to make the border invisible.

  • (A) No border
  • (B) Do not display
  • (C) Invisible
  • (D) Transparent

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.