101 to 200 MCQ Questions from MS Access

Questions:

101. An organized collection of logically related data is known as 

a. Data
b. Meta data
c. Database
d. Information

102. In databases, Locking level is also called as

a. Granularity
b. S lock
c. X lock
d. Dead lock

103. Which of the following is not a database application?

a. dBase
b. Flash
c. FoxPro
d. Access

104. HSAM stands for ________ 

a. Hierarchic Sequential Access Method
b. Hierarchic Standard Access Method
c. Hierarchic Sequential and Method
d. Hierarchic Standard and Method

105. Which of the following is not a logical database structure?

a. Chain
b. Network
c. Tree
d. Relational

106. In a datasheet, what does each column represent?

a. Record
b. Field
c. Database
d. Table

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

107. In a datasheet, what does each row represent?

a. Record
b. Field
c. Database
d. Table

108. A ________ is a unit of information in a ________

a. record, field
b. field, record
c. data source, field
d. record, data source

109. What do you call a primary key field included in another table?

a. Foreign key
b. Parent key
c. Child key
d. Index

110. Which type of field is incremented automatically?

a. Auto Elevate
b. AutoNumber
c. Auto Increment
d. Auto Value

111. Which object is used to create a form?

a. Tables and Queries
b. Tables only
c. Tables and reports
d. Queries and reports

112. What determines a table’s sort order?

a. AutoNumber field
b. Index field
c. Field order
d. Primary key

113. What is an intersection of a row and a column?

a. Form
b. Cursor
c. Cell
d. Record

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

114. Which tool do you use to create a query object?

a. Database wizard
b. Simple filter wizard
c. Simple query wizard
d. Table query wizard

115. Which of the following is not a view for interacting with a form object?

a. Datasheet view
b. Design view
c. Form view
d. Layout view

116. What is the purpose of indexing?

a. To reduce table size
b. To speedup data search
c. both A and B
d. none of the above

117. Which is the valid data type in Access?

a. Number
b. Text
c. Currency
d. All of the above

118. How many relations may exist between tables in databases?

a. 4
b. 3
c. 2
d. 1

119. What is the full form of SQL?

a. Sophisticated Question List
b. Structured Question List
c. Structured Query Language
d. Small Query Length

120. Which data type is better to use for storing phone number in the following format “977-1-1234567”?

a. Text
b. AutoNumber
c. Number
d. Currency

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

121. What do you call a collection of records matching parameters of a query?

a. Field
b. Record
c. Query
d. Dynaset

122. Which query do you use to answer the question “Which employees earn more than $5000 a month”?

a. Search query
b. Cross tab query
c. Select query
d. Update query

123. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

a. zipcode, firstname, lastname
b. firstname, lastname, zipcode
c. zipcode, lastname, firstname
d. can’t sort by multiple fields

124. What does the expression [detail] ! [product] * 1.30 do?

a. multiplies the contents of detail and product fields by 1.3
b. First divides detail by product and then multiplies by 1.3
c. multiplies the contents of detail in the product table by 1.3
d. multiplies the contents of product in the detail table by 1.3

125. Which criteria return only those addresses beginning with the letter “K”?

a. address = “K”
b. address = “K*”
c. address = “K?”
d. address = “K#”

126. Which criteria do not return the position “Officer” as a match?

a. position = “*ff*”
b. position = “O??icer”
c. position = ” ?ff*”
d. position = “O#r”

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

127. Which query do you use to answer the question “What is the average salary of the employees”?

a. Search query
b. Cross tab query
c. Select query
d. Update query

128. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

a. display all customers with CustID from 10 to 100
b. display all customers with CustID above 10
c. display all customers with CustID below 100
d. display all customers with CustID from 11 to 99

129. How to make a date field DOB store the dates like “2002/10/17” ?

a. By setting the input mask property to “yyyy/mm/dd”
b. By setting the format property to “yyyy/mm/dd”
c. By entering dates in yyyy, mm, dd order
d. none of the above

130. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

a. By setting required to ‘Yes’
b. By using default value
c. By defining validation rule
d. By using format

