7. Press the following keys in Access to Print the current or selected object
Correct : A. CTRL+P
8. Press the following keys in Access to Open the Print dialog box from Print Preview
Correct : B. P or CTRL+P
9. Press the following keys in Access to Open the Page Setup dialog box from Print Preview
Correct : C. S
10. Press the following keys in Access to Cancel Print Preview or Layout Preview
Correct : D. C or ESC
11. Press the following keys in Access to Save a
database object
Correct : C. CTRL+S or SHIFT+F12
12. Press the following keys in Access to Open the Save As dialog box
Correct : D. F12
13. In Access to Open a combo box
Correct : A. F4 or ALT+DOWN ARROW
14. In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
Correct : D. F9
15. In Access to Move down one page
Correct : C. PAGE DOWN
16. When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.
Correct : C. Query
17. In Access to Move down one line
Correct : B. DOWN ARROW
18. In Access press…………………….to Move
the selected control to the left (except controls that are part of a layout)
Correct : D. None of these
19. In Access press …………………….to Move the selected control to the right (except controls that are part of a layout)
Correct : D. None of these
20. In Access press …………………….to Paste the contents of the Clipboard in the upper- left corner of the selected section
Correct : C. CTRL+V
21. In Access press …………………….to Cut the selected control and copy it to the Clipboard
Correct : B. CTRL+X
22. In Access press …………………….to Copy the selected control to the Clipboard
Correct : A. CTRL+C
23. In Access press RIGHT ARROW or CTRL+RIGHT ARROW
Correct : A. Move the selected control to the right (except controls that are part of a layout)
24. In Access press LEFT ARROW or CTRL+LEFT ARROW
Correct : B. Move the selected control to the left (except controls that are part of a layout)
25. In Access press ALT+F11 to
Correct : D. None of these
26. In Access press ALT+F11 to
Correct : D. Switch between the Visual Basic Editor and the previous active window
27. In Access press to Toggle the focus forward
between controls in the wizard
Correct : A. TAB
28. In access press to Move to the next page of the wizard
Correct : B. ALT+N
29. In Access press UP ARROW to
Correct : A. Move up one line
30. In Access press PAGE UP
Correct : B. Move up one page
31. In Access press TAB
Correct : C. Exit the combo box or list box
32. In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)
Correct : C. SHIFT+F4
33. In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)
Correct : A. CTRL+F
34. In Access to open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only)
Correct : A. CTRL+F
35. In Access to switch between Edit mode (with insertion point displaye(D)
Correct : A. F2
36. In Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects)
Correct : B. F4
37. In Access to switch between the upper and
lower portions of a window (Design view of queries, and the Advanced Filter/Sort window)
Correct : D. F6
38. In Access to switch to Form view from form Design view
Correct : C. F5
39. In Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)
Correct : A. F6
40. In Access press to Open the Choose Builder dialog box (Design view window of forms and reports)
Correct : B. F7
41. In Access press to Open the Visual Basic Editor from a selected property in the property sheet for a form or report
Correct : B. F7
42. In Access press to Switch from the Visual Basic Editor back to form or report Design view
Correct : D. None of these
43. Switch from the Visual Basic Editor back to form or report Design view in Access press
Correct : C. A and B both are true
44. In Access press to Move to the previous page of the wizard
Correct : C. ALT+B
45. In Access press to Complete the wizard
Correct : D. ALT+F
46. In Access press UP ARROW or CTRL+UP ARROW
Correct : C. Move the selected control up
47. In Access press DOWN ARROW or CTRL+
DOWN ARROW
Correct : D. None of these
48. In Access to Increase the height of the selected control
Correct : B. SHIFT+DOWN ARROW
49. In Access press F11 to
Correct : A. Toggle the Navigation Pane
50. In Access press CTRL+F6 to
Correct : B. Cycle between open windows
51. In Access press ENTER to
Correct : C. Restore the selected minimized window when all windows are minimized
52. In Access press CTRL+F8 to
Correct : A. Toggle the Navigation Pane
53. In Access press ALT+SPACEBAR to
Correct : A. Display the Control menu
54. In Access press SHIFT+F10 to
Correct : B. Display the shortcut menu
55. In Access press CTRL+W or CTRL+F4 to
Correct : C. Close the active window
56. In Access to reduce the height of the selected control
Correct : D. None of these
57. In Access to increase the width of the selected control
Correct : A. SHIFT+RIGHT ARROW
58. In Access to move the selected control down
Correct : C. DOWN ARROW or CTRL+DOWN ARROW
59. A- Press DOWN ARROW or CTRL+DOWN ARROW , B- Press SHIFT+LEFT ARROW: 1- Move the selected control down, 2- Reduce the width of the selected control.
Correct : A. A-1, B-2
60. According to Access Help, what’s a good way to design a database?
Correct : B. Sketch the design of your database using a pencil and paper
61. Which editor was provided for use with Access Basic?
Correct : B. Notepad
62. You add a table to the query design window
Correct : C. Click the Show Table button on the toolbar
63. Which of the following type s of queries are action queries?
Correct : D. Append Queries
64. A query prompts a user for a data and then displays only records that contain the specified date. The type of of query is this
Correct : A. A parameter query
65. Which of the following is NOT a report section?
Correct : B. Summary section
66. You can display a database object in design view by
Correct : B. Selecting the database object and clicking the design button on the database window
67. How can you display the relationship in a database?
Correct : B. Click the Relationship button on the toolbar
68. If you are creating a cross tab query, what must table you are querying contain?
Correct : C. At least one field
69. A query summarizes information in a grid,
organized by regions and months. Which type of query is this?
Correct : A. A cross tab query
70. What type of text box does the toolbox and to a form?
Correct : A. Unbound
71. The filter by selection feature allows you to filter
Correct : A. Those records that match an entity in a field
72. What is the memo data type field used for?
Correct : C. For long text entries
73. What is the purpose of the description column in Table Design View?
Correct : B. To describe the data that should be entered in each field
74. What is the propose to a sub datasheet?
Correct : A. To provide a hierarchial view of related tables or queries in a single window
75. Which of the following is not a selection technique ?
Correct : D. To select a column, double click anywhere in the column
76. How can you display Pivot Table report
summary data in a currency format?
Correct : C. Modify the field settings
77. What method can you use to add a new table to your database?
Correct : C. Both of above
78. Which action do you use in a a macro to automatically send a report snapshot in an email message?
Correct : B. Send object
79. How can you display sales grouped by country, region, and salesperson, all at the same time?
Correct : B. Use the Pivot table view command
80. The checking operation performed on input data is called the
Correct : A. Validation of data
81. A form defines
Correct : C. Both (A) and (B)
82. The following method you can use to add a new table to your database
Correct : C. Both of above
83. The following you can use in a macro to automatically send a report snapshot in an email message
Correct : B. Send object
84. To display sales grouped by country, region, and salesperson, all at the same time
Correct : B. Use the Pivot table view command
85. The checking operation performed on
input data is called the
Correct : A. Validation of data
86. To insert a graphic of your company’s logo on a report
Correct : A. Click the image button on the toolbox and drag on the report to draw a place holder for the graphics
87. The Fill/Back Color button on the formatting toolbar applies color to:
Correct : B. The text in the selected control
88. The type of query extract the data and put them into separate table
Correct : B. A make-table query
89. The following criterion is NOT written using the proper syntax?
Correct : C. NO VALUE
90. (IF [Age]>65, “Senior”,”Adult”) This expression is an example of:
Correct : A. A conditional expression
91. The following property determines what is displayed in a control.
Correct : A. The control source property
92. You view the properties of a form
Correct : B. Right click anywhere on the form and select properties from the shortcut menu
93. You can keep the sum([Sales]) to calculate the totals for each month in
Correct : C. the month group footer section
94. The procedure for selecting multiple controls on a report?
Correct : A. Hold down the Shift key as you click each object that you want to select
95. The following database object can you import from one Microsoft Access database to another?
Correct : D. All of the above
96. What field type is used to store picture in a table?
Correct : B. OLE
97. When a picture or other graphic image is placed in the report header section it will appear____
Correct : A. Once in the beginning of the report
98. Cascade delete option
Correct : C. is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
99. This data type allows alphanumeric characters and special symbols.
Correct : A. text
100. Query design window has two parts. The upper part shows
Correct : B. Tables with fields and relationships between tables