Microsoft Access MCQs with answers Page - 94

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 a query\'s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
  • (A) The join line but not the relationship between the two tables
  • (B) The relationship between the two tables locally
  • (C) The relationship between the two tables globally
  • (D) The primary key of the first table
💬 Discuss
✅ Correct Answer: (B) The relationship between the two tables locally
📊 Microsoft Access
Q. What is an index?
  • (A) A wizard that creates a functional database structure based on the user\'s selections
  • (B) A widely recognized naming convention for database objects
  • (C) A sort order for records, which is identified in the table design
  • (D) A set of relationship rules that enforce defined database relationships
💬 Discuss
✅ Correct Answer: (C) A sort order for records, which is identified in the table design
📊 Microsoft Access
Q. Which of the following is invalid field name?
  • (A) Student.Address
  • (B) Student\'sAddress
  • (C) Student_Address
  • (D) Student Address
💬 Discuss
✅ Correct Answer: (A) Student.Address
📊 Microsoft Access
Q. In a table to insert User\'s Voice, Data field should be
  • (A) OLE Object
  • (B) SoundField
  • (C) VoiceField
  • (D) Memo
💬 Discuss
✅ Correct Answer: (A) OLE Object
📊 Microsoft Access
Q. What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?
  • (A) The associated code is displayed in the Code pane.
  • (B) The associated code is displayed in a new window.
  • (C) The object is deleted from the Project pane.
  • (D) The object\'s property sheet opens.
💬 Discuss
✅ Correct Answer: (A) The associated code is displayed in the Code pane.
📊 Microsoft Access
Q. Which do you click to display the table\'s primary key and indexes in a separate window?
  • (A) indexes button
  • (B) primary key button
  • (C) view datasheet button
  • (D) view design button
💬 Discuss
✅ Correct Answer: (A) indexes button
📊 Microsoft Access
Q. Which tool is used to generate printout of a table\'s structure?
  • (A) Analyzer
  • (B) Designer
  • (C) Documenter
  • (D) Generator
💬 Discuss
✅ Correct Answer: (C) Documenter
📊 Microsoft Access
Q. Which is not an option for customizing a datasheet window?
  • (A) change one row\'s height
  • (B) hide one column
  • (C) change one column\'s width
  • (D) freeze one column
💬 Discuss
✅ Correct Answer: (A) change one row\'s height
📊 Microsoft Access
Q. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
  • (A) Referential integrity is enforced
  • (B) Referential integrity isn\'t enforced
  • (C) An inner join is set
  • (D) An outer join is set
💬 Discuss
✅ Correct Answer: (A) Referential integrity is enforced

Programming Categories

📱 Download Our App

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

Get it on Google Play