[l2g] Q.No-Correct Answer 1 – a 2 – c 3 – a 4 – b 5 – b 6 – c 7 – c 8 – b 9 – a 10 – d 11 – a 12 – b 13 – d 14 – c 15 – a 16 – a 17 – a 18 – c 19 – b 20 – b 21 – a 22 – a 23 – a 24 – d 25 – c 26 – b 27 – c 28 – b 29 – d 30 – a 31 – d 32 – d 33 – d 34 – c 35 – c 36 – d 37 – d 38 – a 39 – b 40 – b 41 – b 42 – a 43 – c 44 – c 45 – b 46 – a 47 – a 48 – b 49 – d 50 – b 51 – a 52 – d 53 – b 54 – c 55 – c 56 – b 57 – c 58 – a 59 – b 60 – a 61 – d 62 – b 63 – d 64 – c 65 – d 66 – b 67 – b 68 – c 69 – c 70 – c 71 – b 72 – c 73 – a 74 – c 75 – c 76 – c 77 – c 78 – a 79 – a 80 – a 81 – b 82 – c 83 – a 84 – d 85 – c 86 – b 87 – a 88 – d 89 – c 90 – d 91 – b 92 – d 93 – b 94 – a 95 – d 96 – a 97 – c 98 – c 99 – c 100 – b 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. 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 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 _______.
Click the Like, Tweet or Google+ buttons below to show correct answers: [l2g] Q.No-Correct Answer 101 – c 102 – a 103 – b 104 – a 105 – a 106 – b 107 – a 108 – b 109 – a 110 – b 111 – a 112 – b 113 – c 114 – c 115 – d 116 – b 117 – d 118 – b 119 – c 120 – a 121 – d 122 – c 123 – c 124 – d 125 – b 126 – d 127 – c 128 – d 129 – b 130 – c 131 – a 132 – a 133 – d 134 – a 135 – b 136 – c 137 – b 138 – a 139 – c 140 – c 141 – a 142 – a 143 – c 144 – b 145 – c 146 – a 147 – b 148 – a 149 – a 150 – a 151 – a 152 – b 153 – d 154 – c 155 – a 156 – c 157 – b 158 – b 159 – d 160 – d 161 – c 162 – a 163 – d 164 – d 165 – b 166 – a 167 – d 168 – a 169 – c 170 – b 171 – a 172 – d 173 – d 174 – b 175 – c 176 – d 177 – d 178 – a 179 – b 180 – a 181 – b 182 – c 183 – a 184 – d 185 – d 186 – a 187 – d 188 – c 189 – d 190 – b 191 – c 192 – a 193 – c 194 – a 195 – b 196 – d 197 – c 198 – a 199 – d 200 – b 201. In Access 2007, to make changes in the Center, you need to go to the ____. a. Microsoft Office button b. Navigation Pane c. Quick Access toolbar d. Database Tools command tab 202. For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.
229. In a query, what symbol is used to surround a parameter\’s user prompt? a. [ ] b. { } c. ” ” d. ( ) 230. A(n) _______________ query locates data from one or more tables. a. select b. summary c. parameter d. action 231. Which function extracts the name of the month from a date/time value? a. Month b. MonthName c. MonthLabel d. MonthValue 232. Which of the following queries prompts users for input data by displaying dialog boxes? a. Append b. Delete c. Parameter d. Update 233. A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation. a. select b. summary
a. Datasheet b. Justified c. Stacked d. Tabular 261. Which Form tool creates a new form that show both a form and datasheet views? a. Form b. Form Wizard c. Multiple Item Form d. Split Form 262. Which of the following statements about tab order setting is NOT true? a. The actual tab setting for a form can be used in the Form View. b. The tab order setting determines the movement of the insertion point through a form. c. The tab order setting is usually right-to-left and top-to-bottom. d. The default tab order setting can be altered by moving the controls in the Design View. 263. What type of controls are text boxes when data from the recordset is visible? a. Align b. Bound c. Calculated d. Unbound 264. When increasing the Control Padding, is added where? a. Between the content of the controls and the outside edge of then controls b. Between all controls c. Between the control and the Form\’s edge d. Between controls and gridlines 265. Which of the following is NOT possible when printing Forms?
Q. MCQ Sets is helpful to prepare your exams because a. It offers MCQ collection b. It allows to download MCQ c. You can get your answers through subjective questions/answers d. It has online MCQ quiz system 399. It is a database object to view, change, and analyze data in different ways a. b. Form c. Report d. None of the above 400. It is most common type of query. It retrieves records from one or more tables and then displays the a. Parameter b. Select c. Crosstab d. All of above Answers: Click the Like, Tweet or Google+ buttons below to show correct answers: [l2g] Q.No-Correct Answer 301 – d 302 – c 303 – d 304 – b 305 – b 306 – a 307 – c 308 – d 309 – d 310 – d 311 – a 312 – d 313 – d 314 – d 315 – c 316 – c 317 – b 318 – a 319 – a 320 – a 321 – c 322 – c 323 – d 324 – b 325 – d 326 – b 327 – d 328 – a 329 – c 330 – c
331 – a 332 – d 333 – b 334 – c 335 – a 336 – b 337 – a 338 – c 339 – d 340 – a 341 – c 342 – b 343 – a 344 – c 345 – b 346 – d 347 – d 348 – a 349 – b 350 – b 351 – a 352 – c 353 – c 354 – d 355 – a 356 – c 357 – a 358 – b 359 – c 360 – b 361 – c 362 – c 363 – d 364 – c 365 – b 366 – b 367 – d 368 – d 369 – a 370 – d 371 – b 372 – b 373 – d 374 – d 375 – d 376 – b 377 – c 378 – d 379 – c 380 – a 381 – a 382 – c 383 – c 384 – b 385 – c 386 – a 387 – b 388 – c 389 – c 390 – c 391 – d 392 – a 393 – a 394 – c 395 – a 396 – b 397 – a 398 – a 399 – a 400 – b Questions: 401. It is a query that when run displays its own dialog box prompting you for information, such as a. Select b. Crosstab c. Parameter d. Append 402. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum, a. Parameter b. Select c. Crosstab d. Append 403. It is a sign or symbol that specifies, operator, and values that produce a result a. Operator b. c. Expression d. None of the above
404. Which of the following database object is created first before any other created? a. Table b. Form c. Report d. Query Q. Visit MCQ Sets for a. Multiple Choice Questions Collection b. Download MCQ Banks c. Attempt online quiz d. Study subjective questions/answers 405. This type of database contains multiple tables that are connected to produce combined output from all tables. a. Bound b. Linked c. Relational d. Joined 406. The ‘filter by selection’ allows you to filter those records a. That the selected field b. That match the criteria specified c. That meet any of several criteria specified d. All of above 407. The operation of checking data against specified criteria is known as? a. Data verification b. Data validation c. Cross check d. Data control 408. Some rules are set in databases to check and permit only correct values. What is this feature called? a. Data verification b. Auditing c. Data filtering d. Data validation 409. Database access levels are specified so as to define who can access what in a database. It is identified through
Q. MCQ Sets for a. Multiple Choice Questions Collection b. Download MCQ Banks c. Attempt online quiz d. Study subjective questions/answers 493. How can you display pivot table report summary data in a currency format? a. Use custom calculation b. Type in the currency symbol c. Modify the field settings d. None of the above Answers: Click the Like, Tweet or Google+ buttons below to show correct answers: [l2g] Q.No-Correct Answer 401 – c 402 – c 403 – a 404 – a 405 – c 406 – a 407 – b 408 – d 409 – a 410 – a 411 – c 412 – b 413 – d 414 – a 415 – c 416 – a 417 – b 418 – b 419 – b 420 – d 421 – c 422 – d 423 – a 424 – c 425 – d 426 – d 427 – b 428 – a 429 – d 430 – c 431 – d 432 – b 433 – c 434 – c 435 – b 436 – b 437 – c 438 – d 439 – d 440 – a 441 – d 442 – c 443 – c 444 – a 445 – a 446 – c 447 – d 448 – c 449 – b 450 – a 451 – d 452 – c 453 – d 454 – c 455 – a 456 – d 457 – c 458 – a 459 – b 460 – b 461 – a 462 – b 463 – b 464 – c 465 – b 466 – c 467 – a 468 – b 469 – b 470 – a 471 – c 472 – b 473 – c 474 – a 475 – b 476 – b 477 – b 478 – a 479 – b 480 – d 481 – d 482 – c 483 – a 484 – c 485 – c 486 – c 487 – b 488 – a 489 – c 490 – b 491 – a 492 – d 493 – c