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.
| 101. |
Changing the order of this in the query datasheet does not affect the field order in the table. |
| A. | Record |
| B. | Row |
| C. | Column |
| D. | Sort |
| Answer» D. Sort | |
| 102. |
A(n) _______________ query locates data from one or more tables. |
| A. | select |
| B. | summary |
| C. | parameter |
| D. | action |
| Answer» B. summary | |
| 103. |
The option button ____ identifies each button or check box in an option group. |
| A. | event |
| B. | frame |
| C. | label |
| D. | value |
| Answer» D. value | |
| 104. |
Press the following keys in Access to Open the Page Setup dialog box from Print Preview |
| A. | CTRL+P |
| B. | P or CTRL+P |
| C. | S |
| D. | C or ESC |
| Answer» D. C or ESC | |
| 105. |
In Access to move the selected control down |
| A. | SHIFT+RIGHT ARROW |
| B. | SHIFT+DOWN ARROW |
| C. | DOWN ARROW or CTRL+DOWN ARROW |
| D. | None of these |
| Answer» D. None of these | |
| 106. |
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 |
| Answer» D. Update query | |
| 107. |
In Access press LEFT ARROW or CTRL+LEFT ARROW |
| A. | Move the selected control to the right (except controls that are part of a layout) |
| B. | Move the selected control to the left (except controls that are part of a layout) |
| C. | Move the selected control up |
| D. | None of these |
| Answer» C. Move the selected control up | |
| 108. |
A(n) ____ is the default control for a Yes/No field. |
| A. | check box |
| B. | option button |
| C. | toggle button |
| D. | list box |
| Answer» B. option button | |
| 109. |
Access file operations can be found by clicking the ____. |
| A. | Access Button |
| B. | Database Button |
| C. | Office Button |
| D. | Window Button |
| Answer» D. Window Button | |
| 110. |
what is a fast way t adjust the width of a column? |
| A. | Right click the left side of the column heading |
| B. | Double click the left side of the column heading |
| C. | Double click the right side of the column heading |
| D. | Select tools>adjust column width from the menu |
| Answer» D. Select tools>adjust column width from the menu | |
| 111. |
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" |
| Answer» E. | |
| 112. |
The filter by selection feature allows you to filter: |
| A. | Those records that match an entity in a field |
| B. | Records based on a criterion you specify |
| C. | Records that meet any of several criteria you specify |
| D. | All of above |
| Answer» B. Records based on a criterion you specify | |
| 113. |
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field? |
| A. | 1 |
| B. | ? |
| C. | r |
| D. | None |
| Answer» E. | |
| 114. |
A query summarizes information in a grid,organized by regions and months. Which type of query is this? |
| A. | A cross tab query |
| B. | An update query |
| C. | A parameter query |
| D. | An action query |
| Answer» B. An update query | |
| 115. |
In table design view, which key can be used to switch between the field names and properties panels? |
| A. | F3 |
| B. | F4 |
| C. | F5 |
| D. | F6 |
| Answer» E. | |
| 116. |
Referential integrity cannot be set for _______________ relationships. |
| A. | One-To-One |
| B. | Indeterminate |
| C. | One-To-Many |
| D. | Many-To-Many |
| Answer» C. One-To-Many | |
| 117. |
You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section? |
| A. | Detail |
| B. | Form Footer |
| C. | Form Header |
| D. | Page Header |
| Answer» D. Page Header | |
| 118. |
The __________ field is used to hold a yes or no answer. |
| A. | object |
| B. | number |
| C. | text |
| D. | logical |
| Answer» E. | |
| 119. |
The Fill/Back Color button on the formatting toolbar applies color to: |
| A. | The border fo the selected control |
| B. | The text in the selected control |
| C. | All aspects of the control |
| D. | The background of the selected control |
| Answer» C. All aspects of the control | |
| 120. |
Which of the following functions CANNOT be used in the Totals row? |
| A. | Average |
| B. | Count |
| C. | Maximum |
| D. | Round |
| Answer» E. | |
| 121. |
The Search tool is best used when searching for ______ data. |
| A. | simple |
| B. | multiple |
| C. | unique |
| D. | formatted |
| Answer» B. multiple | |
| 122. |
Which of the following is a method to create a new table in MS Access? |
| A. | Create table in Design View |
| B. | Create Table using wizard |
| C. | Create Table by Entering data |
| D. | All of above |
| Answer» E. | |
| 123. |
What is the use of description field in table design window? |
| A. | The description will be displayed on status bar when entering data in datasheet view |
| B. | The description will be displayed on status bar when entering data in form |
| C. | Both of above |
| D. | None of a the above |
| Answer» D. None of a the above | |
| 124. |
The operation of checking input data against specified criteria is known as? |
| A. | Data verification |
| B. | Data validation |
| C. | Cross check |
| D. | Data control |
| Answer» C. Cross check | |
| 125. |
Which of the following columns does not exist in macro design window? |
| A. | Arguments |
| B. | Comments |
| C. | Conditions |
| D. | Actions |
| Answer» D. Actions | |
| 126. |
The ‘filter by selection’ allows you to filter those records |
| A. | That match the selected field |
| B. | That match the criteria specified |
| C. | That meet any of several criteria specified |
| D. | All of above |
| Answer» B. That match the criteria specified | |
| 127. |
The three parts of an IIF function are separated by _____. |
| A. | dashes |
| B. | asterisks |
| C. | semicolons |
| D. | commas |
| Answer» E. | |
| 128. |
In Access press SHIFT+F10 to |
| A. | Display the Control menu |
| B. | Display the shortcut menu |
| C. | Close the active window |
| D. | None of these |
| Answer» C. Close the active window | |
| 129. |
This form displays multiple records, one per row, in the form window |
| A. | Datasheet |
| B. | Tabular |
| C. | Columnar |
| D. | Justified |
| Answer» B. Tabular | |
| 130. |
Which of the following is not a selection technique ? |
| A. | To select a word, double click the word |
| B. | To select an entire table click the empty bosx to the left of the field names |
| C. | To select a row, click the record selector box to the left of the row |
| D. | To select a column, double click anywhere in the column |
| Answer» E. | |
| 131. |
To create primary key for a table when in design view |
| A. | Type PRIMARY in field type box when creating required field |
| B. | Mark the Primary check box in field name of required field |
| C. | Click the Primary Key button in Design ribbon when the cursor is in required field |
| D. | None of the above |
| Answer» D. None of the above | |
| 132. |
The ascending order of data hierarchy is? |
| A. | Bit - byte - field - record - file - databse |
| B. | Bit - byte - record - field - file - database |
| C. | Byte - bit - field - record - file - database |
| D. | Bit - byte - field - record - database - file |
| Answer» B. Bit - byte - record - field - file - database | |
| 133. |
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command? |
| A. | Home Tab |
| B. | Create Tab |
| C. | External Data Tab |
| D. | Database Tab |
| Answer» E. | |
| 134. |
Which of the following is NOT true about background images? |
| A. | They are similar to watermarks in Word. |
| B. | They are displayed behind the controls in a form. |
| C. | They do not print when a form or a report is print |
| Answer» D. | |
| 135. |
The __________ is the software tool to store or access data. |
| A. | table |
| B. | DBMS |
| C. | query |
| D. | report |
| Answer» C. query | |
| 136. |
To set a password for the database, select ____________ in the Microsoft Access open window. |
| A. | Open read only |
| B. | Open write only |
| C. | Open explicit |
| D. | Open exclusive |
| Answer» E. | |
| 137. |
You add a table to the query design window |
| A. | Select Edit>Add Table from the menu |
| B. | Select Tools>Add table from the menu |
| C. | Click the Show Table button on the toolbar |
| D. | Select the table from the Table list on the toolbar |
| Answer» D. Select the table from the Table list on the toolbar | |
| 138. |
What is the purpose of the description column in Table Design View? |
| A. | To define the data type applied to each field within the table |
| B. | To describe the data that should be entered in each field |
| C. | To enter lookup data that the field should refer to. |
| D. | None of the above |
| Answer» C. To enter lookup data that the field should refer to. | |
| 139. |
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove? |
| A. | You need to delete the whole table. There is no method to remove a particular field only. |
| B. | Delete all the fields from third downwards and reenter the required fields again. |
| C. | Select the third column in datasheet view then delete |
| D. | Select the third row in table design view then delete |
| Answer» E. | |
| 140. |
Which is NOT an option of the Picture Size Mode property? |
| A. | Clip |
| B. | Fit |
| C. | Stretch |
| D. | Zoom |
| Answer» C. Stretch | |
| 141. |
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 |
| A. | A parameter query |
| B. | A crosstab query |
| C. | An update query |
| D. | An action query |
| Answer» B. A crosstab query | |
| 142. |
In Access press DOWN ARROW or CTRL+DOWN ARROW |
| A. | Move the selected control to the right (except controls that are part of a layout) |
| B. | Move the selected control to the left (except controls that are part of a layout) |
| C. | Move the selected control up |
| D. | None of these |
| Answer» E. | |
| 143. |
Which editor was provided for use with Access Basic? |
| A. | The Visual Basic 1.0 editor |
| B. | Notepad |
| C. | The QuickBasic editor |
| D. | All of above |
| Answer» C. The QuickBasic editor | |
| 144. |
All attachment fields display as a(n) ____ in Datasheet View. |
| A. | icon |
| B. | button |
| C. | thumb tack |
| D. | paperclip |
| Answer» E. | |
| 145. |
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 |
| Answer» C. Option button | |
| 146. |
You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view |
| A. | Clicking |
| B. | Right clicking |
| C. | Double clicking |
| D. | None of the above |
| Answer» D. None of the above | |
| 147. |
Which of the following statements about calculated fields is NOT true? |
| A. | A calculated field does not store data in a recordset. |
| B. | Calculated fields use an expression or formula as its data source. |
| C. | Data contained in a calculated field is created the first time a query is run. |
| D. | A calculated field can be created using the Expression Builder dialog box. |
| Answer» D. A calculated field can be created using the Expression Builder dialog box. | |
| 148. |
A(n) _____ is a control that, when clicked, executes an action or series of actions. |
| A. | combo box control |
| B. | AutoFormat |
| C. | Conditional Format |
| D. | command button |
| Answer» E. | |
| 149. |
If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called: |
| A. | Foreign key |
| B. | Native key |
| C. | Composite key |
| D. | Primary key |
| Answer» B. Native key | |
| 150. |
HTML stands for ____. |
| A. | High Text Mail List |
| B. | Hyperlink Markup Language |
| C. | HyperText Markup Language |
| D. | Hyperlink Transfer Markup Language |
| Answer» D. Hyperlink Transfer Markup Language | |