131. In an application created using the database wizard, the main menu is presented as a:

a. form, called a switchboard
b. report, called a menu
c. table, called a switchboard
d. query, called a menu

132. Which leads you through the process of creating a table?

a. wizard
b. assistant
c. relation
d. coach

133. Which data type is better to use for storing the price of an item?

a. Text
b. AutoNumber
c. Number
d. Currency

134. 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

135. After right click the field selector button, which do you choose to delete a field in design view?

a. Delete field
b. delete rows
c. remove field
d. remove rows

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

136. Which tool is used to generate printout of a table\’s structure?

a. Analyzer
b. Designer
c. Documenter
d. Generator

137. Which of the following is not a legitimate section for form objects?

a. Form detail
b. Group header
c. Form header
d. Page footer

138. The basic elements of a form or a report are called:

a. Controls
b. Objects
c. Windows
d. Properties

139. Which control types is most often associated with a bound control?

a. command button
b. label
c. text box
d. list box

140. Which control type do you use to create a calculated control?

a. command button
b. combo box
c. text box
d. list box

141. Which is not a view for displaying a report object?

a. Datasheet view
b. Design view
c. Print preview
d. Layout preview

142. The report footer section is most useful for displaying:

a. grand totals
b. Column headings
c. subtotals
d. page numbers

143. Which function can not be used for calculated controls in a report?

a. SUM
b. AVG
c. MPT
d. COUNT

144. Which setting you must modify to print a report using letterhead?

a. Group
b. Margin
c. Section
d. Orientation

145. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?

a. datasheet border
b. datasheet underline
c. Column Header underline
d. vertical gridline

146. 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

147. Which is not a command that is selectable from right click menu of a field column?

a. Hide columns
b. Rename columns
c. freeze columns
d. sort descending

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

148. What do you call the process of restricting the display of records in a table to those matching a particular criterion?

a. filtering
b. restricting
c. sorting
d. sifting

149. 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

150. Which of the following is not an action query?

a. add
b. delete
c. make-table
d. update

151. In MS Access, Text Data type may contain maximum character of

a. 255 Character
b. 256 Character
c. 1064 Character
d. No Limit

152. Which of the following is not a valid Data Type in MS Access?

a. Memo
b. Picture
c. Currency
d. AutoNumber

153. In MS Access “Hyperlink” Data Type can store

a. Web Address
b. email Address
c. Path of a File
d. All of Above

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

a. True/False
b. On/Off
c. Yes/No
d. All of Above

155. The appropriate Data Type to store Time in MS Access?

a. Date/Time
b. Time Only
c. Time
d. Time cannot be stored

156. 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

157. Which of the following Data Type is used to store picture in MS Access

a. Picture
b. OLE Object
c. Memo
d. Picture cannot be stored

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

a. Text
b. Memo
c. OLE
d. Large Text

159. in MS Access, OLE Object Data type can store

a. Microsoft Word documents
b. Microsoft Excel spreadsheets
c. Sounds
d. All of the Above

160. in MS Access, AutoNumber Data Type

a. Can be Sequential
b. Can be Random
c. Can be Edited
d. Only A & B

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

161. Which of the following is use to get data from user?

a. Query
b. Pages
c. Form
d. Report

162. Which of the following is invalid field name?

a. Student.Address
b. Student\’sAddress
c. Student_Address
d. Student Address

163. Primary key is

a. Uniquely identifies each record
b. Cannot be repeated
c. AutoNumber is example of Primary key
d. All of the above

164. To create a table in Access

a. Database should be created before create table
b. Table can be created using Table Templates
c. There must be at least one Primary key in a table
d. All of the above

165. Which of the following is use to view or print the data in organized manner?

a. Query
b. Report
c. Table
d. Form

166. In a table to insert User\’s Voice, Data field should be

a. OLE Object
b. SoundField
c. VoiceField
d. Memo

167. After creating the table which of the following is correct?

a. Fields cannot be added
b. Fields cannot be deleted
c. Fields can added but only once
d. Fields can added and deleted as needed

168. Validation Rule in a field will

