Quiznetik

Microsoft Access (MS Access) | Set 3

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

Correct : A. Chain

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

Correct : B. Field

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

Correct : A. Record

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

Correct : B. field, record

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

Correct : A. Foreign key

6. Which type of field is incremented automatically?

Correct : B. AutoNumber

7. Which object is used to create a form?

Correct : A. Tables and Queries

8. What determines a table’s sort order?

Correct : B. Index field

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

Correct : C. Cell

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

Correct : C. Simple query wizard

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

Correct : D. Layout view

12. What is the purpose of indexing?

Correct : B. To speedup data search

13. Which is the valid data type in Access?

Correct : D. All of the above

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

Correct : B. 3

15. What is the full form of SQL?

Correct : C. Structured Query Language

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

Correct : A. Text

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

Correct : D. Dynaset

18. Which query do you use to answer the question "Which employees earn more than $5000 a month"?

Correct : C. Select query

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

Correct : C. zipcode, lastname, firstname

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

Correct : D. multiplies the contents of product in the detail table by 1.3

21. Which criteria return only those addresses beginning with the letter "K"?

Correct : B. address = "K*"

22. Which criteria do not return the position "Officer" as a match?

Correct : D. position = "O#r"

23. Which query do you use to answer the question "What is the average salary of the employees"?

Correct : C. Select query

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

Correct : D. display all customers with CustID from 11 to 99

25. How to make a date field DOB store the dates like "2002/10/17" ?

Correct : B. By setting the format property to "yyyy/mm/dd"

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

Correct : C. By defining validation rule

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

Correct : A. form, called a switchboard

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

Correct : A. wizard

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

Correct : D. Currency

30. Which do you click to display the table\'s primary key and indexes in a separate window?

Correct : A. indexes button

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

Correct : B. delete rows

32. Which tool is used to generate printout of a table\'s structure?

Correct : C. Documenter

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

Correct : B. Group header

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

Correct : A. Controls

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

Correct : C. text box

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

Correct : C. text box

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

Correct : A. Datasheet view

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

Correct : A. grand totals

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

Correct : C. MPT

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

Correct : B. Margin

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

Correct : C. Column Header underline

42. Which is not an option for customizing a datasheet window?

Correct : A. change one row\'s height

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

Correct : B. Unhide columns

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

Correct : A. filtering

45. 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?

Correct : A. Referential integrity is enforced

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

Correct : A. add

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

Correct : A. 255 Character

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

Correct : B. Picture

49. In MS Access "Hyperlink" Data Type can store

Correct : D. All of Above

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

Correct : C. Yes/No

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

Correct : A. Date/Time

52. In MS Access "Lookup Wizard" is used to

Correct : C. to select value from another table

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

Correct : B. OLE Object

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

Correct : B. Memo

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

Correct : D. All of the Above

56. in MS Access, AutoNumber Data Type

Correct : D. Only A & B

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

Correct : C. Form

58. Which of the following is invalid field name?

Correct : A. Student.Address

59. Primary key is

Correct : D. All of the above

60. To create a table in Access

Correct : D. All of the above

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

Correct : B. Report

62. In a table to insert User\'s Voice, Data field should be

Correct : A. OLE Object

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

Correct : D. Fields can added and deleted as needed

64. Validation Rule in a field will

Correct : A. Checks the value entered when user leaves the field

65. Query can be use to select data from

Correct : C. Both A & B

66. Data can be import into Access Database from

Correct : B. Excel Files

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

Correct : 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

68. In MS Access, Field Value may contain

Correct : D. All of the Above

69. Which of the following is the DBMS type

Correct : D. All of the Above

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

Correct : B. Many to Null

71. A collection of related tables is called

Correct : C. Database

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

Correct : D. All of Above

73. Queries can be created in Access by

Correct : D. All of the Above

74. Relationship can be establish between two tables by

Correct : A. Drag Primary key of a table into Foreign key of another table

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

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

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

Correct : A. events

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

Correct : B. procedures

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

Correct : C. vbExclamation

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

Correct : A. The associated code is displayed in the Code pane.

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

Correct : D. macro

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

Correct : D. Module1

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

Correct : A. event

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

Correct : D. vbQuestion

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

Correct : C. procedure

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

Correct : D. macro

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

Correct : B. It is bound to two fields.

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

Correct : C. label

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

Correct : A. It can contain only one object.

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

Correct : C. label

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

Correct : A. check box

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

Correct : B. Option group frame

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

Correct : D. Tab control

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

Correct : C. Format

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

Correct : A. It can be inserted into a form only.

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

Correct : D. Option group button

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

Correct : B. XML

97. In Access 2007, to make changes in the Trust Center, you need to go to the ____.

Correct : A. Microsoft Office button

98. For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.

Correct : D. shared

99. Which of the following is a standard file format language for web documents?

Correct : A. HTML

100. HTML stands for ____.

Correct : C. HyperText Markup Language