Microsoft Access MCQs with answers Page - 4

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 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
💬 Discuss
✅ Correct Answer: (B) A sort order for records, which is identified in the table design
📊 Microsoft Access
Q. When you add fields in ________, a Field List pane displays.
  • (A) Report View
  • (B) Print Preview
  • (C) Layout View
  • (D) Design View
💬 Discuss
✅ Correct Answer: (C) Layout View
📊 Microsoft Access
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
💬 Discuss
✅ Correct Answer: (D) Report Footer
📊 Microsoft Access
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
💬 Discuss
✅ Correct Answer: (B) The tab order setting is usually right-to-left and top-to-bottom
📊 Microsoft Access
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
💬 Discuss
✅ Correct Answer: (A) Zoom
📊 Microsoft Access
Q. Referential integrity cannot be set for _________ relationships.
  • (A) One-To-One
  • (B) One-To-Many
  • (C) Indeterminate
  • (D) Many-To-Many
💬 Discuss
✅ Correct Answer: (C) Indeterminate
📊 Microsoft Access
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
💬 Discuss
✅ Correct Answer: (A) It displays the same information as a crosstab query, except for the counts and sums of numeric fields
📊 Microsoft Access
Q. In the Field List of a table, the primary key appears __________.
  • (A) Bold
  • (B) Italicized
  • (C) Underlined
  • (D) With key icon
💬 Discuss
✅ Correct Answer: (D) With key icon
📊 Microsoft Access
Q. Which is NOT a method of creating a table?
  • (A) Template
  • (B) Layout View
  • (C) Design View
  • (D) Datasheet View
💬 Discuss
✅ Correct Answer: (B) Layout View
📊 Microsoft Access
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
💬 Discuss
✅ Correct Answer: (B) Aggregate function

Programming Categories

📱 Download Our App

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

Get it on Google Play