Computer/MS Access MCQ Questions Part 4 Sample Test,Sample questions

Question:
 
To create a table in Access

1.Database should be created before create table

2. Table can be created using Table Templates

3.There must be at least one Primary key in a table

4.All of the above


Question:
   Primary key is

1.Uniquely identifies each record

2.Cannot be repeated

3.AutoNumber is example of Primary key

4.All of the above


Question:
 In a table to insert User’s Voice, Data field should be

1.OLE Object

2. SoundField

3.VoiceField

4.Memo


Question:
 In MS Access “Hyperlink” Data Type can store

1.Web Address

2.email Address

3.Path of a File

4.All of the Above


Question:
 in MS Access, AutoNumber Data Type

1.Can be Sequential

2.Can be Random

3. Can be Edited

4.Only A & B


Question:
 in MS Access, OLE Object Data type can store

1.Microsoft Word documents

2.Microsoft Excel spreadsheets

3.Sounds

4.All of the Above


Question:
 in MS Access, which data type is appropriate to store large text and numbers?

1.Text

2.Memo

3.OLE

4.Large Text


Question:
 On the property sheet, which of the following tabs contains the Caption property?

1.Data

2.Event

3.Format

4.Other


Question:
 To assign a macro to an event, users need to open the form in Design View.

1.event

2.property

3.title

4.Macro


Question:
 What is the use of Cascade Delete Option in MS Access?

1. It makes sure that all the records from the parent table and child table is deleted from selected database

2.It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted

3.It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted

4. None of above


Question:
 Which control lets a user create multiple pages in a form?

1. Check box control

2.Combo box control

3.Option group control

4.Tab control


Question:
 Which of the following statements regarding charts is incorrect?

1. It can be inserted into a form only.

2.It can be designed as a stand-alone object.

3.It can be linked to the object in which it is placed.

4.It is a control linked to a data source.


Question:
A collection of related tables is called

1.Row

2.Record

3.Database

4.File


Question:
A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.

1.properties

2.procedures

3.macros

4.Commands


Question:
A(n) ____ is the default control for a Yes/No field.

1.check box

2. option button

3.toggle button

4.list box


Question:
A(n) _______ is major object that completes an action or a set of actions.

1.event

2.property

3.procedure

4.Macro


Question:
A(n)_______ is a major object that can run independent of a control.

1.event

2.property

3.procedure

4.Macro


Question:
After creating the table which of the following is correct?

1.Fields cannot be added

2. Fields cannot be deleted

3.Fields can added but only once

4.Fields can added and deleted as needed


Question:
By default, what is the name of a new module in the Modules folder of the Project pane called?

1.Bas1

2.Module

3.New Module

4.Module1


Question:
Data can be import into Access Database from

1.Word Files

2.Excel Files

3.PowerPoint Files

4. HTML Files


Question:
In a module, a(n) _______ is a series of commands and properties that perform a specific task.

1.event

2.property

3.procedure

4.Macro


Question:
In a module, the VB Name used to display a warning query icon is _______.

1.vbCritical

2.vbInformation

3.vbExclamation

4.vbQuestion


Question:
In MS Access “Lookup Wizard” is used to

1.to select from previous values

2.to select values from Excel Sheet

3.to select value from another table

4.Not a valid Data Type


Question:
In MS Access, Field Value may contain

1.Text

2.Date & Time

3.Picture

4.All of the Above


Question:
 Which of the following is not a valid Data Type in MS Access?

1.Memo

2.Picture

3.Currency

4.AutoNumber


Question:
Macros can recover from _______ in a controlled manner.

1.events

2.modules

3.arguments

4.Errors


Question:
Queries can be created in Access by

1.Typing Queries in SQL View

2.Drag and Drop fields on Query Builder

3.Using Query Wizard

4.All of the Above


Question:
Query can be use to select data from

1.Single Table

2.Multiple Tables

3.Both A & B

4.None of above


Question:
Relationship can be establish between two tables by

1.Drag Primary key of a table into Foreign key of another table

2. Drag Foreign key of a table into Primary key of another table

3.Drag any key of a table into any key of another table

4. All of the above


Question:
The appropriate Data Type to store Time in MS Access?

1.Date/Time

2.Time Only

3.Time

4.Time cannot be stored


Question:
The option button ____ identifies each button or check box in an option group.

1.event

2.frame

3.label

4.value


Question:
The option group ____ describes the contents of the entire option group.

1.event

2.frame

3.label

4.value


Question:
The VB Name used to display the warning message icon is _______.

1.vbCritical

2.vbInformation