a. Checks the value entered when user leaves the field
b. Displays the value in specified format when user leaves the field
c. Defines the appearance for the text
d. There is no option of Validation Rule

169. Query can be use to select data from

a. Single Table
b. Multiple Tables
c. Both A & B
d.

170. Data can be import into Access Database from

a. Word Files
b. Excel Files
c. PowerPoint Files
d. HTML Files

171. What is the use of Referential Integrity in MS Access?

a. 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
b. 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
c. 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
d. None of above

172. In MS Access, Field Value may contain

a. Text
b. Date & Time
c. Picture
d. All of the Above

173. Which of the following is the DBMS type

a. Flat File System
b. Hierarchical DBMS
c. Relational DMBS
d. All of the Above

174. Which of the following relationship is not valid in MS Access ?

a. Many to Many
b. Many to Null
c. One to One
d. One to Many

175. A collection of related tables is called

a. Row
b. Record
c. Database
d. File

176. Which of the following Format supports for Data Type Yes/No?

a. Yes/No
b. True/False
c. On/Off
d. All of Above

177. Queries can be created in Access by

a. Typing Queries in SQL View
b. Drag and Drop fields on Query Builder
c. Using Query Wizard
d. All of the Above

178. Relationship can be establish between two tables by

a. Drag Primary key of a table into Foreign key of another table
b. Drag Foreign key of a table into Primary key of another table
c. Drag any key of a table into any key of another table
d. All of the above

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

179. What is the use of Cascade Delete Option in MS Access?

a. It makes sure that all the records from the parent table and child table is deleted from selected database
b. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
c. It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
d. None of above

180.  Macros can recover from _______ in a controlled manner.

a.            events
b.           modules
c.           arguments
d.            errors

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

a.            properties
b.           procedures
c.           macros
d.            commands

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

a.            vbCritical
b.           vbInformation
c.           vbExclamation
d.            vbQuestion

183. 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.

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

a.            event
b.           property
c.           procedure
d.            macro

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

a.            Bas1
b.           Module
c.           New Module
d.            Module1

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

a.            event
b.            property
c.           title
d.           macro

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

a.            vbCritical
b.           vbInformation
c.           vbExclamation
d.            vbQuestion

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

a.            event
b.           property
c.           procedure
d.            macro

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

a.            event
b.           property
c.           procedure
d.            macro

190. Which of the following statements about option group is incorrect?

a. It is a control object.
b. It is bound to two fields.
c. It is a control to identify a choice.
d. It contains a set of controls representing choices.

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

a. event
b. frame
c. label
d. value

Q. Why you can rely on MCQ Sets to prepare your computer jobs exams?

a. It offers you to downloads of MCQ Banks
b. MCQ Sets has huge collection of MCQ questions
c. Online MCQ Quiz is helpful to practice
d. You can get subjective questions and answers

192. Which of the following statements about a tab control in a form is incorrect?

a. It can contain only one object.
b. It defines a layered space.
c. It is a control object.
d. It is created in multipage forms.

193. The option group ____ describes the contents of the entire option group.

a. event
b. frame
c. label
d. value

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

a. check box
b. option button
c. toggle button
d. list box

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

a. Option group label
b. Option group frame
c. Option button
d. Option button labels

196. Which control lets a user create multiple pages in a form?

a. Check box control
b. Combo box control
c. Option group control
d. Tab control

197. On the property sheet, which of the following tabs contains the Caption property?

a. Data
b. Event
c. Format
d. Other

198. Which of the following statements regarding charts is incorrect?

a. It can be inserted into a form only.
b. It can be designed as a stand-alone object.
c. It can be linked to the object in which it is placed.
d. It is a control linked to a data source.

199. Which of the following options is NOT a part of an option group?

a. Option button label
b. Option group frame
c. Option group label
d. Option group button

200. Which of the following is a condensed form of standard generalized markup language?

a. HTML
b. XML
c. XSD
d. XSL

Answers:

Click the Like, Tweet or Google+ buttons below to show correct answers:

[l2g]

Q.No-Correct Answer