Microsoft Access MCQs with answers Page - 19

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 the corresponding text for the <#1/1/95# validation rule setting?
  • (A) Enter a value less or more than 1,195
  • (B) Value must be less than 95 characters
  • (C) Enter a date before 1995
  • (D) All of above
💬 Discuss
✅ Correct Answer: (A) Enter a value less or more than 1,195
📊 Microsoft Access
Q. How can you add a table to the relationship window?
  • (A) Select edit > add table from the menu
  • (B) Click the show table button on the toolbar
  • (C) Select the table from the table list on the toolbar
  • (D) Select tools > add table from the menu
💬 Discuss
✅ Correct Answer: (C) Select the table from the table list on the toolbar
📊 Microsoft Access
Q. In order to use dbms, it is important to understand
  • (A) The physical schema
  • (B) All sub schemas that the system supports
  • (C) One sub schema
  • (D) Both A and B
💬 Discuss
✅ Correct Answer: (C) One sub schema
📊 Microsoft Access
Q. What is the propose to a sub datasheet?
  • (A) To provide a hierarchical view of related tables or queries in a single window
  • (B) To display grouped data in a report
  • (C) To display summarized data
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (A) To provide a hierarchical view of related tables or queries in a single window
📊 Microsoft Access
Q. Query design window has two parts. The upper part shows
  • (A) Sorting check boxes
  • (B) Criteria
  • (C) Tables with fields and relationships between tables
  • (D) Name of fields, field type and size
💬 Discuss
✅ Correct Answer: (C) Tables with fields and relationships between tables
📊 Microsoft Access
Q. A database language concerned with the definition of the whole database structure and schema is ________
  • (A) DCL
  • (B) DML
  • (C) DDL
  • (D) All of above
💬 Discuss
✅ Correct Answer: (C) DDL
📊 Microsoft Access
Q. In table design view what are the first column of buttons used for
  • (A) Indicate Primary Key
  • (B) Indicate Current Row
  • (C) Both of above
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Both of above
📊 Microsoft Access
Q. The________ button on the tool box display data from a related table
  • (A) More controls
  • (B) Select objects
  • (C) Relationships
  • (D) Sub form sub report
💬 Discuss
✅ Correct Answer: (D) Sub form sub report
📊 Microsoft Access
Q. This is not one of the sections of the form design window
  • (A) Form detail
  • (B) Form header
  • (C) Form content
  • (D) Form footer
💬 Discuss
✅ Correct Answer: (C) Form content
📊 Microsoft Access
Q. How can you display the related records from other tables in datasheet view?
  • (A) Click on the expand indicator next to the record
  • (B) Double click on the record to expand it
  • (C) Apply filter by command to display related records
  • (D) All of above
💬 Discuss
✅ Correct Answer: (A) Click on the expand indicator next to the record

Programming Categories

📱 Download Our App

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

Get it on Google Play