Microsoft Access MCQs with answers Page - 4

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 is an index?

  • (A) A set of relationship rules that enforce defined database relationships
  • (B) A sort order for records, which is identified in the table design
  • (C) A widely recognized naming convention for database objects
  • (D) A wizard that creates a functional database structure based on the user’s selections

A

Admin • 833K Points
Coach

Q. When you add fields in ________, a Field List pane displays.

  • (A) Report View
  • (B) Print Preview
  • (C) Layout View
  • (D) Design View

A

Admin • 833K Points
Coach

Q. Which report section only prints one time at the end of the report?

  • (A) Report Header
  • (B) Page Footer
  • (C) Page Header
  • (D) Report Footer

A

Admin • 833K Points
Coach

Q. Which of the following statements about tab order setting is NOT true?

  • (A) The default tab order setting can be altered by moving the controls in the Design View
  • (B) The tab order setting is usually right-to-left and top-to-bottom
  • (C) The tab order setting determines the movement of the insertion point through a form
  • (D) The actual tab order setting for a form can be used in the Form View

A

Admin • 833K Points
Coach

Q. Which mode sizes an image to fit the control while maintaining the proportions of the original image?

  • (A) Zoom
  • (B) Stretch
  • (C) Fit
  • (D) Clip

A

Admin • 833K Points
Coach

Q. Referential integrity cannot be set for _________ relationships.

  • (A) One-To-One
  • (B) One-To-Many
  • (C) Indeterminate
  • (D) Many-To-Many

A

Admin • 833K Points
Coach

Q. Which of the following statements about PivotChart View is NOT true?

  • (A) It displays the same information as a crosstab query, except for the counts and sums of numeric fields
  • (B) It displays field values that can be switched for different views of data
  • (C) It can be used to view different levels of detail or to specify custom layout
  • (D) It is used to graphically summarize and analyze data in a table, query, or form

A

Admin • 833K Points
Coach

Q. In the Field List of a table, the primary key appears __________.

  • (A) Bold
  • (B) Italicized
  • (C) Underlined
  • (D) With key icon

A

Admin • 833K Points
Coach

Q. Which is NOT a method of creating a table?

  • (A) Template
  • (B) Layout View
  • (C) Design View
  • (D) Datasheet View

A

Admin • 833K Points
Coach

Q. A(n) _________ is dynamic mathematical calculation that displays a single value for a specific field.

  • (A) Format layout
  • (B) Aggregate function
  • (C) Criteria row
  • (D) Format row

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.