MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 496 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only) |
| A. | CTRL+F |
| B. | CTRL+H |
| C. | SHIFT+F4 |
| D. | None of these |
| Answer» B. CTRL+H | |
| 52. |
To display value from table for a label control |
| A. | Set teh control source and record source prom property panel |
| B. | Choose the databse, table, field and select data value to display |
| C. | Look at the table and type value in the caption |
| D. | Set the record source property and then control source |
| Answer» E. | |
| 53. |
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 |
| Answer» E. | |
| 54. |
Which report section only prints one time at the end of the report? |
| A. | Report Header |
| B. | Page Header |
| C. | Report Footer |
| D. | Page Footer |
| Answer» D. Page Footer | |
| 55. |
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 |
| Answer» B. primary key button | |
| 56. |
Each record is constituted by a number of individual data items which are called |
| A. | Fields |
| B. | Data Types |
| C. | Relations |
| D. | Tables |
| Answer» B. Data Types | |
| 57. |
The Search tool CANNOT be used on which major Access object? |
| A. | Forms |
| B. | Queries |
| C. | Reports |
| D. | Tables |
| Answer» D. Tables | |
| 58. |
A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation. |
| A. | select |
| B. | summary |
| C. | parameter |
| D. | action |
| Answer» E. | |
| 59. |
In relational database schema each tuple is divided into fields known as? |
| A. | Relations |
| B. | Queries |
| C. | Records |
| D. | Domains |
| Answer» E. | |
| 60. |
In Access to open an existing database press |
| A. | CTRL+N |
| B. | CTRL+O |
| C. | ALT+F4 |
| D. | None of these |
| Answer» C. ALT+F4 | |
| 61. |
In Access to Move down one page |
| A. | F4 or ALT+DOWN ARROW |
| B. | DOWN ARROW |
| C. | PAGE DOWN |
| D. | F9 |
| Answer» D. F9 | |
| 62. |
We can remove a relationship defined between two tables by |
| A. | From Edit menu choose Delete Relationship |
| B. | Select the relationship line and press Delete |
| C. | Choose Delete option from Relationship menu |
| D. | All of above |
| Answer» C. Choose Delete option from Relationship menu | |
| 63. |
The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet. |
| A. | primary, foreign |
| B. | primary, common |
| C. | foreign, primary |
| D. | foreign, common |
| Answer» B. primary, common | |
| 64. |
Which of the following database objects extracts information from one or more tables or queries? |
| A. | Forms |
| B. | Queries |
| C. | Reports |
| D. | Tables |
| Answer» C. Reports | |
| 65. |
In Access press …………………….to Cut the selected control and copy it to the Clipboard |
| A. | CTRL+C |
| B. | CTRL+X |
| C. | CTRL+V |
| D. | None of these |
| Answer» C. CTRL+V | |
| 66. |
Which mode sizes an image to fit the control while maintaining the proportions of the original image? |
| A. | Clip |
| B. | Fit |
| C. | Stretch |
| D. | Zoom |
| Answer» E. | |
| 67. |
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field. |
| A. | format row |
| B. | criteria row |
| C. | aggregate function |
| D. | format layout |
| Answer» D. format layout | |
| 68. |
Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called |
| A. | Foreign key |
| B. | Native key |
| C. | Composite key |
| D. | Primary key |
| Answer» E. | |
| 69. |
The most open source DBMS. |
| A. | Microsoft SQL Server |
| B. | Microsoft Access |
| C. | MySQL |
| D. | Oracle |
| Answer» D. Oracle | |
| 70. |
In Access press F11 to |
| A. | Toggle the Navigation Pane |
| B. | Cycle between open windows |
| C. | Restore the selected minimized window when all windows are minimized |
| D. | Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window |
| Answer» B. Cycle between open windows | |
| 71. |
To create queries in Access |
| A. | You can drag and drop fields on query builders |
| B. | you can type the SQL command in SQL view |
| C. | You can use query wizard or design view |
| D. | All of above |
| Answer» E. | |
| 72. |
Which of the following expresses correct order? |
| A. | Characters, Fields, Records, Tables, Files, Databases |
| B. | Characters, Fields, Records, Tables, Database, Files |
| C. | Databases, Tables, Files, Records, Field, Character |
| D. | Files, Databases, Tables, Records, Fields, Characters |
| Answer» B. Characters, Fields, Records, Tables, Database, Files | |
| 73. |
Which of the following methods CANNOT be used to delete records from a table? |
| A. | Selecting records and pressing [Delete] |
| B. | Pressing [Ctrl]+[\'] |
| C. | Clicking the Delete Record button |
| D. | From the ribbon, selecting Delete Record |
| Answer» C. Clicking the Delete Record button | |
| 74. |
This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label. |
| A. | Tabular |
| B. | Justified |
| C. | Columnar |
| D. | Datasheet |
| Answer» D. Datasheet | |
| 75. |
The quickest way to add a field to the selected fields list is to double-click its field name in this list. |
| A. | Find fields |
| B. | Search fields |
| C. | Search record |
| D. | Available fields |
| Answer» E. | |
| 76. |
In Access press…………………….to Movethe selected control to the left (except controls that are part of a layout) |
| A. | CTRL+C |
| B. | CTRL+X |
| C. | CTRL+V |
| D. | None of these |
| Answer» E. | |
| 77. |
In Access press ENTER to |
| A. | Toggle the Navigation Pane |
| B. | Cycle between open windows |
| C. | Restore the selected minimized window when all windows are minimized |
| D. | Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window |
| Answer» D. Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window | |
| 78. |
A relationship is created between how many tables? |
| A. | One |
| B. | Two |
| C. | Three |
| D. | Any number |
| Answer» C. Three | |
| 79. |
In Access press ALT+SPACEBAR to |
| A. | Display the Control menu |
| B. | Display the shortcut menu |
| C. | Close the active window |
| D. | None of these |
| Answer» B. Display the shortcut menu | |
| 80. |
Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation. |
| A. | Design View |
| B. | Datasheet View |
| C. | Office View |
| D. | Print Preview |
| Answer» E. | |
| 81. |
The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors. |
| A. | Color |
| B. | Expression |
| C. | Palette |
| D. | Property |
| Answer» B. Expression | |
| 82. |
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 |
| Answer» E. | |
| 83. |
Which of the following is NOT possible when printing Forms? |
| A. | Print page 1, 3, and 5 |
| B. | Print pages 1 through 5 |
| C. | Print selected records |
| D. | Print only the third record |
| Answer» B. Print pages 1 through 5 | |
| 84. |
The default and maximum size of text field in Access |
| A. | 50 and 255 Characters |
| B. | 8 and 1 GB |
| C. | 266 characters & 64000 characters |
| D. | None of above |
| Answer» B. 8 and 1 GB | |
| 85. |
Which is not an option for Filter on a text field? |
| A. | Begins With |
| B. | Between |
| C. | Contains |
| D. | End With |
| Answer» C. Contains | |
| 86. |
In a junction table, the _____ field consists of the foreign key from both the linked tables. |
| A. | first defined |
| B. | last defined |
| C. | foreign key |
| D. | primary key |
| Answer» D. primary key | |
| 87. |
The___ operator will cause a record to be selected only if two or more conditions are satisfied |
| A. | Or |
| B. | If or |
| C. | Range |
| D. | And |
| Answer» E. | |
| 88. |
Which of the following is not a field type in Access |
| A. | Memo |
| B. | Hyperlink |
| C. | OLE Object |
| D. | Lookup Wizard |
| Answer» E. | |
| 89. |
Queries in Access can be used as |
| A. | view, change and analyze data in different ways |
| B. | a source of records for forms and reports |
| C. | Only a |
| D. | Both a and b |
| Answer» E. | |
| 90. |
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 |
| Answer» C. crosstab | |
| 91. |
What is one of the advantages for using a form over other Access objects? |
| A. | Utilizes field placement to improve the efficiency of data entry. |
| B. | Forms store information more efficiently. |
| C. | Forms show the summary of all the records. |
| D. | Forms cannot be edited. |
| Answer» B. Forms store information more efficiently. | |
| 92. |
Which of the following is not a section in report design window? |
| A. | Report header section |
| B. | Page header section |
| C. | Summary section |
| D. | Report footer section |
| Answer» D. Report footer section | |
| 93. |
A(n) _____ is an image control that displays in the background of a page on a form or report. |
| A. | legend |
| B. | icon |
| C. | logo |
| D. | watermark |
| Answer» E. | |
| 94. |
In Access to Open a combo box |
| A. | F4 or ALT+DOWN ARROW |
| B. | DOWN ARROW |
| C. | PAGE DOWN |
| D. | F9 |
| Answer» B. DOWN ARROW | |
| 95. |
In Access to switch to Form view from form Design view |
| A. | F2 |
| B. | F4 |
| C. | F5 |
| D. | F6 |
| Answer» D. F6 | |
| 96. |
The file extension for an access 2003 database is |
| A. | Exe |
| B. | Doc |
| C. | Exc |
| D. | Mdb |
| Answer» E. | |
| 97. |
A(n)_______ is a major object that can run independent of a control. |
| A. | event |
| B. | property |
| C. | procedure |
| D. | macro |
| Answer» E. | |
| 98. |
To create a new table, in which method you don’t need to specify the field type and size? |
| A. | Create table in Design View |
| B. | Create Table using wizard |
| C. | Create Table by Entering data |
| D. | All of above |
| Answer» D. All of above | |
| 99. |
The following property determines what is displayed in a control. |
| A. | The control source property |
| B. | The display property |
| C. | The comes from property |
| D. | The data property |
| Answer» B. The display property | |
| 100. |
The following you can use in a macro to automatically send a report snapshot in an email message |
| A. | Use mail |
| B. | Send object |
| C. | Run macro |
| D. | All of the above |
| Answer» C. Run macro | |