3.vbExclamation

4.vbQuestion


Question:
Validation Rule in a field will

1.Checks the value entered when user leaves the field

2.Displays the value in specified format when user leaves the field

3.Defines the appearance for the text

4.There is no option of Validation Rule


Question:
What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?

1.The associated code is displayed in the Code pane

2.The associated code is displayed in a new window.

3.The object is deleted from the Project pane.

4.The object’s property sheet opens.


Question:
What is the use of Referential Integrity in MS Access?

1.It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

2.It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

3. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table

4.None of above


Question:
Which of the following components has a property sheet that includes settings for the frame and the option group?

1. Option group label

2.Option group frame

3.Option button

4.Option button labels


Question:
Which of the following data type is used to store logical value in MS Access?

1.True/False

2.On/Off

3.Yes/No

4.All of the Above


Question:
Which of the following Data Type is used to store picture in MS Access

1.Picture

2.OLE Object

3.Memo

4.Picture cannot be stored


Question:
Which of the following Format supports for Data Type Yes/No?

1.Yes/No

2. True/False

3.On/Off

4.All of the Above


Question:
Which of the following is a condensed form of standard generalized markup language?

1.HTML

2.XML

3.XSD

4.XSL


Question:
Which of the following is invalid field name?

1.Student.Address

2.Student’sAddress

3.Student_Address

4.Student Address


Question:
Which of the following is the DBMS type

1.Flat File System

2.Hierarchical DBMS

3.Relational DMBS

4.All of the Above


Question:
Which of the following is use to get data from user?

1.Query

2.Pages

3.Form

4.Report


Question:
Which of the following is use to view or print the data in organized manner?

1.Query

2.Report

3.Table

4.Form


Question:
Which of the following options is NOT a part of an option group?

1.Option button label

2.Option group frame

3.Option group label

4.Option group button


Question:
Which of the following relationship is not valid in MS Access ?

1. Many to Many

2.Many to Null

3.One to One

4.One to Many


Question:
Which of the following statements about a tab control in a form is incorrect?

1.It can contain only one object.

2.It defines a layered space.

3.It is a control object.

4.It is created in multipage forms.


Question:
Which of the following statements about option group is incorrect?

1. It is a control object.

2.It is bound to two fields.

3.It is a control to identify a choice.

4.It contains a set of controls representing choices.


