Microsoft Access MCQs with answers Page - 18

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. In MS Access “Lookup Wizard” is used to
  • (A) To select from previous values
  • (B) To select values from Excel Sheet
  • (C) To select value from another table
  • (D) Not a valid Data Type
💬 Discuss
✅ Correct Answer: (C) To select value from another table
📊 Microsoft Access
Q. Validation Rule in a field will
  • (A) There is no option of Validation Rule
  • (B) Defines the appearance for the text
  • (C) Displays the value in specified format when user leaves the field
  • (D) Checks the value entered when user leaves the field
💬 Discuss
✅ Correct Answer: (D) Checks the value entered when user leaves the field
📊 Microsoft Access
Q. A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
  • (A) Commands
  • (B) Macros
  • (C) Procedures
  • (D) Properties
💬 Discuss
✅ Correct Answer: (C) Procedures
📊 Microsoft Access
Q. The option button ________ identifies each button or check box in an option group.
  • (A) Event
  • (B) Frame
  • (C) Label
  • (D) Value
💬 Discuss
✅ Correct Answer: (C) Label
📊 Microsoft Access
Q. If you need to edit a relationship
  • (A) Right click the relationship line and choose edit relationship
  • (B) Double click the relationship line
  • (C) Both of above
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Both of above
📊 Microsoft Access
Q. Unlike text data type, this can store up to maximum of 65,535 characters.
  • (A) Memo
  • (B) Data/time
  • (C) Number
  • (D) All of above
💬 Discuss
✅ Correct Answer: (A) Memo
📊 Microsoft Access
Q. What it is called to present information in a particular order based on numeric or alphabetical value?
  • (A) Cropping
  • (B) Arranging
  • (C) Searching
  • (D) Sorting
💬 Discuss
✅ Correct Answer: (D) Sorting
📊 Microsoft Access
Q. This form displays multiple records, one per row, in the form window
  • (A) Tabular
  • (B) Datasheet
  • (C) Justified
  • (D) Columnar
💬 Discuss
✅ Correct Answer: (B) Datasheet
📊 Microsoft Access
Q. In relational database schema each tuple is divided into fields known as?
  • (A) Domains
  • (B) Records
  • (C) Queries
  • (D) Relations
💬 Discuss
✅ Correct Answer: (A) Domains
📊 Microsoft Access
Q. A subset of characters within a data field is known as
  • (A) Byte
  • (B) Data string
  • (C) File
  • (D) Record
💬 Discuss
✅ Correct Answer: (B) Data string

Programming Categories

📱 Download Our App

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

Get it on Google Play