More MCQS

  1. Computer fundamentals
  2. Computer Basic MCQS
  3. CCC MCQ Sample Paper 1
  4. CCC Exams MCQS Sample Paper Test 2
  5. Computer Basics MCQS Paper 1
  6. Computer Basics MCQS Paper 2
  7. FUNDAMENTALS OF COMPUTERS MCQs PART 2
  8. FUNDAMENTALS OF COMPUTERS MCQs PART 1
  9. FUNDAMENTALS OF COMPUTERS MCQs PART 3
  10. Computer mcqs smaple paper 1
  11. Computer mcqs smaple paper 2
  12. Computer mcqs smaple paper 3
  13. Fundamentals of Computers
  14. Fundamentals of Computers (New) Part 1
  15. Fundamentals of Computers (New) Part 2
  16. Computer Networks MCQ Questions
  17. Computer Networks Transition from IPV4 to IPV6
  18. Computer Fundamentals (New) Part 1
  19. Computer Fundamentals (New) Part 2
  20. Computer Fundamentals (New) Part 3
  21. Computer Fundamentals (New) Part 4
  22. Computer Fundamentals (New) Part 5
  23. Computer Fundamentals (New) Part 6
  24. Computer Fundamentals (New) Part 7
  25. Computer Fundamentals (New) Part 8
  26. Operating Systems MCQs Part 1
  27. Operating Systems MCQs Part 2
  28. OS(Computer Operating Systems) Part 1
  29. OS(Computer Operating Systems) Part 2
  30. OS(Computer Operating Systems) Part 3
  31. OS(Computer Operating Systems) Part 4
  32. OS - Computer Operating Systems Part 5
  33. OS - Computer Operating Systems Part 6
  34. OS - Computer Operating Systems Part 7
  35. MS Word MCQ Questions Part 1
  36. MS Word MCQ Questions Part 2
  37. MS Word MCQ Questions Part 3
  38. MS Word MCQ Questions Part 4
  39. MS Word MCQ Questions Part 5
  40. MS Word MCQ Questions Part 7
  41. MS Word MCQ Questions Part 6
  42. Microsoft Excel MCQ Questions Part 1
  43. Microsoft Excel MCQ Questions Part 2
  44. Microsoft Excel MCQ Questions Part 3
  45. Microsoft Excel MCQ Questions Part 4
  46. Microsoft Excel MCQ Questions Part 5
  47. Microsoft Excel MCQ Questions Part 6
  48. Microsoft Excel MCQ Questions Part 7
  49. MS PowerPoint MCQ Questions PART 1
  50. MS PowerPoint MCQ Questions PART 2
  51. MS PowerPoint MCQ Questions PART 3
  52. MS PowerPoint MCQ Questions PART 4
  53. MS PowerPoint MCQ Questions PART 5
  54. MS PowerPoint MCQ Questions PART 6
  55. MS PowerPoint MCQ Questions PART 7
  56. MS Access MCQ Questions Part 1
  57. MS Access MCQ Questions Part 2
  58. MS Access MCQ Questions Part 3
  59. MS Access MCQ Questions Part 4
  60. MS Access MCQ Questions Part 5
  61. MS Access MCQ Questions Part 6
  62. MS Access MCQ Questions Part 7
  63. MS Access MCQ Questions Part 8
  64. Query of MS Access MCQS Part 1
  65. Query of MS Access MCQS Part 2
  66. Computer Communication and Networking Quiz
  67. Computer Graphics MCQ Quiz Questions and Answers
  68. Computer Basics Quiz Questions
  69. Computer Quiz Questions with Answers
  70. Computer Hardware MCQS Quiz
  71. MCQ Computer Organization & Architecture
  72. MCQ Computer Organisation - Input & output Organisation SET1
  73. MCQ Computer Organisation - Input & output Organisation SET2
  74. MCQ Computer Organisation - Input & output Organisation SET3
  75. MCQS on addressing modes SET 1
  76. MCQS on addressing modes SET 2
  77. Software Engineering MCQs SET 1
  78. Software Engineering MCQs SET 2
  79. Software Engineering MCQs Set 3
  80. Software Engineering MCQs Set 4
  81. Software Engineering MCQs Set 5
  82. Software Engineering MCQs Set 6
  83. Software Engineering MCQs Set 7
  84. mcqs data structures
  85. CCC Exam Sample MCQ Paper
  86. Computer MCQ Questions set-1
  87. Computer MCQ Questions set-2
  88. Computer MCQ Questions set-3
  89. Current affairs mcq Database management
  90. Programming arcitecture
  91. Computer Graphics MCQ Questions part 1
  92. Computer Graphics MCQ Questions part 2
  93. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 1
  94. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 2
  95. Computer Science MCQs
  96. Computer Mcq Question
  97. MCQs based on Fundamentals of Computer 1 set
  98. Computer Mcq Question set 2
  99. MCQ Encoding Schemes
  100. Data Entry and Keyboarding Skills MCQ
  101. Computer Science Number System
  102. Computer Network MCQ
  103. MCQ Questions on Tally
  104. MCQ Questions on Tally Set 2
  105. MCQ Questions on Tally Set 3
  106. MCQ Questions on Tally Set 4
  107. Internet Technology MCQ Questions for Competitive Exams
  108. Computer Software MCQ GK Questions
  109. Computer Organization and Architecture MCQs
  110. Basic Computer GK Questions
  111. Computer Graphics MCQ Set 1
  112. Operating System MCQ Set 1
  113. Operating System MCQ Set 2
  114. Operating System MCQ Set 3
  115. Operating System MCQ Set 4
  116. Operating System MCQ Set 5
  117. Operating System MCQ Set 6
  118. Operating System MCQ Set 7
  119. Operating System MCQ Set 8
  120. Operating System MCQ Set 9
  121. Operating System MCQ Set 10
  122. Operating System MCQ Set 11
  123. Operating System MCQ Set 12
  124. Operating System MCQ Set 13
  125. Operating System MCQ Set 14
  126. Operating System MCQ Set 15
  127. Operating System MCQ Set 16
  128. Operating System MCQ Set 17
  129. Operating System MCQ Set 18
  130. Operating System MCQ Set 19
  131. Operating System MCQ Set 20
  132. Operating System MCQ Set 21
  133. Computer Graphics MCQ Question Set 1
  134. Computer Networks MCQs
  135. Computer Networks MCQs Set-2
  136. Computer Networks MCQs Set-3
  137. Computer Networks MCQs Set-4
  138. Bachelor of Computer Applications MCQs set-1
  139. Bachelor of Computer Applications MCQs set-2
  140. NET Programming MCQ
  141. Artificial Intelligence and Robotics (AIR) Set 1
  142. Artificial Intelligence and Robotics (AIR) Set 2
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!